Replies to post #679 on Systematic Investing Group (SIG)

[Conrad]

Hi LC
I think you are trying to decipher my highlowdemo spreadsheet

Which one of these are you referring to?
*********************************************
Parent Directory 26-Feb-2002 15:52 -
dca_gainloss.xls 13-Feb-2002 19:13 63k
formula_plan_improvm..> 13-Feb-2002 19:29 2k
growth_dca.xls 13-Feb-2002 19:29 17k
synchrovest.txt 13-Feb-2002 21:38 9k
synchrovest.xls 13-Feb-2002 19:13 83k
synchrovestmessages.txt 13-Feb-2002 19:13 11k
trading.gif 25-Jun-2002 00:29 33k
twinvest.xls 13-Feb-2002 19:20 72k
twinvestnew.xls 03-Jun-2002 11:59 407k
va_readjustment.xls 13-Feb-2002 19:29 18k
vca_gainloss.xls 13-Feb-2002 19:29 94k
*******************************************
I am not specifically trying to decipher anything. I remember that with a monthly investment you had various "formula's" to calculate the SPLIT between stashing the Reserve and equity buying. . .This split is obvious is based on a fraction such 20/80 or 40/60 etc.
To me this looked like a Black Box: In goes 100 and out comes x/y based on some stock price behavior (Market Signals).

This fraction looks to me hat it can be related to the function

Buy=(PC-V)*M = X* (Monthly Investment)
and
Cash to Reserve= (100-X)* (Monthly Investment). . . .Y=(100-X).

This is sort of the basis of my idea for the Vortex PremiVest Function I had "conjured up" years ago.

I can of course create various function for M that will do just that. May be some of your split-function that are based on this Williams R% (Williams Ratio Generator=WRG) will be a better idea than an Arbitrary Vortex Ratio Generator(AVRG).

Regards,