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
"Awesome response, as usual. It is a sincere and refreshing pleasure to do business with DTN, compared to your competition." - Comment from Ryan
"IQ feed is brilliant. The support is mind-bending. What service!" - Comment from Public Forum Post
"Can I get another account from you? I am tired of ******* going down so often" - Comment from George
"You are much better than lawyers or the phone company because you answer the phone when I call! I just love your customer service." - Comment from Isreal
"Boy, probably spent a thousand hours trying to get ******* API to work right. And now two hours to have something running with IQFeed. Hmmm, guess I was pretty stupid to fight rather than switch all this time. And have gotten more customer service from you guys already than total from them… in five years." - Comment from Jim
"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
"I'm very glad I switched to IQFeed. It's working perfectly with no lag, even during fast market conditions." - Comment from Andy via Email
"I have to tell you though that using the IQFeed API is about the easiest and cleanest I have seen for some time." - Comment from Jim
"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
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
Viewing User Profile for: KWatson
About Contact
Joined: Oct 1, 2007 09:34 AM
Last Post: Oct 2, 2007 09:46 AM
Last Visit: Oct 9, 2007 10:29 AM
Yahoo IM:
Post Statistics
KWatson has contributed to 2 posts out of 20421 total posts (0.01%) in 5,181 days (0.00 posts per day).

20 Most recent posts:
ProphetX Support » History Snap/12 mo. forward NG pricing Oct 2, 2007 09:46 AM (Total replies: 2)

Yes, Don helped me with 3 possible solutions to this question. As I told him, the solution I ended up implementing wasn't as simple as I had hoped, but it worked well.

Here was Don's feedback, if anyone else has a similar problem:

There are several ways to get the data:

Enter the TRADE DATE of 1/2/1997, then enter NG for the TICKER SYMBOL, and hit the F3 key (NOTE: 1/1/1997 was a holiday).

You could then copy the data into Excel, Word, or what ever you want.

Then change the date to 2/1/1997. But note that 2/1/1997 and 2/2/1997 were on a weekend, so that 2/3/1997 is the first day of the month. When you change the TRADE DATE to 2/3/1997, then TAB over to the TICKER SYMBOL field, the new data appears.

That is very time consuming, but you can get the data.

From the TABULAR tool, enter 12 contracts NG@C, NG@C2, NG@C3, NG@C4 .... NG@C12.
NOTE: you will need to increase the "Number of Bars/Ticks to Load" to 3000 from the CHARTS Preference Screen. Also, you may want to set the "Selected Fields" in the TABULAR Preferences to "Close Price" only by removing the High, Low, etc. so that you only have the CLOSE data.

You can then scroll back to any date and see the Forward Curve for that date.

I tried adding this as a DDE link to Excel, but it is to large. You may be able to break it up into several links and get the data into Excel that way.

3. VBA and EXCEL
If you are proficient in VBA programming, you could probably write a script that would automate this process by creating DDE links and requesting the data from our TABULAR feature.

ProphetX Support » History Snap/12 mo. forward NG pricing Oct 1, 2007 09:37 AM (Total replies: 2)

I'm trying to obtain 12 month forward pricing of NG for the first trading day of each month since 1997. For example, 1/1/1997, 2/1/1997, etc. I can't figure out an easier way to do it, so I'm using the History Snap function. I've input all the dates I need, but don't know what ticker symbol to use. Do I need a formula?

Time: Mon December 6, 2021 4:47 AM CFBB v1.2.0 0 ms.
© AderSoftware 2002-2003