I am given to understand that Zoho sheet uses Yahoo Finance as its source data. Accordingly I use the STOCK symbol to retrieve data. It works for some stocks such as stock("niftybees.bo") and returns correct data.

But I have not been able to make it work for others such as STOCK("HDFCTOP200GR.BO"). This stock code is available in Yahoo Finance but in Zoho sheet it says Invalid symbol. 

Please let me know what I am doing wrong or how else to correct it.

Thanks.