The goal here is to identify the correct RIC to be searched in the Reuters API.
Example when we look for AAPL it should return the first search result AAPL.O
I used this function in the past.
'''
x='aapl'
x=x.upper()
test = ek.json_requests.send_json_request('SymbologySearch',{'symbols': [x], 'from': 'ticker', 'to': ['RIC'], 'bestMatchOnly': False})
symbol=list()
try:
for key,value in test.items():
value = value[0]
for key1,value1 in value.items():
symbol=value1[0]
except:
pass
print( symbol)
'''
The above example will not return JPYSGD=R when I submit JPYSGD.
Any help is greatly appreciated.
Thank you,
