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've never had DTN go out on me since switching. ******* would go down a couple times every month when I was using them." - Comment from Bryce in AL.
"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 noticed that ******* quotes locked up shortly after the interest rate announcement yesterday while yours stayed stable." - Comment from Ron in Utah
"As a past ******* customer(and not a happy one), IQ Feed by DTN is a much better and cheaper product with great customer support. I have had no problems at all since switching over." - Comment from Public Forum
"Thanks for the great product and support. During this week of high volume trading, my QuoteTracker + IQ Feed setup never missed a beat. Also, thanks for your swiftness in responding to data issues. I was on ******* for a few years before I made the switch over early this year, and wish I had done it a long time ago." - Comment from Ken
"I ran your IQFeed DDE vs. my broker vs. a level II window for some slow-moving options. I would see the level II quote change, then your feed update instantaneously. My broker's DDE, however, would take as much as 30 seconds to update. I am not chasing milliseconds, but half a minute is unacceptable." - Comment from Rob
"Just a quick one to say I'm very impressed so far :) The documentation for developers is excellent and I've quickly managed to get an app written to do historical downloads. The system is very robust and pretty quick considering the extent of data that's available. The support guys have been very helpful too, in combination with the forums it's been plain sailing so far!" - Comment from Adam
"I had always used ******* but for the past 2 weeks have been trying DTN IQFeed. Customer support has been extraordinary. They call just to make sure your problem hasn't recurred." - Comment from Public Forum
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"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
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
Viewing User Profile for: tribalmarine
About Contact
Joined: Apr 5, 2012 01:05 PM
Last Post: Apr 6, 2012 09:06 AM
Last Visit: Apr 6, 2012 09:07 AM
Website:  
Location:
Occupation:
Interests:
Email: trenchrats@gmail.com
AIM:
ICQ:
MSN IM:
Yahoo IM:
Post Statistics
tribalmarine has contributed to 2 posts out of 18870 total posts (0.01%) in 2,478 days (0.00 posts per day).

20 Most recent posts:
ProphetX Support » Price doesn't match b/w Excel functions and ProphetX Apr 6, 2012 09:06 AM (Total replies: 3)

Really?? Strange.

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

ProphetX Support » Price doesn't match b/w Excel functions and ProphetX Apr 5, 2012 01:12 PM (Total replies: 3)

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.


Time: Wed January 16, 2019 2:41 PM CFBB v1.2.0 0 ms.
© AderSoftware 2002-2003