Does someone know if there exist a formula in Excel API that does the same job as ek.get_symbolog() in Python API? I contacted with a helpdesk, but was forwarded to here.
@iwasaki
The get_symbology method converts a list of instrument names into another instrument code.
You may need to contact the Eikon excel support team to verify which excel functions can perform the symbology conversions.
From my finding, the =RSearch and =TR function can convert instrument codes.
For example:
=RSearch("EQUITY","Search:'GB00B1XZS820'","NBROWS:1",,)
The above code uses the RSearch function to convert ISIN to RIC.
=TR("GB00B1XZS820,GB0006731235,2005973","TR.PrimaryRICCode,TR.RIC","CODE=MULTI")
The above code uses the TR function to convert ISIN and SEDOL to RIC.
However, please directly contact the Eikon Excel support team via MyRefinitv (https://my.refinitiv.com/content/mytr/en/helpandsupport.html) to verify it.
Thank you for great answer. It worked out!
As an aside, I have another question that is more general. In your 2nd case, we have returns over 3x2 cells as follows:
Do you know if it is possible to access only one element in the matrix in one formula in Excel? That is, instead of letting the formula return a matrix that goes over 3x2 cells, I want to obtain an element in (2,1) position (ABF.L ) and discard everything else. I believe this is something called "array slicing" in programing language, but do you think we can do that with Excel API?
