GICS import fails with error:
"Error in line 20MICRONS.NS,10304001
'20MICRONS.NS' - this ticker symbol does not exist in the database
The stock(s) exists in the database. Below is the command i am using.
which means it will NOT add symbols to the database. Change it to 1 to add missing symbols. And if it says that Given symbol does not exist, it means that it really does NOT exist and you are mistaken. Computer doesn't make mistakes. Check the spelling of symbols.
Also you have spurious $ mark that is incorrect here:
Thanks for the reply @Tomasz, the symbols do exist as can be seen in the snapshot below. If i removed 20MICRONS.NS from the csv, i was getting the same error on the next line in this case 21STCENMGM.NS.
$AUTOADD 0 because, i do not want to add any new symbols.
$OVERWRITE 1$ because it was mentioned in the snippet in amibroker ascii guide.
Following your suggestion, when i changed the $AUTOADD to 1 and removed the extra $ in the command, i did not receive any error on importing but the GICS codes weren't imported either. Do not know what is happening.
However, I noticed some differences in the GICS codes for NSE and Global. Could this be the reason for the failure?
I wrote you what you should do. But you don't listen. As I wrote - USE
It will NOT add symbols if they are already existing, but you will quickly find out what the problem is.
The screenshot proves nothing as you might have symbols with leading/trailing spaces. Spaces are invisible, yet make symbols different.