Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

gidon500
Contributor II

Stock market

Hi

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

sales  , buy ,  commitions etc .

thanks

gidon

Tags (1)
1 Reply
djsampat
Contributor II

Re: Stock market

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

Community Browser