for past 2 days, the futures data is getting wrongly downloaded with wrong ticker name where instead of I, II, III which is denoted for near, next and far month, XII is denoted for all months!
to be precise, this is the excel sheet with name NSE_Equity_Futures_fo2211NOV2013bhav which is there in STD_CSV folder.
kindly help!
to be precise, this is the excel sheet with name NSE_Equity_Futures_fo2211NOV2013bhav which is there in STD_CSV folder.
kindly help!
I've noticed it too. It is not only "X" in suffix. In few cases, there is "V" also.
I've discovered following suffixes -XII, -XI, -VI, -I. I did not check every scrip, but in two or three that I checked, -I was pointing to scrip in Cash segment but it has open interest.
My uploading software (CSV to metastock) currently flags all scrips in F&O file with -I suffix as duplicate.
Also, month is repeated in name of files are 2511NOV2013
I have a small batch file that standardises Shubha file name before running the Uploader.