Intra-day Data for Excel

[Northern boy 10]

Does anyone know where to get Intra-day data for Excel? Preferably free, but if not that's fine too. Looking ideally for forex data, but commodities and equities will do. Website I used to use isn't working anymore.

 

Thanks

[Tams 20]

It is free (satisfied one of your requirements), but I don't know if it can be connected to Excel.

 

I have not tried it and do not know its quality.

 

http://www.bestfreecharts.com/

Edited April 15, 2009 by Tams

[BlowFish 10]

I'm beginning to sound like an Interactive Brokers salesman but it feeds starlight into Excel using DDE or OLE (which is called something else nowadays). Note its 'real time data' is actually aggregated into 200milliseconds (from memory) chunks.

[Northern boy 10]

thanks, more sources welcomed.

[Frank 10]

most brokerages have a download data option which is quite simple. I have searched for public data on this in the past and could not find it.

 

I saw someone say that barchart.com allows this but at the time, I couldn't figure that out:

 

http://charts.barchart.com/chart.asp?sym=ESM9&data=Z10&date=121108&den=MED&divd=n&evnt=off&grid=N&jav=ADV&size=D&sky=N&sly=N&vol=N&late=Y&ch1=011&arga=&argb=&argc=&ov1=&argd=&arge=&argf=&ch2=&argg=&argh=&argi=&ov2=&argj=&argk=&argl=&code=BSTKIC&org=stk

[Eiger 10]

ANF has clean data on a 1-minute basis for eminis, yen, FX, NQ & ER going back to the inception of the contracts. Downloads into excel and inexpensive.

 

http://www.anfutures.com/

[Northern boy 10]

thanks. any for commodities or specific stocks?

[Northern boy 10]

Forex Historical Data has tons (going back to 1980) of free intraday forex data in CSV format that can be uploaded to a spreadsheet (at least I assume it can).

[Harlequin 10]

Not free, but for a very high quality feed at a reasonable price I would recommend DTN IQfeed which a DDE link. It also gives access to many extra fields like 52 week high/low open interest etc.

[Flojomojo 10]

I can also recommend the IB datafeed you can get with Excel. With their datafeed you can also get historical data upto one year into the past. If you are looking for backtest data, GainCapital has a tick by tick database available here.