topic Re: Pulling Stock prices in Qliksense in App Development

Pulling Stock prices in Qliksense

anagha9489 — Wed, 22 Dec 2021 19:11:32 GMT

Hi All,

I am trying to pull stock prices for various stocks by using webfile connector, its working for single stock (company) but when i am trying to make it dynamic ,its not woking .

step 1:Inline table: where all stock name (company name),

step2:create a variable which will fetch single stock name from inline table

step 3:use the variable in step2 and add in the connection string like below:

[lib://SP$(var)];

SP is the connection string where i have added url as /https://finance.yahoo.com/quote/'

Example when its working for one stock name :

LOAD
@1,
@2
FROM [lib://SP ]
(html, codepage is 28591, no labels, table is @1);

here the value of SP:https://finance.yahoo.com/quote/shld/ (for above )

Re: Pulling Stock prices in Qliksense

chrismarlow — Wed, 25 Nov 2020 14:05:56 GMT

Hi,

Think the answer is in here Solved: Connection string URL dynamic - Qlik Community - 1553780.

You use 'url is' in the additional details on the FROM, similar to below;

LOAD @1, @2 FROM [lib://SP] (url is 'https://finance.yahoo.com/quote/shld', html, codepage is 28591, no labels, table is @1);

EDIT - where you replace shld with your variable ...

Cheers,

Chris.

Re: Pulling Stock prices in Qliksense

bewerent — Mon, 31 Oct 2022 12:47:17 GMT

Is it possible to create a bot that would do Forex trading instead of me, taking into consideration the current state of the market?
I would need this bot to read cfd indices trading and use them to speculate on the overall performance of industries or stock markets just like regular traders do. Of course, such a program would be less effective than a real person, but the advantage is that it can work without any rest for days and months. If it was set to move in the right direction, it would eventually bring me lots of money. What do you think about such a plan?