Investing for Growth Forum - messages #29209

Investing for Growth Forum

Messages

Prospero Blocks

Hot Money Searches

Chat Center

	Challenge Club Topic: Challenge Club Meetings
	Community Chat Topic: Anything
	Workshop Chat Topic: Discuss topics from the current forum workshop

Board Folders

	Forum Help ... 1844 msgs in 282 dscns Latest: Oct-30
	BI Software Help 2185 msgs in 277 dscns Latest: Sep-15
	BI Newbies 2709 msgs in 226 dscns Latest: Nov-18
	Investment Clubs 1256 msgs in 195 dscns Latest: Oct-22
	Economy & Markets 2917 msgs in 294 dscns Latest: Nov-21
	Selling Decisions 1430 msgs in 110 dscns Latest: Nov-13
	Stock Studies 14748 msgs in 1227 dscns Latest: Nov-20
	Community Square 8451 msgs in 868 dscns Latest: Nov-21
	Computers ... 2377 msgs in 241 dscns Latest: Nov-11
	BI Methods 2413 msgs in 158 dscns Latest: Nov-20
	Misc. Financia... 15857 msgs in 1149 dscns Latest: Nov-21
	Events 840 msgs in 106 dscns Latest: Nov-14
	Book Discussions 2215 msgs in 61 dscns Latest: Nov-16
	Passive Investing 6775 msgs in 198 dscns Latest: Nov-21

Message Area

To list

New

...

Misc. Financial Topics

Bullish Percent Indicators

Create Poll

Print Discussion

#1 of 1051 Posted 7/16/05 1:01 AM

