View Full Version : Error in data.zip
ALISHAN
11th December 2010, 02:22 PM
Hello prashant,
i have dowmloaded data.zip -ieod data for 29 nov to dec-6-2010 on satarday noon but in each file there are too many errors so metastock can't download it .i am showing it below.
1) date format should be mm/dd/yyyy instead of 2010-11-29
2) each price should have only two decimal like 3iinfotech old file---3iinfotech,11/29/2010,09:55:00,111.1,111.1,111.1,111.1,0.0
but in this new file ---3iinfotech,2010-11-29,09:15:36,55.5500,55.5500,55.5500,55.5500,0 in all quotes so each file has error.
3) all new file are .txt old file had .nse extention
metastock doesnot download it
pls.do needful.
Can u help ?
Jaheer bijani
alishan
ahmedabad
Prashanth
14th December 2010, 08:59 AM
Hello prashant,
i have dowmloaded data.zip -ieod data for 29 nov to dec-6-2010 on satarday noon but in each file there are too many errors so metastock can't download it .i am showing it below.
1) date format should be mm/dd/yyyy instead of 2010-11-29
2) each price should have only two decimal like 3iinfotech old file---3iinfotech,11/29/2010,09:55:00,111.1,111.1,111.1,111.1,0.0
but in this new file ---3iinfotech,2010-11-29,09:15:36,55.5500,55.5500,55.5500,55.5500,0 in all quotes so each file has error.
3) all new file are .txt old file had .nse extention
metastock doesnot download it
pls.do needful.
Can u help ?
Jaheer bijani
alishan
ahmedabad
Alishan,
The error is due to first line for some reason reflecting a quote that has no reason to be there. I attempted to import into AB without importing the first line and export the same.
Unfortunately, as you have pointed out, it totally screws the format which means that its of not much use.
The best option would be to manually delete (for MS, since AB can ignore it altogether) the first line for the offending days. But since the numbers are huge, this is a herculean task. I would have done even that, but just do not have the time for such a work.
I offer no other solution since there seems to be none (which is easy and fast). Apologies for the inconvenience caused.
Regards
Prashanth
ALISHAN
20th December 2010, 07:11 PM
Dear prashant
can u fever 1 simple thing ?
Can u know facility of changing date format mm/dd/year ?
If it possible for u to change every file extention as (.nse)
otherwise i will do it manually if this 2 problems solves then i thinks ms will ignore desimals.
Pls do needful bcos manually each file takes 1 minutes.
Thanking u
alishan
alishan,
the error is due to first line for some reason reflecting a quote that has no reason to be there. I attempted to import into ab without importing the first line and export the same.
Unfortunately, as you have pointed out, it totally screws the format which means that its of not much use.
The best option would be to manually delete (for ms, since ab can ignore it altogether) the first line for the offending days. But since the numbers are huge, this is a herculean task. I would have done even that, but just do not have the time for such a work.
I offer no other solution since there seems to be none (which is easy and fast). Apologies for the inconvenience caused.
Regards
prashanth
Prashanth
21st December 2010, 06:15 AM
Dear prashant
can u fever 1 simple thing ?
Can u know facility of changing date format mm/dd/year ?
If it possible for u to change every file extention as (.nse)
otherwise i will do it manually if this 2 problems solves then i thinks ms will ignore desimals.
Pls do needful bcos manually each file takes 1 minutes.
Thanking u
alishan
Alishan,
Check this. Is in the IEOD format.
http://www.mediafire.com/download.php?y18yo3oshzpq59z
Cheers
Prashanth
ALISHAN
23rd December 2010, 06:22 PM
Dear prashant,
data zip new doesn't give result in continued chart folder.but gives results in new chart folder.thanks for ur good support but as a result i will have to spend 300 minutes to correct it in going by each file thanks for ur co oeration
alishan
alishan,
check this. Is in the ieod format.
http://www.mediafire.com/download.php?y18yo3oshzpq59z
cheers
prashanth
vBulletin® v3.8.0, Copyright ©2000-2012, Jelsoft Enterprises Ltd.