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

[EquisMetaStock Group] REPOST: Volume Float Indicator



PureBytes Links

Trading Reference Links

I am trying to implement the idea of "float analysis" and is trying to
write an indicator but without much success.

For example my chart data array are as follows:-

Stock XYZ     Total Float = 40,000

Day1  10,000
Day2  15,000
Day3   5,000
Day4  20,000
Day5  15,000
Day6   5,000
Day7   8,000
Day8  10,000
Day9  12,000
Day10 10,000
Day11  5,000
Day12 20,000
Day13 25,000
Day14 28,000
Day15 30,000

Basically I would like to create an indicator to sum the daily volume
from Day10 backwards (that means Day10, Day9 …… Day1) and show a
point
in the chart when the first Total Volume >= 40,000 (in this case Day7)
. Currently I am doing that manually by exporting the volume data to
Excel spreadsheet but it is so tedious. The figure "40,000" should be
a variable user input data since the float for all stocks are
different. Similarly the date of "Day10" should also be a variable
user input data for backtesting purpose.

Any suggestion on which specific MS function that I should use?

Best regards,
ALM







------------------------ Yahoo! Groups Sponsor --------------------~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/BefplB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> 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/