Retreive historical data for daily price change percent

Fatemeh

Hello,

I tried to retrieve historical data for price change percent and price daily. The price part is ok but just last price change percent shows up.

Code:

Result:

Thanks in advance,

Alex Putkov.1

@Fatemeh

The field TR.PricePctChg1D is not available as timeseries. In other words, it only returns the latest value and does not provide any history. See the answer on this thread for explanation how to check whether a field as available as timeseries or not.

Fortunately it's very easy to calculate percent change from the price history using pandas:

df, err = ek.get_data('.SPX',['TR.PriceCloseDate','TR.PriceClose'],
                     {'SDate':'2019-01-01','EDate':'2019-12-31'})
df['Percent Chg'] = df['Price Close']/df['Price Close'].shift(1) -1
df

jason.ramchandani01

@Fatemeh you are requesting a daily percentage change with a monthly frequency - please try replacing the field with TR.PricePctChg1M

I hope this can help

Fatemeh

https://community.developers.refinitiv.com/discussion/comment/81037#Comment_81037

Thanks a lot.

Fatemeh

https://community.developers.refinitiv.com/discussion/comment/81024#Comment_81024

Thanks for your time.

It doesn't work. The reason is: "The field TR.PricePctChg1D is not available as timeseries."

j.zhang135

https://community.developers.refinitiv.com/discussion/comment/81987#Comment_81987

you can try CLOSE instead of TR.PricePctChg1D