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 "bracket trade" all major news releases and I have not found one lag or glitch with DTN.IQ feed. I am very comfortable with their feed under all typical news conditions (Fed releases, employment numbers, etc)." - Comment from Public Forum
"Everything is working amazing now. I'm already impressed with the true-tick feed of IQFeed and it's ability to support my 480 symbol layout." - Comment from Tyler via Email
"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
"My broker in Davenport suggested I give you a try as he uses your service and says its the best." - Comment from Bill via RT Chat
"Interactive Brokers tick data was inconsistent, so I have switched to using DTN exclusively. It is great to no longer have to worry about my datafeed all day long." - Comment from Philippe
"I am a hedge fund manager here. It’s funny, I have a Bloomberg terminal and a Bridge feed, but I still like having my DTN feed!" - Comment from Feras
"I am very happy I changed. I love the product, but more so I am thrilled with Tech Support. You are knowledgeable, polite, pleasant and professional." - Comment from Pat
"Everything is working great with the API. I love it." - Comment from Calvin
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"DTN feed was the only feed that consistently matched Bloomberg feed for BID/ASK data verification work these past years......DTN feed is a must for my supply & demand based trading using Cumulative Delta" - Comment from Public Forum Post
Home  Search  Register  Login  Blogs Recent Posts

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

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


Posted: Sep 15, 2006 08:46 AM          Msg. 1 of 2
Has anyone had any success with creating a volatility surface for NYMEX natural gas options in Excel by linking the options quotes from ProphetX?

I have set up a spreadsheet with links to the ATM gas options contracts. The spreadsheet has the current premium, previous premium and the ATM volatility for a number of contracts. The problem is that the ATM options change every day which makes it difficult to manually update them all at the end of the day. With Bloomberg and Excel one is able to create a "dynamic" ATM contract using concatenation, etc. Is there a way to do that with ProphetX?

Thanks!

margep
-DTN Evangelist-
Posts: 119
Joined: Sep 13, 2005


Posted: Sep 15, 2006 09:50 AM          Msg. 2 of 2
Hello,
Other users may have been able to manipulate their spreadsheets with this information but we do not have currently have a spreadsheet available to do this. But you may still hear from other users who are willing to share their techniques with you....

We are, however, in the process of upgrading our options module to include various charting capabilities based on the volatility and directly from the options module, as well as linking directly from options. This should, in some cases, eliminate the need to do a lot of the current linking you're doing from the quote sheets. The plan is for implementation in version 3.4, scheduled for year end - hopefully sooner.
Regards,
Marge
 

 

Time: Sat February 16, 2019 2:57 AM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003