Stock market

gidon500 — Fri, 13 Jan 2012 13:22:51 GMT

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

sales , buy , commitions etc .

thanks

gidon

Re: Stock market

djsampat — Fri, 05 Jun 2015 05:02:11 GMT

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

topic Re: Stock market in QlikView

Stock market

Re: Stock market