But, obtaining market data is very hard and cost intensive because the stock exchanges do not want to provide real-time data for free. Ok, but what can you do about it? In some cases, website provide a limited set of real-time data which you can obtain using the description: How do you get free historical market data?
But, usually the data you see is with 15min delay. However, this solution has many drawbacks. An important one is: Even if you get near real-time data from a website, you still need a mechanism to automatically pull the data and push it into your platform. If you can afford it, the best solution is usually a commercial solution from a large data vendor, e. They deliver speedy and reliable market data right into MS Excel and often, they have interfaces for Matlab or Java, too.
But they cost several hundreds of dollars and euro per month. On the positive side, these market data vendors deliver also insight into the order book, which is extremely important for intraday trading. If you need to save some money — and use it for trading: Go for the second best solution and get the data from your broker.
But, only very few brokers provide a good api and plug-ins for MS Excel or Matlab etc. Now, there is a third alternative, which might be good enough for you: It is free and it pulls free data into your MS Excel as a real-time data feed.
But, for testing your trading strategy with a real market data feed, it is totally sufficient. FinAnSu pulls the data from Google, yahoo! But, you get new ticks e. So, if you can live with a 15min data delay and without order book, go for FinAnSu.
Otherwise, real trading requires real investments into data and you have to go for a commercial data vendor. You can use Spearian for Excel http: NET, quite simple to access previously saved data, They have bundled samples which fetches sp, nasdaq, hsi, ftse, csi, kospi, yield cuves, to macro economic data.
You can use the spreadsheet at http: Their infrastructure is always ready for cloud storage back-up and reference. You always get the option of dowloaing the results with CSV file. However, they take a nominal fees to use all their APIs. Thanks for your information! Due to your post, I downloaded the Finansu adds-in and use it. And is Finansu suitable for getting the ETF data? I use MarketXLS for this. It worked great for me. May be it would help: Yahoo Finance API is not working anymore.
I switch to MarketXLS. They have regular updates and customer support. It cost a little but it will save you time. You are commenting using your WordPress. You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. Commercial Solutions If you can afford it, the best solution is usually a commercial solution from a large data vendor, e.
Low Budget Solutions If you need to save some money — and use it for trading: Conclusion So, if you can live with a 15min data delay and without order book, go for FinAnSu.
Nash January 7, Muqil September 6, Bryam Fairn July 11, Chris April 9, Harrison Roxas Delfino April 17, Minnie Owen November 22, Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in: Email required Address never made public.More...