In Google Spreadsheet, Function GoogleFinance() don't work with many stock exchanges.
And if we try:
then we get error message: #NA
error: The TSE exchange is not supported.
Any alternate solution for this?
You can try the following formula as a workaround:
=ImportXml("http://www.google.com/finance?q=TSE:XEC", "//span[@class='pr']//*" )
Have a look at the screenshot below:
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.