I mainly use Robinhood and Personal Capital. I use a python script to download my transactions to a spreadsheet and depending on what I want to see I use templates I found online or on Google sheets. Personal Capital lets me see net worth and diversification pretty well.
I'm trying to get better at tracking why I purchased and specific account and when I thought I would profit to see if my expected return was achieved.
Here are some things I am trying to achieve right now with the sheets and tools I have:
I would like better tools to attribute wins/losses in general. I recently found a tool at http://simplywall.st/ that shows a lot of promise for this. Ideally, I would be able to look at a specific time period and see which stocks/EFTs contributed to my win/loss over that time period.
I would like to see price to earnings rations over time and projected/forward PE ratios.
I would like to see total return of each stock or ETF based on original price paid (not just an average cost basis) including dividends and transaction costs and ideally I would be able to factor in expense ratios for ETFs, taxes including any foreign taxes for ADRs and inflation assuming my annual tax bracket . If the transactions are known then one can tell when a year has passed since my purchase - sometimes I want to plan sales based on that 1 year mark; seeing a graph of all my holdings eligible for the long term capital gains would be helpful. Since I mainly use Robinhood, all capital gains are FIFO method and to that would be good enough for me for now (as opposed to specific lot or other means).
I am actually a Schwab banking customer and see the improvements you've been making and look forward to more - nice work.
​
Hey Kinship,
The default ordering is by market cap, but we can order by anything. For example to order by the value score:
http://simplywall.st/snowflake/grid/all/order-by-value
If you click on a snowflake, you can see why it has been give that score. We are 100% transparent on why we give each score (hover over the icons).
You will also find that all of our analysis is based on tried and tested value investing, stuff that you would find in 'Intelligent Investor' by Ben Graham.
So in fact you could say our site is the opposite of snake oil, unlike some other websites we are completely open and honest with all of our calculations.
Al
Not a shill or a recommendation but I personally find http:[//simplywall.st](//simplywall.st) to be a good site to help me get a grip on fundamentals of companies I'm looking at. I wound up paying for a subscription and I think it's pretty much worth it.
Huh a rather interesting website was linked in the comments of that article that gives in depth financial info on both companies.
http://simplywall.st/compare/NasdaqCM:AMD-NasdaqGS:NVDA
The estimated earnings growth between them in particular seems interesting, with Nvidia actually falling with AMD rising up to 90% in 3 years.
But really all Nvidia has right now is their discreet and professional GPU market. They have lost most of the OEM market, likely due to their ongoing lawsuit/threatening most of their OEM partners. Their Tegra SoC are winning less and less contracts each year and the most notable devices that uses them is their own tablet. Plus they are actually losing market share to AMD in the professional graphics segment. Not everything is all rosy over in Nvidia land.
The website simply wallstreet (http://simplywall.st) packages up a ton of fundamental data and lets you compare them to their competitors and industry. Pretty decent (and visually appealing) sparknotes of a company. plus its free.
Not good.
http://simplywall.st/NasdaqGS:AMZN/amazoncom
Also from what I have read, all the 'cash flow' that previous investors rave about is now made up mostly of depreciating assets... unclear what but potentially this is the servers from AWS.
As others have said PB is only 1 measure of valuation, you would rarely buy on it alone. The other market valuation metrics for Apache are looking negative at the moment due to their last earnings being negative.
http://simplywall.st/NYSE:APA/apache
However their balance sheet looks acceptable so it really comes down to what projects they have in the pipeline and if these are commercial at the current oil price vs $100/bbl.
Apache have historically been know for their ability to develop/ maintain fields that other oil majors found to be non-commercial (example is the Forties field that APA bought off BP http://www.offshore-mag.com/articles/print/volume-73/issue-8/north-sea/apache-finds-new-opportunities-at-forties-field.html)
Seeing as you aren't able to predict the oil price (clearly no one can), I would be looking for oil companies with projects that are commercial at $50-60, and if the price jumps back to $100 happy days.
This is the view you want: http://simplywall.st/snowflake/grid/all/order-by-total
Although we are not claiming that big+green = best rated, the best rated stocks are the ones that suit your investing style. e.g. dividends, undervalued, high growth etc.
Checkout http://simplywall.st - it's love it's UI and depth, and everyone in one place style, plus it's a global research tool no matter what exchange/market, first 14 days are free.
I’ve heard ETFs are nice and reliable but fairly low yield. Gold is doing really well right now as people pump into it when times are tough- I think it might dip though when the economy recovers. I used simply wall st to look at all facets of the business and you have ratings. Time will tell about how profitable they are. I think though at the moment dividends are being cut- at least with the 3 property companies I’m in. To answer your original question - split equally over all the companies, no ETFs. Probably a bad idea as I’m just greedy.
Search Google for "youtube ppcian" (would link but phone is awkward), he is excellent at explaining dividend and value investing. He releases videos every few days, although he is USA based - most of the content applies to the UK too.
You have to think long term, like 20+ years investing. You are extremely unlikely to make any consistent money day trading. I'd also recommend checking out http://simplywall.st
Hi there,
I'm not a product designer or coder, so most of what I have done is build services, provide advice to other business people and created guides and other content that simplifies, communicates and explains things. I'm proposing doing that in an advisory role for other founders.
Some of the projects and services that I have built include:
I'm also helping out Simply Wall Street - http://simplywall.st/ - by providing detailed feedback on their app and have also created an experiment where I am investing $30,000 of my own money through information provided soley by their app. More on that here: https://medium.com/stock-market-101/me-simply-wall-st-and-a-30-000-experiment
I also write on content creation, marketing, entrepreneurship, project management, blogging, trust management and more. You can find links to all of those guides here.
My background is in content creation, analysis, customer feedback, IT and communications management. If you'd like to know anything else, please do let me know.
If you're considering investing, but don't know the stock market, try this site: http://simplywall.st/snowflake/grid/first-time-share-stock-investor/order-by-market-cap Even if you do know the stock market, try that site, actually.
That's all I can say, really, so I hope it's useful. But you may have seen it before anyways, so yeah.
If you have a long term outlook these infographics on the two companies should help you look at the fundamentals in more detail.
http://simplywall.st/NYSE:VMW/vmware
http://simplywall.st/LSE:BP./bp
That listing for BP is on the London Stock Exchange, but same company same fundamentals.
As Relictorum says it completely depends on what EPS is used, this could be:
1) LTM (last twelve months from the last earnings release)
2) Last financial year (could be 2014 or 2013 for some companies that haven't released 2014 earnings)
3) Based on analysts estimates of future EPS, and how far ahead, 1 year, 3 years?
Also it depends how it is reported (easy to manipulate).. e.g. Primary, basic, (primary EPS) or fully diluted.
See: http://i.imgur.com/l4UNq0F.jpg
Recent Shareprice: $53
LTM Diluted EPS: 0.5123 (Last 12 months reported on Sep-30-2014)
Therefore PE ratio = 104.7
However if you use the Normalized Basic EPS for the same period:
Normalized Basic EPS: $4.06
PE ratio = 13.25
Or if you use analysts estimates for 2015:
Normalized Basic EPS: $8.98
PE ratio = 5.9
Nasdaq and Bloomberg may also be using a share price average from the last 30 days or more, which is not uncommon.
So the lesson is really to be consistent in what PE ratio you are using, so that it is comparable between companies an industries.
We use the LTM Diluted EPS and share price throughout Simply Wall St:
http://simplywall.st/NasdaqGS:AAL/american-airlines-group#value
http://simplywall.st/NYSE:SSW/seaspan
The dividend is high (8%), no doubt from the price drop, but also looks affordable going forward. Some investors would buy on that alone. They also have a serious amount of debt - no doubt borrowing to buy ships. Interest on the debt is most likely their main business cost.
One would think shipping is a business that will massively benefit drop a drop in oil price, hence there will be demand for more ships to lease.
You might find these biotech/ pharma focussed views useful to identify some hidden gems worth further research:
http://simplywall.st/snowflake/grid/all/order-by-future/6100000 (orders by future)
http://simplywall.st/snowflake/grid/all/order-by-total/6100000 (order by total size)
The ones you mention already show up on here not surprisingly, they are fairly well known.
You'll like the way Simply Wall St looks at stocks, each one has an infographic which looks in detail at what your talking about. It includes things like PE ratios and also looks at other areas such as the balance sheet and debt.
This is a great website! I've signed up for the beta, whatever that will do (currently nothing?)
Minor usability improvement: the "flag" icon tooltip could show why the stock was flagged, instead of providing a list of possible reasons.
You could consider blacklisting known spammers from the "social" section of a stock report. For example atm the entire social panel for NYSE:KRO is full of links to a scam domain, and none of them shows up in Stocktwits: http://stocktwits.com/symbol/KRO?q=kro
Finally, what about some kind of "advanced search"? It would be useful to let users pick the parameters most important to them.
For example i'm using the url to change the default ordering on "dividends that beat savings" list, as future stability is more important to the people i'm doing research for than short/mid term dividends. http://simplywall.st/snowflake/grid/dividend-better-than-savings/order-by-future
If you look at the value section for HSBC Holdings, it has a stat for dividend amount, and historical dividend yield, but then under 'current payout to shareholders' a red X with 'The company does currently not pay a dividend'. What's going on with that?
No your right, we are aiming for users who don't know was EPS and PE are, they all there, but visualised.
Dividend is really easy to find: http://simplywall.st/NYSE:JNJ/johnson-johnson#income
I think also worth making clear we are not expecting people to invest on the 'snowflake' alone - far from it - its just allows a quick snapshot of the company before diving into the detail.
If you click on the black bars you can see the inputs to our intrinsic value calc - it is something we hope to improve the future.
The reason for Yahoo's high value is the past growth in EPS, which you can see here: http://simplywall.st/NasdaqGS:YHOO/yahoo#past
Hey Magmagmag,
Click here to start exploring some companies that might be suitable for a first timer: http://simplywall.st/snowflake/grid/first-time-share-stock-investor/order-by-market-cap
Then once you click on a company, make sure you turn on 'Beginner Mode' - it might be overwhelming at first, but the bear will guide you through and we try to explain every aspect in a way that you can understand.
Let me know how you go.