pulling data from a website

[arniebun]

hi i was wondering how i would go about getting currency, stock and indices weekly data pulled from updates on investing.com and it would update in an excel spread sheet by its self? you help would be much appreciated. thanks

 

[DRSteele]

Must it be that website? After all, Excel has Stock Data Types now.

See this article and this video.

 

[arniebun]

thanks for replying, no just the information would be great whats stock data types i don't know this. i do want to get other data as well, like pmi.

 

[DRSteele]

You will need to use something like Power Qeury to extract data from webpages. In fact I use PQ to fetch commodities data from that particular website.

Do you know PQ?

 

[arniebun]

haven't got a clue, am totally new to all this, have just brought a course using JSnode to do web scraping. I am going to want it to collected other financial data as well but really need the stock market returns because would save me loads of time.

 

[alansidman]

Look at this link. http://www.michael-saunders.com/stocksapp/pages/info.html

 

[arniebun]

Look at this link. Stock Connector add-in for Excel

Thanks for this, sorry i never come back to you, i ended up learning python webscraping, but the link you posted has now become massively useful so thanks so much