As I continue to learn, grow, and evolve as an investor, my decision making tools should do the same. I just finished adding a Free Cash Flow (FCF) metric to my Scorecard. This will provide deeper insight than earnings per share (EPS) and dividend yield. I have built a number of cases into my sheet to evaluate different combinations of FCF and Dividend Safety:

- FCF Negative Case: FCF Negative = 0
- "Safe" Dividend Case: FCF Positive & Total Dividend/FCF < 50% = 1
- "Unsafe" Dividend Case: FCF Positive & Total Dividend/FCF > 50% = 0.5
- ETF Case: Has Dividend, but no FCF = 1
- No Dividend Case: FCF Positive, but no Dividend = 1

Some insight into the "brains" of the operation - from my Roth IRA Sheet:

![](https://cdn.commonstock.com/3a2cdac6ec4feeb778bc910526f6b5eae7b7cca750cd0140f967a9820b0a5e30-1025x453.png)

It took a number of days to try to work out all the IF statements and clean up some of the data inputs to make the Rank Score work...

![](https://cdn.commonstock.com/79b22ed7411921eaceeaf0d5d225804e2973c114ff60109f2298c92a97745054-922x18.png)

FCF is the most manual metric that I am now tracking. My plan is to transpose FCF from Koyfin, quarterly. If anybody has a way to automate or live-source from a website, it would be much appreciated!

Have a great weekend!

+1 for sourcing data automatically from Koyfin but I don't think it's possible. From their FAQs:
"We don’t allow users to get data via API because of restrictions from our data providers. They are in the API business. We are in the analytics business."

Steve Matt

Scorecard Update - New KPI

This member is verified by the Commonstock team based on their contributions to the Commonstock community. 

Verified Member

This member connected a brokerage account and is sharing trades and portfolio performance with the community. 