BlackRock Gold and General Fund D AccGB00B5ZNJ896:GBP

cmallwitz / Financials-Extension

Extension for LibreOffice Calc to access stock market data

Other

137 stars 17 forks source link

BlackRock Gold and General Fund D AccGB00B5ZNJ896:GBP #34

Closed R7914T closed 2 years ago

R7914T commented 2 years ago

At 31/8/21 at 9:12 BST I am not getting any prices on this link. How do you suggest I work around it?

cmallwitz commented 2 years ago

Checking https://markets.ft.com/data/funds/tearsheet/summary?s=GB00B5ZNJ896:GBP

and using =GETREALTIME("GB00B5ZNJ896:GBP",21,"FT")

I get a price. Can you double check on your side?

R7914T commented 2 years ago

I did not check that price as I use other ones in your list, but I have adjusted the spreadsheet to bring it in, if those others are not available. Thank you. In those circumstances I have found the IFS function particularly helpful as it greatly simplifies coding for choices.