Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Demo Document pulls from Yahoo key stats page, how to pull from Yahoo Income Statement?

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.

Community Browser