Join the 80,000 other DTN customers who enjoy the fastest, most reliable data available. There is no better value than DTN!

(Move your cursor to this area to pause scrolling)




"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip
"If you are serious about your trading I would not rely on IB data for serious daytrading. Took me a while to justify the cost of IQ Feed and in the end, it's just a 2 point stop on ES. Better safe than sorry" - Comment from Public Forum
"I just wanted to let you know how fast and easy I found it to integrate IQFeed into our existing Java code using your JNI client. In my experience, such things almost never go so smoothly - great job!" - Comment from Nate
"I started a trial a few weeks back before the market went wild. DTN.IQ didn’t miss anything and beat my other provider. I decided to stay with you because of the great service through all the volatility." - Comment from Mike
"After all the anxiety I had with my previous data provider it is a relief not to have to worry about data speed and integrity." - Comment from Eamonn
"I would just like to say that IQFeed version 4 is running very well and I am very happy with its performance. I would also like to extend a big thanks for the fast and efficient help that I always receive. My questions and concerns are always addressed promptly. Way to go!" - Comment from Josh in CO.
"Its working FABULOUSLY for me!! Holy cow...there has been so much I've been missing lately, and with this feed and Linnsoft software...I'm in the game now." - Comment from Chris R.
"Thank God for your Data Feed as the only Zippers I see are on my pants (LOL), and no more 200 pip spikes to mess up charts." - Comment from Spiro via Email
"I just wanted to tell you what a fine job you have been doing. While *******, from what I hear, has been down and out, off and on, IQ feed has held like a champ this week." - Comment from Shirin
"I'm satisfied with IQFeed. It's the most reliable and fastest quote feed I have ever used. Although I'm a resident in China, it's still very fast!" - Comment from Xiaofei
Home  Search  Register  Login  Blogs Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather
Follow DTNMarkets on Twitter
DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter
»Forums Index »Product Support »ProphetX Support »DDE Options and Excel
Author Topic: DDE Options and Excel (5 messages, Page 1 of 1)

nikolasp
-Interested User-
Posts: 4
Joined: Mar 31, 2006


Posted: Jul 23, 2007 03:56 PM          Msg. 1 of 5
Hello,

I currently have the latest version of ProphetX and I have live NG prices on my spreadsheet to generate certain signals.

If I have an ATM NG strike options (e.g. "=ProphetX|QUOTE!'NGQ7C6050[DTN:NYMEX]?Last' ") on my spreadsheet how can I make sure that the strike changes as the underlying is changing? With Bloomberg one can use various Excel functions like concatenate to make sure that, in the above example, the strike (6.050) changes as the market moves. Is this possible with ProphetX and the DDE link?

Thanks,

Nick

DTN_SarahS
-DTN Evangelist-
Posts: 195
Joined: May 31, 2007


Posted: Jul 24, 2007 03:14 PM          Msg. 2 of 5
Hi Nick,

Sorry it took so long to reply. The formula you are looking at only retrieves the field “last” to the spreadsheet – the at the money is a calculated value that changes every time the underlying price changes and there is no field to output it. It’s a separate row on the options display, not just one field. You would have to display one of the options pages to display at the money.

If you have furhter questions, please contact Prophet X Support at 1 (800) 532-0136.

Thanks,

Sarah Sexton

nikolasp
-Interested User-
Posts: 4
Joined: Mar 31, 2006


Posted: Jul 25, 2007 10:29 AM          Msg. 3 of 5
I understand that it is a calculated field but is there a way for me to calculate the field in a way that ProphetX would understand - or more accurately the DDE link in Excel would be able to accept?

Thanks,

Nick

DTN_SarahS
-DTN Evangelist-
Posts: 195
Joined: May 31, 2007


Posted: Jul 25, 2007 10:50 AM          Msg. 4 of 5
Hi Nick,

There is currently no field available to pull at the money – options are still a work in progress and eventually we want to be able to link directly from the options page rather than quotes, but that’s a ways off and until that project gets started I don’t know if we will be able to pull at the money dynamically then either. I will deffinetely forward your suggestion, and you may want to post in the PX wish list forum as well.

Thanks,

Sarah

nikolasp
-Interested User-
Posts: 4
Joined: Mar 31, 2006


Posted: Jul 25, 2007 12:57 PM          Msg. 5 of 5
Thank you!
 

 

Time: Sat April 20, 2019 3:13 AM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003