Intraday stock data from Yahoo Finance using JSON

[tonyfonda]

Hi all,

This is my first post here - Please be kind: I am new to VBA.

Can someone help me with replacing the Get URL in the VBA of this workbook:

investexcel.net/multiple-stock-quote-downloader-for-excel/

with this URL inestead:

query1.finance.yahoo.com/v8/finance/chart/CCC?symbol=CCC&period1=1548528704&period2=1549047113&interval=1m


Many thanks,

Tony

[tonyfonda]

anyone thoughts guys?

[GeoffW283]

I'll reply only because nobody else has - I'm no expert but hopefully this is some help and even more hopefully someone else will jump in.

I downloaded the investexcel.net workbook that you mention. If you right-click the Parameters worksheet and select "View code" you will get to the VBA editor. Now double-click on Module1 and search for "tickerURL". I think this is the URL that you are trying to replace. That said, the parameters look different. Your yahoo query does return JSON, but is it the JSON that the rest of the VBA is expecting???

[tonyfonda]

Thank you Geoff.
I appreciate that my post is unconventional, in the sense that one would expect me to post a code snippet instead. This may be holding some from replying.
I am rather coming out clean as a newbie rather than posting the wrong piece of code...