Hi Jarlee,
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
