PDA

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