From Bakul Lalla, Administrator Posts 2832 Last Nov-20
To All [Msg # 29209.1 ]

Lowell,

Attached is a spreadsheet showing my updates of the Bullish Percent Indicators. I am planning to keep track of these indicators on a weekly basis for a while. Let me know what you think.

Bakul

Attachments
Name: Weekly-BPI-20050715.xls Size: 34 K

Options

#2 of 1051 Posted 7/16/05 8:17 AM

From Lowell Herr Posts 9381 Last Nov-21
To Bakul Lalla, Administrator [Msg # 29209.2 29209.1 ]

Attached is a spreadsheet showing my updates of the Bullish Percent Indicators. I am planning to keep track of these indicators on a weekly basis for a while. Let me know what you think.

Bakul,

One suggestion. I would move the "Who's Got the Ball?" material over to the first worksheet. Then I could easily check the X's or O's with the raw numbers. Otherwise I am toggling back and forth. Perhaps you had a good reason for placing them in two different worksheets.

Otherwise, I really like the SS as it definitely gives one a feel for what is happening. And that feeling right now is that we have an inflated market. Since I don't use options or go short, cash is not a bad investment. (g)

Lowell

Options

#3 of 1051 Posted 7/16/05 8:19 AM

From nrminvs Posts 313 Last 7/17/08
To Bakul Lalla, Administrator [Msg # 29209.3 29209.1 ]

Attached is a spreadsheet showing my updates of the Bullish Percent Indicators

Bakul--

This is great! Thanks for putting the ss together so clearly and concisely. It will really help to tie together much of the discussion.

Norma

Options

#4 of 1051 Posted 7/16/05 8:36 AM

From Lowell Herr Posts 9381 Last Nov-21
To Bakul Lalla, Administrator [Msg # 29209.4 29209.2 ]

Attached is a spreadsheet showing my updates of the Bullish Percent Indicators. I am planning to keep track of these indicators on a weekly basis for a while. Let me know what you think.

Bakul,

What if you placed the "Who's Got the Ball?" information adjacent to the Bullish Percent Indicator on the first worksheet? I realize SS are quite personal in their design so you are free to say -- if you like it that way, do it yourself. (vbg)

Question: On the Bullish Percent Indicator, I assume you worked the Conditional Formatting to come up with the color. But Conditional Formatting is grayed out. How can I turn that back on? It looks like you hid something.

Lowell

Options

#5 of 1051 Posted 7/16/05 8:38 AM

From Lowell Herr Posts 9381 Last Nov-21
To Bakul Lalla, Administrator [Msg # 29209.5 29209.1 ]

Bakul,

I found the Unprotect Sheet so I'm off to make a few changes. I'll post what I did so you can comment on my changes.

Lowell

Options

#6 of 1051 Posted 7/16/05 8:52 AM

From Lowell Herr Posts 9381 Last Nov-21
To Bakul Lalla, Administrator [Msg # 29209.6 29209.1 ]

Bakul,

Perhaps this is more confusing but here are the minor changes I introduced.

Lowell

Attachments
	Name: Weekly-BPI-20050715.xls	Size: 24 K

Options

#7 of 1051 Posted 7/16/05 8:57 AM

From Lowell Herr Posts 9381 Last Nov-21
To Bakul Lalla, Administrator [Msg # 29209.7 29209.1 ]

Bakul,

I'm willing to help you keep this material updated. If we can get a few more to join this effort then there will always be a backup in case someone is away on vacation. Does this sound workable?

Lowell

Options

#8 of 1051 Posted 7/16/05 9:34 AM

From Bakul Lalla, Administrator Posts 2832 Last Nov-20
To Lowell Herr [Msg # 29209.8 29209.2 ]

One suggestion. I would move the "Who's Got the Ball?" material over to the first worksheet. Then I could easily check the X's or O's with the raw numbers. Otherwise I am toggling back and forth. Perhaps you had a good reason for placing them in two different worksheets.

Lowell,

Attached is an updated spreadsheet that shows all information in one worksheet.

Bakul

Attachments
Name: Weekly-BPI-20050715-Rev1.xls Size: 32 K

Options

#9 of 1051 Posted 7/16/05 9:54 AM

From Bakul Lalla, Administrator Posts 2832 Last Nov-20
To Lowell Herr [Msg # 29209.9 29209.4 ]

Lowell,

What if you placed the "Who's Got the Ball?" information adjacent to the Bullish Percent Indicator on the first worksheet? I realize SS are quite personal in their design so you are free to say -- if you like it that way, do it yourself. (vbg)

I've submitted a revision with your previous post. I'd like to keep the numbers adjacent to one another on a weekly basis instead of having two-tuples as suggested above. If one wants to plot the numbers for each indicator in the future when there is sufficient data, then it's easier to do so when selecting contiguous cells of numbers.

Question: On the Bullish Percent Indicator, I assume you worked the Conditional Formatting to come up with the color. But Conditional Formatting is grayed out. How can I turn that back on? It looks like you hid something.

There is nothing hidden in the worksheet. The worksheet is protected; consequently, there are some features that are disabled as a result of this protection. Go to Tools->Protection->Unprotect Sheet and this will unlock the worksheet enabling all the features. This shouldn't prompt you for any password as I protected the sheet without one.

Bakul

Options

#10 of 1051 Posted 7/16/05 9:58 AM

From Bakul Lalla, Administrator Posts 2832 Last Nov-20
To Lowell Herr [Msg # 29209.10 29209.6 ]

Perhaps this is more confusing but here are the minor changes I introduced.

Lowell,

I'd like to use my rev 1 for now.

Bakul

Options

#11 of 1051 Posted 7/16/05 10:02 AM

From Bakul Lalla, Administrator Posts 2832 Last Nov-20
To Lowell Herr [Msg # 29209.11 29209.7 ]

I'm willing to help you keep this material updated. If we can get a few more to join this effort then there will always be a backup in case someone is away on vacation. Does this sound workable?

Yes, indeed. The more the merrier. A backup and a few willing to do this will make it fun. Besides, we don't want a single point of failure in our processes.

Bakul

Options

#12 of 1051 Posted 7/16/05 10:30 AM

From Nancy Isaacs Posts 7088 Last Nov-18
To Bakul Lalla, Administrator [Msg # 29209.12 29209.1 ]

Bakul,

Now that is really cool! And what a great learning tool. We can easily click on the charts you reference and confirm the signals for ourselves. I've never been so aware of how the market and the different sectors and asset classes are doing until this book discussion....my own holdings as well.

I just noticed that your original spreadsheet has links to the charts as well. What a service you have provided for us. Thank you sooooooo much!!

Nancy Isaacs

Long term investing made simple
BetterInvesting Community

Options

#13 of 1051 Posted 7/16/05 10:38 AM

From Nancy Isaacs Posts 7088 Last Nov-18
To Bakul Lalla, Administrator [Msg # 29209.13 29209.1 ]

Bakul,

Does "whose got the ball" simply reflect wheter the most recent column is in X's or O's?

Nancy Isaacs

Long term investing made simple
BetterInvesting Community

Options

#14 of 1051 Posted 7/16/05 10:43 AM

From Nancy Isaacs Posts 7088 Last Nov-18
To Bakul Lalla, Administrator [Msg # 29209.14 29209.11 ]

Bakul and Lowell,

>>Yes, indeed. The more the merrier. A backup and a few willing to do this will make it fun. Besides, we don't want a single point of failure in our processes.<<

I'm certainly willing to help.

Nancy Isaacs

Long term investing made simple
BetterInvesting Community

Options

#15 of 1051 Posted 7/16/05 11:29 AM

From belinda charpentier Posts 358 Last 9/6/07
To All [Msg # 29209.15 29209.14 ]

I'm in. This is great. I've been wanting to learn excel and this is a good project. I Think the columns for Xs and Os will not be necessary once we have gone through a cycle. We will have the %s and we will see the rise and fall of each sector but in the beginning it's a big help. Will I be able to save your spreadsheet to my computer and change it as necessary?
Belinda Charpentier
www.1040rus.com

Options

#16 of 1051 Posted 7/16/05 12:20 PM

From Lowell Herr Posts 9381 Last Nov-21
To Bakul Lalla, Administrator [Msg # 29209.16 29209.8 ]

Attached is an updated spreadsheet that shows all information in one worksheet.

Bakul,

This is an improvement. Do you find it easier to use?

Lowell

Options

#17 of 1051 Posted 7/16/05 12:23 PM

From Lowell Herr Posts 9381 Last Nov-21
To Bakul Lalla, Administrator [Msg # 29209.17 29209.10 ]

I'd like to use my rev 1 for now.

Bakul,

I agree with you preference to use the revised SS. Do you think it would be useful to add a graph when more data is available? You've done a nice job of this in some other SS you mailed out.

Lowell

Options

#18 of 1051 Posted 7/16/05 12:27 PM

From Lowell Herr Posts 9381 Last Nov-21
To Bakul Lalla, Administrator [Msg # 29209.18 29209.11 ]

Yes, indeed. The more the merrier. A backup and a few willing to do this will make it fun. Besides, we don't want a single point of failure in our processes.

Bakul,

Count me in to help maintain the SS. I entered an alert on my Outlook Calendar to update each week. I will be out of town next weekend so I will not be the backup for you. Perhaps we can capture Nancy's (either or both) and others to help out maintaining this SS.

Am I correct in assuming once Monday's data hits the screen there is no going back and capturing these numbers? If so, we need to gather this information the weekend after the market closes.

Lowell

Options

#19 of 1051 Posted 7/16/05 12:32 PM

From Lowell Herr Posts 9381 Last Nov-21
To belinda charpentier [Msg # 29209.19 29209.15 ]

Belinda,

Great. Now we have three backups for Bakul. Thank you, Nancy, for joining. You are so disciplined we cannot fail.

Belinda, yes you can save the SS to your computer. I plan to work off Bakul's revised SS as he is the keeper. I do like the Xs and Os as it provides a warning of what may happen in the future. If we keep the Xs & Os we can at least look to see if they gave an accurate prediction to the direction of the indicators.

Lowell

Options

#20 of 1051 Posted 7/16/05 5:16 PM

From Nancy Isaacs Posts 7088 Last Nov-18
To Lowell Herr [Msg # 29209.20 29209.19 ]

>>Thank you, Nancy, for joining. <<

My pleasure. Are we going to share the work or are we simply backups for when Bakul is not available? If you guys have assignments for us helpers, please advise with clear instructions.