Hello and welcome to our community!

[Mike Campbell]

Originally Posted by patfergie44

Hey Mike,

I find that the bad data box usually appears when I first open Excel. Try this workaround: when you first open the spreadsheet, instead of putting the symbol in the Rule1 tab, put it at the bottom of the symbols in the watchlist tab, then hit update. Go back to the Rule1 tab and see if it shows successful. Then, try another symbol in the Rule1 tab and see if it is successful. Hope this helps.

Can't get Enters in watch list to stay also debug appears says Pos = WorksheetFunction.CountIf(Worksheets("Watch List").Range("WatchList"), _
Worksheets("Rule #1").Range("ticker").Value)

Please tell me what this means

Thank you

Mike Campbell

[krypticide]

Welcome! Looks like you're off to a good start, especially with the paper trading.

[Justin]

Hello and welcome to our Community, very glad to have you on board. Just make sure you ask any questions you have, and help others whenever you can :)

See ya on the boards!

[Justin]

Hello JP and welcome to our community! It's good to have you on board :)

[iwngue70]

Hello everyone,

I've been lurking from the background but just wanted to say hi. Thanks to Justin and everyone else for making such a great site. Relative beginner but looking to take control of my finances. Paper trading on the virtual stock exchange competition B and learning every day!

Take Care,

John

[patfergie44]

Originally Posted by Mike Campbell

Thanks for you're reply, That seemed to help some but when I ran HOG for example it Harleys MOS was $3.52 I'm sorry but no way unless my calculation are way of which came to $47.00

Help Please
Mike Campbell

Have you read the tutorial yet located here:

http://www.roicommunity.com/forum/automatic-margin-safety-calculators/669-tutorial-basic-spreadsheet-functions.html

I haven't run the numbers for HOG but I'm guessing that the tutorial should help explain why the spreadsheet comes up with 3.52.

[krypticide]

Welcome!

[tomjkm]

Hi guys I am back,
I joined the paper trading competition, but I guess it will start only in December, right? So what should I do till then?
Also regarding opening a brokerage account I would like to get more inputs from you guys. I am planning to start with a max of 2.5 grants. I went thru the sites of trade king and Scot trade, and I guess b'coz of the low commission at trade king I am leaning towards it. Is there any discussion in this forum regarding opening a brokerage account?
I also downloaded the excel spreadsheet MOS calculator. WOW!!!!! It’s amazing, kudos to all guys who have done the hard work.
Can you guys recommend some must read discussions in this forum.

[cowensmi]

Hello everyone! I have just registered on the site and I am already quite impressed with the level of expertise and assistance. I did not even know this site existed and stumbled on it by accident while doing a google search on ROIC. I backtracked and I could find no link to it from Phil's site. Anyway, I am glad I found it!

I read Phil's book over the summer and have been doing research for about the last two months. As one of the posts on the site mentioned recently, it seems hard to find a wonderful company in this market at this time - but i am still looking. Interestingly, many of the ones that fit my personal criteria (things I know, have an interst in, or are passionate about) are not publicly traded companies. The only one that was, Warren Buffet bought it - so i must be on the right track. :yellowsmile:

I have just rolled a dog mutual fund from my "full service" broker over to ScotTrade. As soon as the paperwork goes through and the money shows up in the account I am going to dump the fund and sit on the cash while I search. But at least I will have some money to start with. Not a lot, about $7,000. The rest of my mutual funds are actually doing good (finally) now that the market is coming up. In fact, i am just about to where I was in 2000:frown: . Another bunch of it is in 401K's where my ability to trade is severely limited - but I am using the three tools to keep an eye on it this time.

Let me just say that i know hindsight is 20-20, but if I had been more engaged in my investments (mutual funds) and was aware of the three tools back in 2000 - I wouldn't have lost my -you know what- for the last 6 years. My funds went from $125,000 down to a low of $75,000. I stuck it out and did not sell, and as I said I am just about back - but that was 6 years of nothing.

Anyway, I will be doing a lot of reading and asking questions on the site so i hope you all are pateient with me.

Thanks!:biggrin:

[cowensmi]

"I would like to get an expert advise from you guys, regarding opening a online trading account, which would be currently the best broker for a newbie rule1#investor? I can across td ameritrade, do anyone have any good or bad experience with then?"

I looked at a number of them and went with ScotTrade. As another member has posted, they had a local office and because I was rolling an existing IRA I liked being able to drop of my paperwork and ask questions. They seem to be a good compromise between a straight online broker and a full service broker and their trade fees seem reasonable.