Excel RealTime Charts

Sanity · Mar 16, 2005

hi, does anyone know of a data provider other than realtick that will give realtime chart tables in excel? most provide streaming dde links, but i have yet to find someone other than realtick that allows for a realtime chart table. thanks in advance.

Strategery · Mar 16, 2005

One option-
You can write a macro in VBA that will copy and paste (the dde data you have) in a specefied timeframe using the excel timer and create a chart with the data. It will be snapshots though not OHLC.

Sanity · Mar 16, 2005

that would be great, i've done some searches here for a script, but they don't seem to work. if you could post one or suggest a place to look, it would be greatly appreciated. thanks again!

Strategery · Mar 16, 2005

Sent ya a PM

qtip · Mar 16, 2005

Try www.Spooz.com

Lawrence Chan · Mar 17, 2005

NeoTicker does that in user specified time frames.
e.g. 3-sec, 1-min, 2-min, 2-hr, 3-hr, etc.

You can even get indicator values into Excel.

Lawrence

Quote from Sanity:

hi, does anyone know of a data provider other than realtick that will give realtime chart tables in excel? most provide streaming dde links, but i have yet to find someone other than realtick that allows for a realtime chart table. thanks in advance.

ilcaa · May 24, 2005

I just made some calls last week to several providers looking for a real time DDE connection to a tick server (each trade with volume) at IQFeed.net provides it for 65 per month..i havent found anyone else, esignal connects you to there quote server (hi, low, cum vol, etc ) but not a tick server.

EdgeHunter · May 24, 2005

Quote from ilcaa:

I just made some calls last week to several providers looking for a real time DDE connection to a tick server (each trade with volume) at IQFeed.net provides it for 65 per month..i havent found anyone else, esignal connects you to there quote server (hi, low, cum vol, etc ) but not a tick server.

eSignal DDE has a field called last trade size which is the volume for the last trade print... is that THE field you are looking for or is there something more...

ilcaa · May 24, 2005

looking for each bid/ask trade plus its volume, the "last trade" field gives you the volume of each last trade how would you know if its on the bid or ask?

thanks for the reply and help.

EdgeHunter · May 24, 2005

Quote from ilcaa:

looking for each bid/ask trade plus its volume, the "last trade" field gives you the volume of each last trade how would you know if its on the bid or ask?

thanks for the reply and help.

That's possible but tricky... you would have to have a VB change event code that grabbed the bid and ask values on each last print change and then compared the last print value to both of them to see which one matched and if not a match then is it above ask or below ask or in middle of spread - might be a wee bit cpu intensive but if valuable is doable...