Hi Community,
There's a Demo Document on the QV site called Financial Stock Analysis
KeyStats:
Load
'$(vTicker)' as Ticker,
num([Management Effectiveness: Return on Assets (ttm) - RAW]) as [Management Effectiveness: Return on Assets (ttm)],
num([Management Effectiveness: Return on Equity (ttm) - RAW]) as [Management Effectiveness: Return on Equity (ttm)],
...
Enterprise Value - RAW],'K','')*1000,[Valuation: Enterprise Value - RAW])))) as [Valuation: Enterprise Value]
;
load
RemoveHTML(TextBetween(TextBetween(YahooKeyStatsText, 'Enterprise Value',''),'<td class="yfnc_tabledata1">','</td>')) as [Valuation: Enterprise Value - RAW],
RemoveHTML(TextBetween(TextBetween(YahooKeyStatsText, 'Return on Assets',''),'<td class="yfnc_tabledata1">','</td>')) as [Management Effectiveness: Return on Assets (ttm) - RAW],
RemoveHTML(TextBetween(TextBetween(YahooKeyStatsText, 'Return on Equity',''),'<td class="yfnc_tabledata1">','</td>')) as [Management Effectiveness: Return on Equity (ttm) - RAW],
...
;
LOAD Replace(YahooKeyStatsText_raw, TextBetween(YahooKeyStatsText_raw, '<head>', '</head>'), '') as YahooKeyStatsText
;
LOAD
@1:n as YahooKeyStatsText_raw
FROM [http://finance.yahoo.com/q/ks?s=$(vTicker)] (ansi, fix, no labels, header is 0, record is 100000 lines);
The page that I want to pull from income statment is here: http://finance.yahoo.com/q/is?s=$(vTicker) I have a basic idea hos the code is working just don't know how to sort through the page to pull off what I need. I would guess that they should be very similar to pull from as far as code.
