Stock data feeds into Excel

[NoMoWork]

Tom showed a Morningstar data feed into Microsoft Excel in the last Group 1 meeting. What version of Excel was he using? My Excel 2016 does not seem to have that function availabe.

 

[status1]

I did not see the video yet but I clicked on the link provided and it looks like it's only available to Office 365 users
and according to this video it was only added recently a few months ago

 

[jim leahy]

i discovered a data source that has an excel add-on to retrieve stock data (no options) from their
api. they have a limited free subscription level, but you have to sign up and get an api key. you're
limited to 8 requests per minute and 800 requests per day with the free subscription. if you don't
trust excel macro add-ons, you can construct a REST url and download csv data. when i find some time i'll
write some macros to download data directly from excel and make it available. the url is
twelvedata.com. i signed up but have only played with their demo data so far.

 

[jim leahy]

i have a spreadsheet that will download data from twelvedata.com. it just does basic https downloads
from their api. you can read the api documantaion on their web site to determine what data you can get.
you will need an api key to use this spreadsheet, and is free once you register. the spreadsheet uses macros,
but they're very simple. the screen capture below shows what it looks like. i uploaded to my amazon cloud
and you can download it from there. i included a button to get your api daily usage. hopefully, the rest of
the usage is self-explanatory.
https://www.amazon.com/clouddrive/share/6JdaMFwmhOYul7sJ470dWL5IxYy87UxpJKPyI5pmreS