Help to import data directly to Excel

Question

Hi,&nbsp;I have seen examples online to be able to import data directly into excel. Examples of these which i am hoping to use include stock prices, commodity prices and interest rates. I have found websites which are able to supply the information, however i have not been able to master the import/macro. I am aiming to import a large data set.&nbsp;Is anyone able to assist?

nabilmourad · Answer

calof1&nbsp;Hi,Importing Data into Excel can be done in so many ways using different tools from Basic to Power Query. All these tools are available on the Data Tab of the Ribbon.This is more than a Full Day course. Can't be cover in this reply.However, I am attaching 3 different examples from my YouTube Channel&nbsp; where I use Power Query and Stock Data Types. You are free to explore:https://www.youtube.com/watch?v=ten9JNWmjQA&nbsp;https://www.youtube.com/watch?v=jEr3uj1ljQ8&nbsp;https://www.youtube.com/watch?v=dXQtcU44I_0&nbsp;Hope that helpsNabil Mourad&nbsp;

sergeibaklan · Answer

calof1&nbsp;
Perhaps you mean linked data types
https://support.office.com/en-gb/article/excel-data-types-stocks-and-geography-61a33056-9935-484f-8ac8-f1a89e210877
https://www.howtoexcel.org/general/data-types/

calof1 · Answer

Thanksnabilmourad&nbsp;&nbsp;This was interesting and helpful

Forum Discussion

Help to import data directly to Excel

3 Replies