hi @sanhitha.jugulum thanks for your question - if you have cusip codes its a 2 step operation involving firstly our get_symbology API call which can convert between different symbology types (CUSIP to RIC in this case) and once we have our RICS we can get our monthly closing price data. Please see the code sample below:
df1 = ek.get_symbology(['594918104','88160R101'],from_symbol_type ='CUSIP',to_symbol_type='RIC') df2 = ek.get_timeseries(df1.RIC.to_list(), fields='CLOSE', start_date='2010-03-01',end_date='2020-04-26',interval='monthly') df2
I hope this can help you.
I suggest that you convert the CUSIP to RIC code first.
If they are valid identifier, you can use it with get_timeseries()
Here, I am demonstrating that the CUSIP and RIC can be converted:
Once you have the RIC, you can get the historical price.
For more information on historical price, you can use help(ek.get_timeseries) in your Python code.