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)




"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
"Excellent datafeed !!!" - Comment from Arely
"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'm satisfied with IQFeed. It's the most reliable and fastest quote feed I have ever used. Although I'm a resident in China, it's still very fast!" - Comment from Xiaofei
"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
"IQ feed is brilliant. The support is mind-bending. What service!" - Comment from Public Forum Post
"Thank God for your Data Feed as the only Zippers I see are on my pants (LOL), and no more 200 pip spikes to mess up charts." - Comment from Spiro via Email
"I am very pleased with the DTNIQ system for quotes and news." - Comment from Larry
"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip
"Its working FABULOUSLY for me!! Holy cow...there has been so much I've been missing lately, and with this feed and Linnsoft software...I'm in the game now." - Comment from Chris R.
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 942 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 1021 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: Sun May 19, 2024 1:32 PM CFBB v1.2.0 10 ms.
© AderSoftware 2002-2003