Hi
I have created in the past a spreadsheet that go and fetch data from another website
This is a financial table where I get the current market price (in the exemple below it is about cryptocurrencies)
value(index(importhtml(concat("https://coinmarketcap.com/currencies/",B7),"table",1),1,2)))
The formula works very well.
My table list the different purchases or sales, calculate the average cost and calculate the profit and loss based on real time value with the formula above.
Until recently everything worked fine.
I am now adding new calculations which have nothing to do with the above formula nor do I refer to the cells used by the above formula or call for the results of the above formula.
The new calculations works fine. However, at random, the above formula shows #N/A instead. Once it shows #N/A it never goes back to display the current price.
I first thought there was some problem with coinmarketcap. In that case once coinmarketcap is working again, the #N/A should be automatically replaced by the value of the coin. No once the cells display #N/A and stay at #N/A.
I thought I messed with the spreadsheet somehow. I restored a previous version (the last one before I started to add the new calculations) and the price of the coins are displayed again.
I started again with the new calculation (for info the new calculation are in a separate worksheet and as mentioned it does not refer to above formula). It works fine for a little while and suddenly, some of the cells having the above formula start showing #N/A
This makes me crazy. No matter what I do, those cells somehow ends up (but not all) with #N/A. What I mean is that I have about 20 cells using the above formula and when the problem occurs, sometimes it occurs for all the cells using the above formula, sometimes not.
I seems random.
I am starting to wonder if there isn't a bug in Sheet (after all Excel is full of bugs, so why not Sheet :) )
Has anyone encountered such behaviour?
Thanks
Top comments (0)