1 Reply Latest reply: Jun 5, 2015 1:02 AM by Dhruv Sampat RSS

    Stock market

    gidon david

      Hi

      i am looking for a qlikview model  to  handle my  stock market positions

      sales  , buy ,  commitions etc .

      thanks

      gidon

        • Re: Stock market
          Dhruv Sampat

          Hi Gidon,

           

          You can search for any stock related sites, find the historical rates or a page that has a table that can be used to either make a table or graph and then manipulate it within Qlikview.

           

          How to do it, get the address of the site, click on Web Files, enter the address in the Internet file and follow the wizard. You can use Enable Transformation Step to rename headers or remove non-essential lines and use a cross tab and you are done. View example below.

           

          e.g.

           

          QUALIFY *;

          UNQUALIFY Date;

          AORD:

          LOAD Date,

              Open,

              High,

              Low,

              Close,

              Volume,

              [Adj Close*]

          FROM

          [https://au.finance.yahoo.com/q/hp?s=%5EAORD]

          (html, codepage is 1252, embedded labels, table is @10, filters(

          Remove(Row, RowCnd(CellValue, 1, StrCnd(start, '*')))

          ));

           

          If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

          If you are viewing this topic and found it informative, please like my comment.

           

          Regards

          Dhruv