Why does my code not return any values? It works for other fields, for example TR.Price.Close

import pandas as pd
import numpy as np
import plotly.graph_objects as go
import lseg.data as ld
from plotly.offline import plot
import cufflinks as cf # Cufflinks
import configparser as cp
import time
all_data = []
for i in range(0, len(RICS), batch_size):
batch = RICS[i:i + batch_size]
data = ld.get_history(
universe=batch,
fields = "TR.F.CF",
start='2010-01-01',
end='2024-01-01',
interval='yearly'
).dropna().reset_index()
RICS is definied as all companies in the S&P500
Best Answers
-
Hi @JakobGruber ,
Please raise a ticket to helpdesk via MyAccount, they are going to contact the content team to investigate and clarify content of this specific field and RICs
0 -
Hi @JakobGruber,
Please note that the answer above was marked as accepted. Please let us know if that's incorrect.0
Answers
-
Hello @JakobGruber
This particular field reports the Cash Flow Date which is not consistent across all the instruments. This means that your resulting dataframe will contain null entries in either one or multiple columns. When the function dropna() is used, it purges the dataframe.
Example:
0 -
I see. Still i wonder why it doesnt return any values at all. I want to extract quite a few fields of all S&P 500 stocks. Still when i try to run a while loop i mostly do not receive any outputs.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 687 Datastream
- 1.4K DSS
- 621 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 4 Trading API
- 2.9K Elektron
- 1.4K EMA
- 254 ETA
- 557 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 276 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 669 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 229 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