deleting intraday price data -999.99 all at once.

L

lvgandhi

Well-Known Member
#1
#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?
 
R

rmike

Well-Known Member
#2
#2
lvgandhi said:
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?
Click to expand...
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,
 
R

rmike

Well-Known Member
#3
#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:
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
V Editing or deleting comments/posts? Your Feedback & Suggestions 8
I Deleting EMAs plotted via afl AmiBroker 6
M Deleting RT ticks AmiBroker 24
L Deleting data 6 months old From RT database. AmiBroker 0
L Deleting Data for all symbols for a particular date in intraday data AmiBroker 9

Similar threads