Pulling Stock prices in Qliksense

[anagha9489]

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 )

[chrismarlow]

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.

[bewerent]

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?