Metastock Exploration that list Dead Counters

This Metastock exploration can list the last update year, month & day of all the security.

After exploration, look at the report, click on the heading to sort the last update date of the security. If you notice that that particular security had not been updated for sometimes, it may be expired warrants, delisted company, or company that has its symbol changed. Do visual inspection to see if you wish to delete that security. I had provided an additional column that give a reading on the 30 days moving average of volume, so as to highlight some very illiquid counters that may not get updated (depending on data vendor).



To delete a counter's data file, in the exploration report, highlight that security, right click, select delete security and confirm.

Deleting expired data not only tidy up your data directory, it speed up your exploration and system testing (ver 8 can system test the whole exchange if you wish).

Please be careful when deleting the data, as patching it back may be troublesome.

Here is the code:



And here is the text version for easy cut an paste:

Exploration notes Scan counters that had not been updated for quite some times

Col A: Year Year()
Col B: Month Month()
Col C: Day DayOfMonth()
Col D: 30 Ave V Mov(V,30,S)

Filter enabled No
Periodicity Daily
Records required 1300