Factset · Schema
fields
All available fields in service. FID = Field ID Number.
FinancialFinancial DataInvestment AnalyticsMarket DataPortfolio AnalyticsResearch
Properties
| Name | Type | Description |
|---|---|---|
| Exchange | string | Field ID # 20. Exchange ISO-Code. Enumeration in Data Service Manual. |
| product | string | Field ID # 4. Product identifier. Enumeration in Data Service Manual. |
| Bid | number | Field ID # 509. Current bid price |
| Bid_Date | string | Field ID # 386. Current bid date |
| Bid_Time | integer | Field ID # 385. Current bid time |
| Bid_Vol | integer | Field ID # 505. Current bid size |
| Bid_Tick | string | Field ID # 518. Current bid tick direction. Enumeration in Data Service Manual. |
| Bid_Close | number | Field ID # 648. Official Closing Bid |
| Bid_Close_Date | string | Field ID # 1062. Official Closing Bid Date |
| Bid_Close_Vol | integer | Field ID # 296. Official Closing Bid Volume |
| Bid_Exch | string | Field ID # 506. Exchange of the current bid price. Enumeration in Data Service Manual. |
| Ask | number | Field ID # 609. Current ask price |
| Ask_Date | string | Field ID # 388. Current ask date |
| Ask_Time | integer | Field ID # 387. Current ask time |
| Ask_Vol | integer | Field ID # 605. Current ask size |
| Ask_Close | number | Field ID # 649. Official Closing ask |
| Ask_Close_Date | string | Field ID # 1064. Official Closing ask Date |
| Ask_Close_Vol | integer | Field ID # 297. Official Closing ask Volume |
| Ask_Exch | string | Field ID # 606. Exchange of the current ask price. Enumeration in Data Service Manual. |
| Short_Sale_Indicator | integer | Field ID # 277. Flag to indicate if a security is restricted from being sold short |
| Quote_Condition | string | Field ID # 38. Current Quote Condition. Enumeration in Data Service Manual. |
| Last_Price | number | Field ID # 50. Official last trade price |
| Last_Date | string | Field ID # 384. Last Date |
| Last_Time | integer | Field ID # 383. Official last traded time |
| Last_Vol | integer | Field ID # 31. Official last traded volume |
| Last_Tick | string | Field ID # 25. Official last tick. Enumeration in Data Service Manual. |
| Official_Close | number | Field ID # 526. Official Close/Close Range 1 Price |
| Official_Close_Time | integer | Field ID # 1065. Official Close/Close Range 1 Time |
| Last_Exch | string | Field ID # 33. Official last traded exchange. Enumeration in Data Service Manual. |
| Settlement | number | Field ID # 815. Settle Price |
| Traded_Price | number | Field ID # 912. Last traded Price |
| Traded_Date | string | Field ID # 868. Last traded Date |
| Traded_Time | integer | Field ID # 916. Last traded Time |
| Traded_Vol | integer | Field ID # 918. Last traded Volume |
| Traded_Condition | string | Field ID # 1098. Last traded trade condition |
| Net_Change | number | Field ID # 662. Official last change |
| Percent_Change | number | Field ID # 816. Official last percentage change |
| Premkt_Price | number | Field ID # 1019. Unofficial last premarket trade price |
| Premkt_Time | integer | Field ID # 1075. Unofficial last premarket traded time |
| Premkt_Vol | integer | Field ID # 1832. Unofficial last premarket traded volume |
| Premkt_CVol | integer | Field ID # 1836. Unofficial last premarket cumulative volume |
| Postmkt_Price | number | Field ID # 2029. Unofficial last post market trade price |
| Postmkt_Time | integer | Field ID # 1076. Unofficial last post market traded time |
| Postmkt_Vol | integer | Field ID # 1860. Unofficial last post market traded volume |
| Postmkt_Cvol | integer | Field ID # 1864. Unofficial last post market cumulative volume |
| Offbook_Cum_Vol | integer | Field ID # 528. Off Book Cumulative Volume |
| Official_Bid_Close | number | Field ID # 448. The bid close price of today |
| Official_Ask_Close | number | Field ID # 476. The ask close price of today |
| Mid_Date | string | Field ID # 136. Current mid date |
| Mid_Time | integer | Field ID # 135. Current mid price time |
| Cvol | integer | Field ID # 132. Cumulative volume |
| Turnover | number | Field ID # 341. Turnover |
| Vwap | number | Field ID # 780. Volume Weighted Average Price |
| Trade_Count | integer | Field ID # 267. Cumulative trade count |
| Block_Trade_Count | integer | Field ID # 269. Cumulative block count |
| Block_Cvol | integer | Field ID # 271. Cumulative block volume |
| Prev_Close | number | Field ID # 208. Previous trading days Close |
| Close_Date | string | Field ID # 1051. Previous trading days Closing Date |
| Prev_Close_Unadj | number | Field ID # 892. Unadjusted Previous trading days Close |
| Prev_Close_2 | number | Field ID # 1172. Previous trading days Close late rollover[1] |
| Prev_Close_Unadj_2 | number | Field ID # 1176. Unadjusted Previous trading days Close late rollover |
| Lower_Trading_Band | number | Field ID # 1093. Lower trading band |
| Upper_Trading_Band | number | Field ID # 1087. Upper trading band |
| Buy_Imbalance | integer | Field ID # 495. NYSE buy imbalance |
| Sell_Imbalance | integer | Field ID # 496. NYSE sell imbalance |
| Nas_Buy_Imbalance | integer | Field ID # 948. NAS buy imbalance |
| Nas_Sell_Imbalance | integer | Field ID # 949. NAS sell imbalance |
| Open | number | Field ID # 158. The Open Range 1 or Open Price |
| High | number | Field ID # 107. Current high for the day |
| Low | number | Field ID # 307. Current low for the day |
| Venue | string | Field ID # 530. Venue |
| Buy_Id | string | Field ID # 1820. Buy Id |
| Sell_Id | string | Field ID # 1824. Sell Id |
| Auto_Trade_Vwap | number | Field ID # 637. VWAP including only order book (automatic) trades |
| Auto_Trade_Cvol | integer | Field ID # 635. Cumulative Volume calculated on all automated trading volumes for order-based segments |
| Auto_Trade_Count | integer | Field ID # 636. Trade Quantity including only order book (automatic) trades |
| Ex_Date_Status | string | Field ID # 531. Ex-Date Status |
| Premkt_Net_Change | number | Field ID # 896. Net change in pre-market session(US stocks only) |
| Premkt_Percent_Change | number | Field ID # 897. Percent change in pre-market session(US stocks only) |
| Closing_Vol | integer | Field ID # 1345. Volume of the closing trade |
| Primary_Market | string | Field ID # 1517. FactSet Exchange Code of primary market for instrument. Determined by highest trading volume over a 3-day calendar period |
| Iso_Country_Exchange | string | Field ID # 1621. Three Letter Country Code from ISO-3166 |
| Premkt_Exch | string | Field ID # 1743. Premarket Exchange. Enumeration in Data Service Manual. |
| Postmkt_Exch | string | Field ID # 1744. Post Market Exchange. Enumeration in Data Service Manual. |
| Fref_Security_type | string | Field ID # 1751. The Security type returned by FREF_SECURITY_type |
| Security_Sub_type | string | Field ID # 1762. Sub type of the security populated for funds right now |
| Postmkt_Net_Change | number | Field ID # 1881. Post Market Net Change |
| Postmkt_Percent_Change | number | Field ID # 1882. Post Market Percent Change. |
| Isin | string | Field ID # 12. ISIN |
| Cusip | string | Field ID # 14. CUSIP |
| Sedol | string | Field ID # 15. SEDOL |
| description | string | Field ID # 8. Security Description |
| Shares_Outstanding | number | Field ID # 29. Total number of shares outstanding |
| Price_Currency | string | Field ID # 62. Price currency code |
| Security_Status | string | Field ID # 2800. Security Status or Halt Indicator. Enumeration in Data manual |
| Gmt_Offset | integer | Field ID # 389. GMT Offset in Minutes |
| Market_Segment | string | Field ID # 650. Market segment |
| Market_Sector | string | Field ID # 651. Market sector |
| Period | string | Field ID # 633. Period |
| Country_Code | string | Field ID # 652. ISO Country code |
| Financial_Status | integer | Field ID # 1896. Financial Status Enumeration Table |
| Factset_Industry | string | Field ID # 722. FactSet Industry Classification |
| Factset_Sector | string | Field ID # 723. FactSet Sector Classification |
| Halt_Info | integer | Field ID # 1414. Halt Status |
| Homepage | string | Field ID # 724. Company Homepage |
| Halt_description | string | Field ID # 1184. Halt description |
| Feed_Currency | string | Field ID # 1182. Currency the Exchange sends the prices to FactSet in |
| Country_Name | string | Field ID # 1190. Name of Country |
| Order_Lot_Size | integer | Field ID # 427. Number of securities in a lot |
| Trade_Lot_Size | integer | Field ID # 1335. The minimum number of lots required to trade |
| Tick_Size | number | Field ID # 1499. Tick Size |
| Tick_Group | string | Field ID # 1507. Tick Group |
| Tick_Pilot_Eff_Date | string | Field ID # 1508. Tick Pilot effective day |
| Avg_30Day_Vol | number | Field ID # 709. Average cumulative volume for last 30 days |
| Avg_5Day_Vol | number | Field ID # 719. Average cumulative volume over last 5 trading days |
| High_52Week | number | Field ID # 767. 52 Week High Price |
| Low_52Week | number | Field ID # 768. 52 Week Low Price |
| High_52Week_Date | string | Field ID # 1220. 52 Week High Price Date |
| Low_52Week_Date | string | Field ID # 1295. 52 Week Low Price Date |
| Trade_Condition | string | Field ID # 174. Trade Condition |
| Total_Return_3M | number | Field ID # 746. 3 Month return for US mutual funds |
| Total_Return_52W | number | Field ID # 747. 52-Week Total Return for US mutual funds |