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).
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.