Re: Refresh seem slow

[Michael Pepperney]

Actually I like the N/A’s showing. I have a spreadsheet with thousands of rows for stock and etf symbols.  When I update sometimes a stock doesn’t update(several reasons should be causing it..delisting, merger with an another company,etc.). 

 

I have a sum function at the top of columns and if after I click EPF Update (I like it set to manual update) if a good value doesn’t appear in the sum cell I know there is a bad entry somewhere on one of the thousands of rows. So, I simply filter based on N/A and that row (or rows) shows up by itself and I usually then just simply delete the row. The N/A result make it really easy to know if all value feeds from EPF came in.

 

So, for me at least the N/A showing up on update is really useful and would not want to see it changed.

 

My 2 cents worth.

On Sunday, October 19, 2025 at 12:42:38 PM UTC-4 esa...@gmail.com wrote:

I just started using EPF and like it - mostly.

It is much superior to native Excel stock functions.

I set updates to 2 min or 30 sec - but all my calculated cells show "N.A."  for 2 to 3 seconds while it updates.  I have so many calculated cells it really is annoying.

Is there a way to have it do updates in the background - or just to not have all the N.A.'s ?

[Andrew Sinclair]

The "#N/A" cell behaviour is not specific to Excel Price Feed, it is how Excel indicates that a cell is waiting for an asynchronous function call to complete.

In this case the cell is waiting for the call to retrieve the price/market date/etc. to return (which can take several seconds depending on network traffic etc.) and the N/A indicates this; the cell is in effect in an indeterminate state.

We could change the message, some Add-ins provide their own message, however "#N/A" is the Excel standard and it has been in Excel Price Feed since the first version so we are reluctant to change it now.

I hope this helps explain how and why our software operates like this.

Kind Regards,

Andrew Sinclair

Excel Price Feed

[Steve]

I don't see this as a problem; in fact, it is helpful as mentioned in an earlier post.  

[Peter Haynes]

No, it is not common for everything. The native Excel stock function does not do that while updating.

You like what you like, I like what I like.

For me it is a deal breaker - I'm not going to buy something (i.e. EPF) that annoys me.