recording dynamic data in excel

Quote from Bernoulli:

That's my point. There is no target parameter.
More...

Ah, yes forgot about that, sorry.

What you might want to do is have a UDF that uses the cell where you have your DDE link. It will be called everytime the value changes. You can do your processing then.... you'll probably want to keep an internal array in VBA of the ticks, and a global indicator to let you know if there has been a tick update since the last calculate. Then in the calculate event, if there has been an update, go ahead and update your cells accordingly for the chart cause you can't update cells from a function called from the worksheet.

Cash
 
Quote from EdgeHunter:

Which quote feed are you using with that
RTD product...

cj...
More...

Hey Edge,

DTN IQ is probably one of the best all around data feeds for the retail trader.

It has a nice charting system (I use it with Medved Quotetracker though) and, to the point many 3rd party add-ons designed to take advantage of its extremely diverse data feed capabilities.

The only one close to it (and in fact, surpassing it) is Interactive Brokers's data feed, but they don't have very good historical info.

Hope that helps.

JJ

edit: when adding everything together like this, it can get pretty pricey, so make sure you what you want, and why you want it, before you start laying out the cash.
 
Quote from JimmyJam:

Hey Edge,

DTN IQ is probably one of the best all around data feeds for the (small) retail trader.

It has a nice charting system (I use it with Medved Quotetracker though) and, to the point many 3rd party add-ons designed to take advantage of its extremely diverse data feed capabilities.

The only one close to it (and in fact, surpassing it) is Interactive Brokers's data feed, but they don't have very good historical info.

Hope that helps.

JJ
More...

Thanks... JJ'

How many symbols MAX do you get... and what is the cost of those symbols for the spreadsheet feed...

cj...

:confused:

__________________
HAVE STOP - WILL TRADE

If You Have The Vision We Have The Code
 
Quote from EdgeHunter:

Thanks... JJ'

How many symbols MAX do you get... and what is the cost of those symbols for the spreadsheet feed...

cj...

:confused:

__________________
HAVE STOP - WILL TRADE

If You Have The Vision We Have The Code
More...

I only track the e-mini's (s&p, nasd, dow), so the setup really works for me.

Everyone plays their game a little differently here.

Some like the options, others like to swing trade stocks, still others are into bonds and notes.

You'd have to check-in with DTNIQ to see what setup fills your bill.

I use Medved Quotetracker/IQ Feed/QuoteIN, the combo works pretty well for me and should take care of anything that the thread originator had in mind.

Later,

JJ
 
You must log in or register to reply here.
Back
Top