| User | Post |
|
1:12 pm
September 4, 2010
|
Jae Jun
| | |
| Admin
| posts 1453 |
|
|
Here is a fix that should hopefully do it.
Enter the following formula into cell N5 of the statements tab in the stock valuation spreadsheet.
=RIGHT(RCHGetTableCell("http://www.smartmoney.com/quote/"&Ticker&"/?story=financials&timewindow=1&opt=YI",2,">Income Statement (Non-Cumulative)",,,,1,"</table"),4)
|
|
|
9:48 am
September 3, 2010
|
MarkGillCPA
| | |
| New Member | posts 2 |
|
|
Post edited 9:48 am – September 3, 2010 by MarkGillCPA
Just ran it on WMT and COH (most retaliers have fiscal year ends) and it ran just fine. So it's not due to the fiscal year end. Just some stocks (like PLXS) do not pull the date field correctly, resulting in an "error" on cell N5 of the Statements sheet, and cell L9 on the DCF Valuation sheet.
|
|
|
9:11 am
September 3, 2010
|
Jae Jun
| | |
| Admin
| posts 1453 |
|
|
Let me take a look and see what I can do.
|
|
|
9:08 am
September 3, 2010
|
MarkGillCPA
| | |
| New Member | posts 2 |
|
|
I notice that the valuation spreadsheet (v20100821.xlsm) works fine for companies with a calendar year end. But when I enter a company like PLXS, that has a Sept year end, the fiscal year dates do not load correctly at the top of the DCF valuation page, which keeps the whole DCF from calculating correctly. Any ideas? Has anyone else run into this?
|
|
Home
