Retrieve live data from index fund

[jeff2813]

Hi there. I own shares in a Canadian index fund. Fund code is RBF556. Canadian index fund. I was just wondering if there is a way to retrieve the quote automatically from the web when the spreadsheet is open. Thank you.

 

[James006]

Hi,

You can create a Data Query against your target web site ...

such as https://www.rbcgam.com/en/ca/products/mutual-funds/rbf556/detail

Hope this will help

 

[alansidman]

Look at this link. I use this to get stock prices on a daily basis. Not sure if it supports Canadian stocks.

https://appsource.microsoft.com/en-...cb43-56bf-4772-8547-c648bba2ab45&referralurl=

 

[James006]

You can also simply use Power Query :

https://exceloffthegrid.com/power-query-import-data-from-the-web/

Hope this will help