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 will tell others who want to go into trading that DTN ProphetX is an invaluable tool, I don't think anyone can trade without it..." - Comment from Luther
"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
"I've been using Neoticker RT with IQFeed for two months, and I'm very happy with both of the products (I've had IQFeed for two years with very few complaints). The service from both companies is exceptional." - Comment from Public Forum
"Previously I was using *******. IQFeed is WAY more economical, and for my charting needs is just as good, if not better." - Comment from Public Forum Post
"I have been using IQFeed now for a few years in MultiCharts and I have zero complaints. Very, very rare to have any data hiccups or anything at all go wrong." - Comment from Public Forum
"For anyone considering using DTN.IQ for a data feed, my experience with the quality of data and the tech support has been very positive." - Comment from Public Forum
"This is an excellent value, the system is generous (allowing for 500 stocks) and stable (and really is tick-by-tick), and the support is fantastic." - Comment from Shirin via Email
"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.
"Everything is working great ! Very impressive client. The news refreshes better and is more pertinent than the ******* feed I paid $ 100/month for. I Also like the charts a lot." - Comment from Leon
"DTN has never given me problems. It is incredibly stable. In fact I've occasionally lost the data feed from Interactive Brokers, but still been able to trade because I'm getting good data from DTN." - Comment from Leighton
Home  Search  Register  Login  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 »Price doesn't match b/w Excel functions and ProphetX
Author Topic: Price doesn't match b/w Excel functions and ProphetX (4 messages, Page 1 of 1)

Chrisnliu
-Interested User-
Posts: 2
Joined: Apr 5, 2012


Posted: Apr 5, 2012 12:17 PM          Msg. 1 of 4
I had a hard time to solve this problem but not successful:

On Excel spreadsheet, I have a formula to download NYMEX natural gas price for May 2012 (NGK2):

=ProphetX|QUOTE!'qngk2[DTN:NYMEX:DELAY]?Settle'

The value returned by this formula is $2.819, but on ProphetX the same futures are traded at $2.135 now! How can these two prices are different?

Thanks!

tribalmarine
-Interested User-
Posts: 2
Joined: Apr 5, 2012

Advanced ProphetX User


Posted: Apr 5, 2012 01:12 PM          Msg. 2 of 4
The formula you posted for the settle price.

=ProphetX|QUOTE!'qngk2[DTN:NYMEX:DELAY]?Settle'

I'm showing the settle price for QNGK12 at 2.141.
I'm confused as to why you are seeing a different settle price of 2.819. Looking at the contract chain for QNG AND NG, I don't see that settle price anywhere. It sounds like some troubleshooting is in order.


A couple observations:

1. The symbol you are using QNGK2 is the electronic symbol for Natural Gas. This is different from the pit traded symbol NGK12. When it comes to the settle price however, they should match. The exchange uses the same settle price for both last I checked. FYI -- The same cannot be said for the live trading price throughout the day.

2. QNGK2 is also the one-digit-year version of the symbol QNGK12. It's likely this doesn't matter, since ProphetX should translate QNGK2 into QNGK12 automatically.

3. Looking at your formula, I'm wondering what version of ProphetX you are using. This is an old formula. If you are relatively up-to-date with the client version, I might suggest you try this formula and see if the value is different. Try it in a new spreadsheet as a test.

=ProphetX|QUOTE!'dtn:nym:QNGK12?SettlementPrice'

If the values are different, there is a problem. At that point, I'd suggest calling customer support.
If they match, double check the settle price in ProphetX.


The best way to create a formula from ProphetX to paste into Excel is to:
a. right click the selected cell or cells in ProphetX and choose "Format Excel Link".
b. Then paste in Excel.
Note: if you do not see "Format Excel Link" option when you right-click, you have a older client. In which case the steps are a little different.


4. Another thing to check on the excel spreadsheet is to see if the values are updating from ProphetX. If the spreadsheet is not setup to update the calculations automatically, it can prevent the formula linked data (aka DDE) from updating. In that case, the value you see in the spreadsheet could be stale from some time in the past.
A quick check to see if this is the case is to press F9 to recalculate or check to see if you have any formulas that display the 'Last' value. If the contract is trading actively in ProphetX, they should also update in Excel as well. If they are, then automatic calculations are not the issue.

If that doesn't check out, perhaps you could attach your spreadsheet and I could take a look.

Chrisnliu
-Interested User-
Posts: 2
Joined: Apr 5, 2012


Posted: Apr 5, 2012 11:05 PM          Msg. 3 of 4
Thanks! I called DTN help desk and found out my Google Chrome is interfering DTN to update prices...

tribalmarine
-Interested User-
Posts: 2
Joined: Apr 5, 2012

Advanced ProphetX User


Posted: Apr 6, 2012 09:06 AM          Msg. 4 of 4
Really?? Strange.

Care to share what you did to fix the issue? I use Chrome, so I'd hope to avoid any issues.
 

 

Time: Sat September 21, 2019 6:22 PM CFBB v1.2.0 0 ms.
© AderSoftware 2002-2003