Stock Forum

Discuss value investing stock ideas

You must be logged in to post
Search Forums:


 






Wildcard Usage:
*    matches any number of characters
%    matches exactly one character

Spreadsheet idea

No Tags
UserPost

11:29 am
August 5, 2010


itconsultant

Irving, Texas

Member

posts 34

9

I think the opposite screener would be a good one too. Can give ideas for shorting. I will try it out on robotdough.

12:19 am
August 5, 2010


Jae Jun

Admin

posts 1336

8

My screener for the Altman Z is set up to return companies where the Z score is greater than 3.

I wont explain how I do it for business purposes but I'm sure you can create your own screeners through http://www.robotdough.com or aaii screen.

2:31 pm
August 3, 2010


itconsultant

Irving, Texas

Member

posts 34

7

Jae,

 

Screener question…

 I want to use the Z score to find the companies with lowest Z score. Does your current screener do the opposite? ie.  Find companies that are strongest as per Z score? I want to find the weakest as potential short candidates. Also, how are you running the screener and updating it ( weekly , offline )?

 

 

10:23 pm
August 1, 2010


Jae Jun

Admin

posts 1336

6

Well a screening system would be way out of my expertise at the moment. But if I ever do decide to create one, I will definitely have to pay for the data and have my own servers.

Only problem is that it costs thousands of dollars per month…

6:01 am
July 31, 2010


maxi

Member

posts 5

5

Post edited 7:51 pm – July 31, 2010 by bachirodriguez


In case you plan to make a screening system, I think it could be wise if you place a proxy server for all the financial data. In this way your users access the data in your machine. If the users download the data from the financial provider that could be quite noticeable since it's a lot of information. Because you are overloading their servers and not paying for the data I think they will try to block you in some way.

Bachi

6:09 pm
July 30, 2010


itconsultant

Irving, Texas

Member

posts 34

4

I have developed a watchlist in Google Docs using the ideas on this site.

Here it is.

 

http://spreadsheets.google.com…..utput=html

 

You can make a copy of it and save it in your google account. You can add new stocks or replace what  I have. Enter the stock, the price you want to buy it at and sell price. The sheet shows current price, P/E ratio, discoint to buy price, 52 week low and high, market cap , earings yield

 

8:25 am
July 29, 2010


tycoonborg

New Member

posts 1

3

I uused an add-in called eTikr but they appear to be defunc. I would like to see a spreadsheet that has the same functionality of eTikr again.

11:25 pm
January 3, 2010


Jae Jun

Admin

posts 1336

2

You mean so that you can track the companies that you've looked at before right?

I do have something like that but I'm testing to see it's effectiveness and whether I can keep the competitive advantage compared to other products. But it is something I have in a beta spreadsheet.

8:33 pm
January 2, 2010


dmop12

Member

posts 39

1

I was thinking it might be nice to have a spreadsheet where you can enter multiple ticker symbols of previously researched companies that would show their current price and what the price of the stock needs to be at to purchase considering MOS rates. I hope that makes sense.

Thanks,

David

No Tags


About the Stock Valuation Software forum

Most Users Ever Online: 147

Currently Online: Graeme
11 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 4
Forums: 40
Topics: 694
Posts: 3680

Membership:

There are 868 Members
There have been 8 Guests

There is 1 Admin
There are 3 Moderators

Top Posters:

somrh – 273
Graeme – 122
zehua – 96
valueinvestortoday – 75
nell – 67
krackerjack121 – 67

Recent New Members: kalidas, NathanB21, jademan10, romans122, vincentbston, mrpenguin

Administrators: Jae Jun (1336 Posts)

Moderators: Jae Jun (1336 Posts), VANYA (1 Post), djsun (0 Posts)