I am sending the following request
{ "ExtractionRequest": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.CompositeExtractionRequest", "ContentFieldNames": [ "Currency Code" ], "IdentifierList": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList", "InstrumentIdentifiers": [ { "Identifier": "NL0011375019", "IdentifierType": "Isin" } ] }, "Condition": null } }
I need to get the currency spot rates against EUR for the last 3 years. Usually we convert the small letters in the currency code to upper case and then construct an RIC code by adding "EUR=R". For example : if we need spot prices for GBp , we do GBPEUR=R.
However I see that, there is no data for the RIC code ZACEUR=R. The only available data for the currency pair is ZAREUR=R. (South African Rand). So how can we find the original currency for the RIC pair from the currency code of the ISIN , in this case ZAc ?