Hi @ken03 ,

You can add 'Frq' into parameters as below (W = Weekly, M = Monthly)

weekly

df, err = ek.get_data(
    instruments = ['AAPL.O'],
    fields = [
        'TR.PriceClose.date',
        'TR.BVPSActValue',
        'TR.EPSActValue',
        'TR.PriceToBVPerShare',
        'TR.PriceClose'
    ],
    parameters = {'SDate': '2020-01-01', 'EDate': '2023-01-01', 'Frq': 'W'}
)
 
display(df)

monthly

df, err = ek.get_data(
    instruments = ['AAPL.O'],
    fields = [
        'TR.PriceClose.date',
        'TR.BVPSActValue',
        'TR.EPSActValue',
        'TR.PriceToBVPerShare',
        'TR.PriceClose'
    ],
    parameters = {'SDate': '2020-01-01', 'EDate': '2023-01-01', 'Frq': 'M'}
)
 
display(df)

Hi @ken03,

Thank you for you question. Could you please provide the scripts you were trying and also specify the parameters of the request? In the meantime, the code below retrieves Book value per share and the actual EPS value for AAPL for the previous 5 fiscal quarters.

df, err = ek.get_data(
    instruments = ['AAPL.O'],
    fields = [
        'TR.F.BookValuePerShr(SDate=0,EDate=-5,Period=FY0,Frq=FQ)',
        'TR.EPSActValue(SDate=0,EDate=-5,Period=FY0,Frq=FQ)',
    ]
)

display(df)

You may change the fields and the parameters of the requests. For fields I would suggest looking at the Data Item Browser (DIB) in Eikon/Workspace and for the parameter values you can look into Codecreator app again in Eikon/Workspace to build your code.

Hope this is helpful, please let me know should you have any further questions or needed something different.

Best regards,

Haykaz

Hi h.aramyan01

1. i am also trying to get the daily close prices

2. i would need the dates as a column also as i intend to plot a time series.

3. i am trying to calculate the daily close price against the book value per share to calculate the PB

4. i am trying to get the same result as that in Refinitiv's Datastream Chart Studies

Hi @ken03 ,

Please have a look at the code below, hopefully that addresses your request.

df, err = ek.get_data(
    instruments = ['AAPL.O'],
    fields = [
        'TR.PriceClose.date',
        'TR.BVPSActValue',
        'TR.EPSActValue',
        'TR.PriceToBVPerShare',
        'TR.PriceClose'
    ],
    parameters = {'SDate': '2020-01-01', 'EDate': '2023-01-01'}
)

display(df)

Please note that I have included PriceToBVPerShare so no need to calculate that yourself. As mentioned in my previous comments, for any additional fields please refer to DIB under Eikon/Workspace.

Best regards,

Haykaz

Hi @ken03 ,

Regarding Haykaz's comment, you can check this video of How to use the Data Item Browser in Refinitiv's Workspace to improve Python-based workflows with the Eikon Data API

Hi both how do i change this from daily data to weekly or monthly data

h.aramyan01 how do i set the end date as today's date, is there some sort of Today() function like in excel?

@aramyan.h -- i notice that the dates ends with T00:00:00Z which makes it difficult to concat with data pulled from your get history. how do you solve this?