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 /JSON and Power query.

I am trying to retrieve this table in Excel (I use Excel 2010 and/or Excel 365):
https://query1.finance.yahoo.com/v8...od1=1548528704&period2=1549047113&interval=1m

How would I be able to setup a working table that would refresh depending on ticker cell in column A ("CCC" in the example above") and date range in Col B and C?

Many thanks,

Tony

 

[alansidman]

You might want to try using Power Query to import the table and then be able to manipulate the data.

 

[tonyfonda]

This is where I am getting stuck really despite hours of trial.
It works well by uploading the JSON CSV from the drive but I can't figure out how to import it automatically from the web.

 

[tonyfonda]

I found a working solution whilst trolling the web - could someone help me replace the URL in this workbook:

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

With the following URL: https://query1.finance.yahoo.com/v8/...13&interval=1m

Thanks again.

Tony