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)




"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"Version 4.0.0.2 has been working well for me and I appreciate that it is now a much tighter client to work with. I feel I can go to press with my own application and rely on a stable platform" - Comment from David in IA.
"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
"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.
"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
"You have an excellent product !!!!!!" - Comment from Arely
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"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
"I cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles
"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
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 »Archive (2017 and earlier) »IQFeed Developer Support »Fundamental Data field order
Author Topic: Fundamental Data field order (5 messages, Page 1 of 1)

Roberts
-Interested User-
Posts: 53
Joined: Mar 26, 2008


Posted: Aug 15, 2020 05:26 AM          Msg. 1 of 5
Please help me with the field order for ..dev/api/docs/Level1FundamentalMessage.cfm
Here's the fundamental message for TSLA received today:

"F,TSLA,5,775.0,13022000,1794.9900,211.0000,1794.9900,350.5100,0.0000,,,,,,,,,,2.13,,,12,,TESLA INC.,,38.,1.42,,12103.0,10667.0,06/30/2020,11634.0,186362,336211, , ,,0,14,4,3711,80.92,1,21,07/13/2020,08/23/2019,07/13/2020,03/18/2020,418.33,,,,,336211,,"

Assuming F is field number 0, the data correspond well to the Level1FundamentalMessage field order up to index 9. However, the next value available is at index 19, which is "2.13. The table, however, indicates "Root Option symbol (there may be more than one)" for index 19.

The Company Name, TESLA INC. appears at index 24, but the table suggests that Company Name should be at index 18.

I've attached a tab-delimited txt document that aligns the data in this message with the descriptions for Level1FundamentalMessage.cfm. What's going on here?



File Attached: FundamentalMessage.txt (downloaded 932 times)

Roberts
-Interested User-
Posts: 53
Joined: Mar 26, 2008


Posted: Aug 15, 2020 06:15 AM          Msg. 2 of 5
I can reconcile many of the fields to indexes where the data are appearing (like Company Name), but there was a mistake in the previously-attached file due to a few merged cells from the spreadsheet, but this doesn't affect the discussion. If you look, import this attached one into Excel.



File Attached: FundamentalMessage1.txt (downloaded 1000 times)

Roberts
-Interested User-
Posts: 53
Joined: Mar 26, 2008


Posted: Aug 15, 2020 07:50 PM          Msg. 3 of 5
While I don't know what the table isn't update, the order of the fields from the S,REQUEST FUNDAMENTAL FIELDNAMES request appears as follows and reconciles with the fundamental data received.

0 FUNDAMENTAL FIELDNAMES
1 Symbol
2 Exchange ID
3 PE
4 Average Volume
5 52 Week High
6 52 Week Low
7 Calendar Year High
8 Calendar Year Low
9 Dividend Yield
10 Dividend Amount
11 Dividend Rate
12 Pay Date
13 Ex-dividend Date
14 (Reserved)
15 (Reserved)
16 (Reserved)
17 Short Interest
18 (Reserved)
19 Current Year EPS
20 Next Year EPS
21 Five-year Growth Percentage
22 Fiscal Year End
23 (Reserved)
24 Company Name
25 Root Option Symbol
26 Percent Held By Institutions
27 Beta
28 Leaps
29 Current Assets
30 Current Liabilities
31 Balance Sheet Date
32 Long-term Debt
33 Common Shares Outstanding
34 (Reserved)
35 Split Factor 1
36 Split Factor 2
37 (Reserved)
38 Market Center
39 Format Code
40 Precision
41 SIC
42 Historical Volatility
43 Security Type
44 Listed Market
45 52 Week High Date
46 52 Week Low Date
47 Calendar Year High Date
48 Calendar Year Low Date
49 Year End Close
50 Maturity Date
51 Coupon Rate
52 Expiration Date
53 Strike Price
54 NAICS
55 Exchange Root
56 Option Premium Multiplier
57 Option Multiple Deliverable

Roberts
-Interested User-
Posts: 53
Joined: Mar 26, 2008


Posted: Aug 15, 2020 09:42 PM          Msg. 4 of 5
I'm going to quit! I had set the protocol to 6.1 only for the history socket. The level 1 socket defaults to 4.9, so there's the difference. The field order above is 4.9. The doc is updated to 6.1.

DTN_Gary_Stephen
-DTN Guru-
Posts: 396
Joined: Jul 3, 2019


Posted: Aug 17, 2020 08:07 AM          Msg. 5 of 5
Roberts,

I'm sorry I didn't read this message before I responded to your other one. But yes, the protocol command explains the difference. Each socket, and each connection if you have multiple connections going, is unique. The S,SET PROTOCOL command must be set each time you connect. It won't be shared across different ports, or multiple connections to the same port.

Let me know if you have any other questions about this!

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist
 

 

Time: Wed May 1, 2024 1:00 AM CFBB v1.2.0 14 ms.
© AderSoftware 2002-2003