data download

hi what would be the code to download.

several symbols/instrument, for daily timer series ratios such as price to book, price to earnings, marketcap, dividend yield, dividend

Find more posts tagged with

eikon

workspace

datastream-api

#technology

Accepted answers

Jirapongse

@ken03

Thank you for reaching out to us.

You can specify a list of instruments in the instruments parameter.

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

All comments

raksina.samasiri

Hi @ken03 ,

Could you please let me know which API are you using for better suggestion? Is it RD Library for Python, Eikon Data API, or others?

ken03

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)

i am using this

Jirapongse

@ken03

Thank you for reaching out to us.

You can specify a list of instruments in the instruments parameter.

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

EXPLORE OUR SITES