deleting intraday price data -999.99 all at once.

lvgandhi

Well-Known Member
#1
I am using IEOD data from BSENSE ***** group. Yesterday's data contains many OHLC values as -999.99. Is there any way to delete all -999.99 values in a stroke instead of opening data edit individually?
 

rmike

Well-Known Member
#2
I am using IEOD data from BSENSE ***** group. Yesterday's data contains many OHLC values as -999.99. Is there any way to delete all -999.99 values in a stroke instead of opening data edit individually?
Dear Ivgandhi,

Two ways,
Delete session OR Delete entire day.

Open your IEOD file with excel, use edit, find, showall for -999.99 and delete.

Reload into ami.

Regards,
 

rmike

Well-Known Member
#3
Another Thought,

If all your incorrect data is with a negative sign then pick up the file again with import wizard, choose format as applicable but do not tick 'allow negative values'. Reimport with the option of overwriting previous data. This should hopefully sort out your problem.

Regards,
 
Last edited:

Similar threads