0 Replies Latest reply: Sep 4, 2012 10:02 AM by brandon breitling RSS

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

    brandon breitling

      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.