|
PureBytes Links
Trading Reference Links
|
When I wrote the instructions, I overlooked the fact that there was data
in my MS Column fields. With no values in those fields the code would be:
=IF(LEN(B2)<=3,"X","")
and would be entered into C2.
Sort by column C.
Sorry.
Ron wrote:
>If you own Excel the following may work. You should get a usable ticker
>list you won't be deleting the files.:
>1. Run an exploration against the relevant universe with no filter.
>2. Copy the result set from the report and paste it into cell A1 of a
>new worksheet.
>3. In cell G2 enter the following code:
>=IF(LEN(F2)<=3,"X","")
>4.Fill that code down the G:G colunm to opposite the last cell in which
>there are ticlers.
>5. Sort descending by column G.
>
>You should now have a list of tickers where the length is no more than
>three characters at the top.
>
>Copy and paste that portion of the ticker list into a text file.
>Save the file with a .sym extension.
>Put the saved list in the Downloader folder.
>
>
>
>
>
>
>
>
>
>Kamal Fernando wrote:
>
>
>
>>Hi group,
>>
>>Does anyone know of a free utility to cleanup EOD data files that will
>>get rid of all securities with more than 3 letters? This is for the ASX.
>>
>>I am aware of (and currently use) Jose Silva’s file cleanup utility on
>>my files prior to import into the Downloader. Though the utility is
>>great (thanks Jose if you are reading this) it still keeps deferred
>>delivery codes in the files. I don’t trade these at all. The end
>>result is a 10,227-security ASX database.
>>
>>In FCharts Pro, I can delete all securities of more than 3 letters,
>>and the resulting database is a fantastic 3,300-ish.
>>
>>I’d like to get my Metastock database down to this size. The reason is
>>because I run a set of explorations each night (like everyone else)
>>but also because I use the MS database for Omnitrader. Each of my
>>profiles in Omnitrader uses the full Ms database, so it has to scan
>>all 10,227 securities for each profile. I use 7 profiles. Scanning and
>>backtesting 10,000 securities in Omnitrader takes my computer about 15
>>minutes, but doing the same for a 3,000 security database takes about
>>3 minutes. So hopefully some of you who also use OT see my need for a
>>more specific file cleaner.
>>
>>I’d prefer freeware, naturally. I’ve done searches as well as I could,
>>but nothing apart from Jose’s (useful) utility.
>>
>>Thanks.
>>
>>
>>Yahoo! Groups Sponsor
>>ADVERTISEMENT
>>click here
>><http://rd.yahoo.com/M=194081.4074964.5287182.1261774/D=egroupweb/S=1705375617:HM/A=1732163/R=0/SIG=11n0nglqg/*http://www.ediets.com/start.cfm?code=30510&media=zone>
>>
>>
>>
>>To unsubscribe from this group, send an email to:
>>equismetastock-unsubscribe@xxxxxxxxxxxxxxx
>>
>>
>>
>>Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
>><http://docs.yahoo.com/info/terms/>.
>>
>>
>
>
>
>
>To unsubscribe from this group, send an email to:
>equismetastock-unsubscribe@xxxxxxxxxxxxxxx
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Rent DVDs Online - Over 14,500 titles.
No Late Fees & Free Shipping.
Try Netflix for FREE!
http://us.click.yahoo.com/xlw.sC/XP.FAA/3jkFAA/BefplB/TM
---------------------------------------------------------------------~->
To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|