I've trying to create a trading system, but am hitting a big road block because of difficulty of importing real-time data into Excel 2007. I know how to use Excel and the import data from the web part, but when I import the data (google Finance, yahoo Finance, WSJ.com) it comes out cluttered (more information than I want). I'm aware of stock price programs you can download into Excel, but they don't work well for me. I need to learn how to do it myself cleanly in order to build the system. Maybe there is another provider/website I should use? Ideally a free one with real-time quotes (Yahoo has BATS quotes). What are some subscription sites that provide lots of data, real-time quotes, and are easily transferred into Excel?
http://www.iqfeed.net/index.cfm?displayaction=data§ion=services http://www.marketfeed.com/mlink.htm if $20 is too much for ya..i guess you are in wrong business..
No $20 is fine.... My post was incomplete.. I left out the part about my use of economic data and don't want to use something like a Bloomberg Terminal that runs $1,500 a month
Economic data intraday... Simple stuff I can get on wsj.com http://online.wsj.com/mdc/public/page/2_3024-EconomicCalendar.html?mod=mdc_h_cmgrel
economic data it's like one request a day. it's did not change every second..imo-no big deal to grab it from free source using web querry or something..
Yea but when you try to import a single piece of data into Excel from wsj.com, it imports a bunch of random stuff. If you haven't done this personally, you're not going to understand what I am trying to say.