AMA
-DTN Evangelist-
Posts: 183
Joined: Aug 1, 2007
|
Posted: Mar 15, 2011 05:49 PM
Msg. 1 of 6
Hi - I'd like to retrieve some tick data directly into an Excel spreadsheet. Right now, I have to bring up a DTNIQ T&S window, retrieve the data then manually save it to disk in .csv format. After that, I can import it into Excel and do my thing.
Is there an easy way to load xxxx tick elements directly into an Excel column, possibly using some kind of 'IQLink' statements similar to what I already use for other DTNIQ items in my sheet?
I'm using Excel 2007.
|
DTN_Jay_Froscheiser
-VP, Product Operations-
Posts: 1746
Joined: May 3, 2004
DTN IQFeed/DTN.IQ/DTN NxCore
|
Posted: Mar 15, 2011 11:38 PM
Msg. 2 of 6
There isnt anything native in DTN.IQ. We do have an excel addin (add-on) for prophetx that can do this. Or, with DTN.IQ/IQFeed, i would suggest looking at one of the third party apps such as XLQ OR QuoteIN. They both provide great tools for pulling in data other than the DDE streaming data we natively provide.
Jay Froscheiser DTN
|
AMA
-DTN Evangelist-
Posts: 183
Joined: Aug 1, 2007
|
Posted: Mar 16, 2011 11:38 AM
Msg. 3 of 6
Thanks, Jay - I'll check out the 3rd party apps
|
AMA
-DTN Evangelist-
Posts: 183
Joined: Aug 1, 2007
|
Posted: Mar 27, 2011 12:16 PM
Msg. 4 of 6
Jay, could you post the name of the Prophetx add-on for Time & Sales/Excel ? Thanks.
|
DTN_Jay_Froscheiser
-VP, Product Operations-
Posts: 1746
Joined: May 3, 2004
DTN IQFeed/DTN.IQ/DTN NxCore
|
Posted: Mar 27, 2011 12:35 PM
Msg. 5 of 6
|
AMA
-DTN Evangelist-
Posts: 183
Joined: Aug 1, 2007
|
Posted: Mar 27, 2011 01:27 PM
Msg. 6 of 6
Thanks for the quick response, Jay...I already have a ProphetX subscription, so will look into that more, time permitting.
|