RE: [EquisMetaStock Group] To count total number of securities which are above 10 days moving average

["L.P. Carhartt" <lc@xxxxxxxxxxxxxx>]

Hi Suresh,

 

I don't think you can do in MetaStock as is.  The way I do similar calculations is to do them in Excel or other code outside of MetaStock and then output the results in .csv format.  Those .csv files are easily used immediately and directly in MetaStock using the MetaStockCSV Plug-in available at http://www.metastockcsv.com (one of my sites).  I use the plug-in regularly for my own stock analysis and ETF work.  There is no data import or conversion process for .csv datafiles.

 

Good luck.

Best,

L. P. Carhartt

---

From: equismetastock@xxxxxxxxxxxxxxx [mailto:equismetastock@xxxxxxxxxxxxxxx] On Behalf Of Suresh Thanki
Sent: Friday, August 01, 2008 7:00 AM
To: equismetastock@xxxxxxxxxxxxxxx
Subject: [EquisMetaStock Group] To count total number of securities which are above 10 days moving average

Dear All,

How to write the formula in MS to count the total number (and/or
percentage) of securities which are above 10 days moving average
within the group of securities like S & P 500 or any other Index
group ?

I have a database of securities traded on particular day.

In simple arithmetic form, I want to know,

% = Number of scrip above 10 days moving average *100 /
Total number of scrip traded on that day

Suresh Thanki

__._,_.___

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___