Returning only certain mnemonics in a different currency

nicolas.charlton

My code:

mnemonic = ["TTOCOMP","S&PCOMP","MSEAFEL", "MSEMKFL"]
data_type = ["PI","RI"]
start_date = "2019-04-17"
end_date = "TODAY"
frequency = "D"


df = ds.get_data(tickers=mnemonic,
                 fields=data_type,
                 start=start_date,
                 end=end_date,
                 freq=frequency)

How should I modify the above to have the "RI" data return in Canadian dollars?

Thank you

James.Bright1

A return index is available for a range of sector and market indices, including Datastream Global Indices. The return index represents the theoretical aggregate growth in value of the constituents of the index. The index constituents are deemed to return an aggregate daily dividend which is included as an incremental amount to the daily change in price index.

The calculation is as follows:

Where:

= return index on day t

= return index on previous day

= price index on day t

= price index on previous day

DY = dividend yield of the price index

n = number of days in financial year (normally 260)

Currency conversion can be used with ~

eg.X(MV)~CAD