I have just started using the Financial Extension with LibreOffice Calc and I find the spreadsheet very slow to load. BUT the extension works and downloads prices OK it just takes a long time'
I am using Windows 10 latest version, 16 gb Ram, Processor AMD Ryzen 5 2600 Six-Core Processor, 3400 Mhz, 6 Core(s), so an inadequately powered PC should not be an issue.
I am not overly technical but his is what I did:-
1) Created two separate spread sheets one for FT and the other for Yahoo
2) I used two of the functions as shown in your webpage ie
=GETREALTIME("EURUSD","LAST_PRICE","FT")
=GETREALTIME("IBM",21,"YAHOO")
3) I inputted on each sheet Name, Ticker symbol and Price as headers, then inputted various securities, Shares, Investment Trusts, Mutual Funds and one Bond and one Index 32 in all. I then put the formula in each of the cells under price, just changing the Ticker symbol to the ones I wanted
Everything went fine first time round on each sheet all Securities Index and Bond prices were fetched correctly. It is just a) so long to load the spreadsheet b) so slow to fetch the prices. Since then it is repeatable but SLOW.
Do you have any suggestion as to why this is happening and what I can do about it?
Hello @ cmallwitz
I have just started using the Financial Extension with LibreOffice Calc and I find the spreadsheet very slow to load. BUT the extension works and downloads prices OK it just takes a long time'
I am using Windows 10 latest version, 16 gb Ram, Processor AMD Ryzen 5 2600 Six-Core Processor, 3400 Mhz, 6 Core(s), so an inadequately powered PC should not be an issue.
I am not overly technical but his is what I did:-
1) Created two separate spread sheets one for FT and the other for Yahoo
2) I used two of the functions as shown in your webpage ie
=GETREALTIME("EURUSD","LAST_PRICE","FT")
=GETREALTIME("IBM",21,"YAHOO")
3) I inputted on each sheet Name, Ticker symbol and Price as headers, then inputted various securities, Shares, Investment Trusts, Mutual Funds and one Bond and one Index 32 in all. I then put the formula in each of the cells under price, just changing the Ticker symbol to the ones I wanted
Everything went fine first time round on each sheet all Securities Index and Bond prices were fetched correctly. It is just a) so long to load the spreadsheet b) so slow to fetch the prices. Since then it is repeatable but SLOW.
Do you have any suggestion as to why this is happening and what I can do about it?
Thank you
Terry