#N/A

[serge mathieu]

Excel Price Feed is very interesting, but we have difficulties using it because it generates numerous #N/A within the data. These #N/A make it almost impossible to use the data for further calculations.

The data we need is not intended to be simply displayed on screen: we need to apply further calculations on it, and the #N/As  make this almost impossible.

Using Excel 365 stock functions, no #N/A are generated in (for example) stock price data, suggesting that it should be possible for Excel Price Feed to do the same, making the data usable.  

As a simple (and uncomplete) example, see the attached file. 

Suggestions to eliminate #N/A???

[katerina.a...@gmail.com]

In the simple sheet attached we can see two cells that are circular references (they reference themselves): cells D21 and F21. So that is causing the #N/A values in this example. We also noticed an Excel circular reference warning when we first opened the sheet.

Even when we replace the EPF formula in cell B21 with a simple number, we are still getting the #N/As.

I assume this simplified sheet is not representative of the actual problem you originally saw?

Is it possible to send a version of this sheet with the Excel 365 stock functions in so we can see a version that works as you intend it to? Then we can try and replace the values with some of our formulas to see whether the problem persists?

Many thanks,

Katerina