[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [EquisMetaStock Group] EOD File Cleanup Utility correction



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&#x2019;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&#x2019;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&#x2019;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&#x2019;d prefer freeware, naturally. I&#x2019;ve done searches as well as I could, 
>>but nothing apart from Jose&#x2019;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/