I simply wish to import available TSE quotes (canadian) in to excel cells.
I have played with Yahoo and Microsoft money web queries but have been unable to come up with a simle customable solution.
If my sheet looks like this:
THI QUOTE
TZX QUOTE
ARJ QUOTE
BCE QUOTE
I would like this
THI $34.004 etc.
Is it possible to insert a formula that would vlookup the stock name eg. THI and then OFFSET a webquery returning the closing day price?
I apoligize if I'm asking a common question answered before but I don't seem to be able to find a solution.
Yes there are tons of examples online but they all seem to want to produce a seperate sheet customized..
Thank you for your time.
I have played with Yahoo and Microsoft money web queries but have been unable to come up with a simle customable solution.
If my sheet looks like this:
THI QUOTE
TZX QUOTE
ARJ QUOTE
BCE QUOTE
I would like this
THI $34.004 etc.
Is it possible to insert a formula that would vlookup the stock name eg. THI and then OFFSET a webquery returning the closing day price?
I apoligize if I'm asking a common question answered before but I don't seem to be able to find a solution.
Yes there are tons of examples online but they all seem to want to produce a seperate sheet customized..
Thank you for your time.