Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
gidon500
Creator II
Creator II

Stock market

Hi

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

sales  , buy ,  commitions etc .

thanks

gidon

1 Reply
djsampat
Creator II
Creator II

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