NoFeeBoards.com! No Fees! No Ads! No Spam!

Author Message
JWR1945
***** Legend

Joined: 26 Nov 2002
Posts: 1697
Location: Crestview, Florida

 Posted: Sun Feb 22, 2004 2:19 pm    Post subject: Deluxe Version B of Calculators: More thresholds Deluxe Version B: More thresholds I have consistently found that the best choice for the lowest threshold is 100% stocks. For the highest threshold, it is 0% stocks. That leaves us with only one threshold to vary and two allocations. With this change, you get two additional thresholds (for a total of four) and three allocations to vary. The allocation below the lowest threshold is always 100% stocks. The allocation above the highest threshold is always 0% stocks. This totals five allocations, three of which you can vary. Doing it this way allows me to leave most of the user interface unchanged. These are my preliminary changes. Copy an earlier version of the switching calculator that includes three allocation levels. Such versions include calculations on row 2550. I chose to copy the JanSz-Chips Deluxe V1.0A version. 1) I changed cell E1 from V1.0A to V1.0B: JanSz-Chips Deluxe V1.0B. 2) I cut cell C19 and pasted it on cell A19: PE Ratio Criteria for Switch:. 3) I wrote '= Lowest Threshold into cell C19. [The apostrophe is important. If you copy and paste, it may be unnecessary. If you get a #NAME? error, you need to put it back in.] 4) I wrote Low = into cell E19. I clicked the checkmark. I clicked Format, then Cells, then Alignment, then Right. Finally, I clicked the checkmark. This is a two step process. 5) I replaced the contents of cell G19 with Middle =. I clicked the checkmark. I clicked Format, then Cells, then Alignment and then Right. Finally, I clicked the checkmark. 6) Format cells B19 and H19 to be the same as for F19 and I19. This is done by clicking on the cell, then clicking Format, then Cells, then Number, then Custom and finally on the choice just below 0.0% and 0.000%. Be sure that your selection is beneath the entry with three zeros after the decimal point. That line begins with _(*#,##0.0_);. [If you are in doubt, click cell F19 or I19, Format, Cells and Number to see its selection.] Finally, choose Font and then click Bold and Color (and click the blue square). Then, click OK. This puts the thresholds into cells \$B\$19, \$F\$19, \$H\$19 and \$I\$19, from lowest to highest. The allocations, from lowest to highest, are in cells \$B\$20, \$F\$20 and \$I\$20. The stock allocation is 100% when P/E10 is less than or equal to the lowest threshold (in cell \$B\$19). The stock allocation is 0% when P/E10 is greater than the highest threshold (in cell \$I\$20). Excel reads the thresholds from left to right. Special instructions for stocks and commercial Paper When I first attempted to make my changes, I found that I had used too many arguments. Most likely, the number of arguments was right but the parentheses were wrong. In any event, I cut the middle portion out of my modified code and pasted it into cell C2552. To get to row 2552, press function key F5 and type a2552. Then write Intermediate Logic into cell A2552. Click cell C2552. Write =IF(\$H\$19
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 9 Hours Page 1 of 1

 Jump to: Select a forum General----------------NFBTown CenterTest Posts Personal finance----------------FIRE BoardIndex Funds BoardSWR Research GroupLBYMGeneral FinanceNewbies Board Community----------------WorkspacePolitically CorrectYour HealthGummy Stuff
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum