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)




"You have an excellent feed. Very few spikes for Spot Forex." - Comment from Public Forum Post
"I am keeping IQFeed, much better reliabilty than *******. I may refer a few other people in the office to switch as well." - Comment from Don
"The people at Nirvana have very nice things to say about your company and I can see why! Price and service is a potent combination." - Comment from Ed
"Thank you so much - awesome feed, awesome service!" - Comment from Greg via Email
"IQFeed version 4 is a real screamer compared to anything else I have seen." - Comment from Tom
"If someone needs the best quality data and backfill beyond what their broker provides at a rate that is the best in the industry, I highly recommend IQFeed." - Comment from Josh via Public Forum
"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 noticed that ******* quotes locked up shortly after the interest rate announcement yesterday while yours stayed stable." - Comment from Ron in Utah
"I just wanted to say how happy I am with your service. I was able to download the API docs last week and I was able to replicate Interactive Brokers historical bar queries and realtime bar queries over the weekend. That was about one of the fastest integrations that I've ever done and it works perfectly!!!!" - Comment from Jason via Email
"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
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 »IQFeed Developer »IQFeed Developer Support »where is the close price date ?
Author Topic: where is the close price date ? (3 messages, Page 1 of 1)

Thelos
-Interested User-
Posts: 9
Joined: Jul 12, 2019


Posted: Aug 20, 2019 01:33 AM          Msg. 1 of 3
Hi,

In the Update Message, what is the date of the close value (Close field) ?
For the settle there is a "Settlement Date" field but not for the Close.
Is there any logic I can apply to find the close date ?

Tarek

DTN_Gary_Stephen
-Interested User-
Posts: 52
Joined: Jul 3, 2019


Posted: Aug 20, 2019 04:46 PM          Msg. 2 of 3
Hello! This is Gary from DTN.

As far as I know, there's not a field for a close date and time. Close is always just the closing price of the day (or for commodities, the last trade of the session). There is a Last Date and Last Time, which when the market is closed would reflect the most recent trade. Can you tell me more about what you're looking to do, and I can maybe put together a suggestion from other available data?

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

Thelos
-Interested User-
Posts: 9
Joined: Jul 12, 2019


Posted: Aug 20, 2019 08:43 PM          Msg. 3 of 3
Hello Gary,

I am working on a position keeping software. it allows user to add to his position any security from any market.
for each security in position I want to feed the software with the following informations (among ohters):
Close,settle (if applicable),date.
for exemple,
for CAQ19 :

date | close | Settle
2019-8-20 | 150.2 | 150.2
2019-8-21 | 154.2 | 154.1
2019-8-22 | 155.1 | 154.9
......

the date is the market local date. I mean if the market close the 2019-8-20 at 19:00:00 even if my local date at the same moment is 2019-8-19 or 2019-8-21 this must not have an impact.

these data are stored and used to valuate the position (p&l,greeks...) and to compute the Value at Risk.

there is no need for me to listen to the feed for tick by tick data. So I made a batch that takes a snapshot (subscribe/unsubscribe) nearly each hour; for each security I get the UpdateMessage, now I want to store the close and the date in my table (in case of new close).

exemple, I get this :
close= 150.2
Last Date= 2019-8-20
Last Time= 17:40:02

how to know if the close belong to 2019-8-20 or 2019-8-19 or even 2019-8-21 (in case there was no trades for 1 or 2 days) ?


Tarek
Edited by Thelos on Aug 20, 2019 at 08:49 PM
 

 

Time: Wed April 8, 2020 9:34 AM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003