Need to load Yahoo Finance Profile and Statistics data into Qlikview

[#1]

I need to load Yahoo Finance Profile and Statistics data into Qlikview dashboard.

We have this code and it seems not working:

ProfileRaw:
LOAD
@1:n as YahooProfileText_raw
FROM [http://finance.yahoo.com/q/pr?s=$(vTicker)] (ansi, fix, no labels, header is 0, record is 100000 lines);

Industries_table:
Load * WHERE (index(RawTables,'Index Membership') and
index(RawTables,'Sector')and
index(RawTables,'Industry') and  index(RawTables,'Full Time Employees') );

LOAD '<table' & SubField(YahooProfileText_raw, '<table') as RawTables
Resident ProfileRaw;

[Industry Classfication]:
LOAD
'$(vTicker)' as Ticker,
[Industry:] as Industry,
[Sector:] as Sector,
[Sector:] & '/' & [Industry:] as [Sector / Industry],
[Full Time Employees:] as Full_Time_Employees
FROM_FIELD
([Industries_table], RawTables)
(html, codepage is 1252, embedded labels, table is @1, filters(
Rotate(right)
));

Need help to figure out how to pull the data I need: Industry, Sector & Full Time Employees.

Thanks

[robert_mika]

Can you share the variable definition?

[#3]

vTicker will hold the Stock Ticker.  We have this code going in FOR loop executing for each Ticker we have in our Database.

This code was written a year ago as a POC and worked fine. Now we want to deploy in production but we are not getting any data from it.

Thanks