Replies to post #9709 on A.I.M. Users Bulletin Board (AIMUSERS)

[Qarel]

Hi Grabber, good luck on your quest for mathematical exactness. I am more a kludge kind of guy. Well, sometimes. What about calculating, with fractional shares and prices in a zillion decimals, the net gain in shares after a Buy-Sell cycle for a certain Safe - Min Transaction Amount setting and then reducing the dollar gain to a percentage, to add after every buy? (Or to split over buys and sells, or ...) I can't imagine a stock to bounce around indefinitely in a trading range anyway ... See also my #msg-1435555.

Just an idea to keep your spreadsheets manageable. (And of course you could try to automate the percentage setting!)

Regards,

Karel

[2mc]

Hi Steve,

No problem at all.

Regarding Excel: I don't use Excel, because I prefer to program. However, if you go to www.mrexcel.com, you can probably get an answer on creating a dynamic LIFO stack in Excel. I had used them in the past when I created an Excel spreadsheet as a stop-gap when I hit what I thought was a programming deadend. I received some answers. Also, if you are willing to pay a few bucks you can probably get a whiz-kid to do it for you completely at www.rentacoder.com. Just post what you're looking for and someone will probably bid for the work.

Your friend,
Matt