CODEWITHSUNDEEP
yqlyahoo-apiyahoo-finance
FriendsKenny
FriendsKenny

Reputation: 150

Get hour data from yahoo finance

How can I get finance gata from yahoo.finance in realtime? I tried select * from yahoo.finance.historicaldata but there only data by day not by hours.

Upvotes: 1

Views: 3283

Answers (1)

Cᴏʀʏ
Cᴏʀʏ

Reputation: 107586

You're querying a table called historicaldata, it is probably only updated once a day. Another table, quotes, may have data updated on a more frequent timer (hourly, as you've mentioned).

Unfortunately, I think you've run into a limitation of Yahoo's free financial data feeds. They have to purchase market feeds from the source (NASDAQ, NYSE, etc.) (or close to it) and those feeds aren't cheap. If you want truly real-time data, that's something you'll probably have to cough good money out for.

There are other sources besides Yahoo though that might get you down to 15 minute updates. I will leave that research as an exercise for you since that's out of scope for StackOverflow. If you do find a different source and are having trouble reading from it, do please feel free to ask another question here! The more closely related to actual programming the better response you'll get from the community.

Upvotes: 1

Related Questions