Take the 2-minute tour ×
Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. It's 100% free, no registration required.

Are there any free, open source VBA addins or R packages that can be linked using the yahoo finance/Google finance/other data sources api to continuously download intraday data into excel or R?


This is the closest I have found to loading D/M/Y prices into excel but it doesn't allow for intraday. I have a few charts with my own technical indicators that I would love to have have refreshed every few seconds with new data. I know that yahoo finance only provides delayed data but that's not an issue for me.

I miss having Bloomberg :(

share|improve this question
add comment

2 Answers 2

you need real-time tick in order to achive this. IB, esignal, iqfeed both provides RTD/DDE api to excel integration.

share|improve this answer
Hi Clebson, thank you for sharing this. Any free data providers that can allow you to load intraday data into excel? I don't mind if its delayed and I am not concerned if its not tick. –  jessica Jul 1 '13 at 22:47
@jessica Yahoo offers 15 minutes delayed stock updates. They have a CSV you can download and parse it quite easily. so in your excel sheet just set a timer using an excel API ( Application.OnTime ) as for example (: –  Clebson Derivan Jul 1 '13 at 23:26
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.