Hello,
I have an intermittent problem with an RTD add-in that provides live stock/options quotes into excel. The add-in has been provided by the company ("webiress"). I am requesting about 270 quotes at a time (or might be double this if (ask + bid)/2 in one formula is counted as two quotes). Sometimes when I open the excel worksheet, all values update correctly (and will continue to do so for the rest of the day). But some days I will open the worksheet and some values are updating correctly, and others are not returning results.
As I am looking at the screen now, about 95% of the values are being returned correctly - and 5% are returning the result "#VALUE!". There is a small java program which supplies the RTD feed to excel - and if I request a quote for the results that excel isn't returning - I do get a result from java.
The only way to fix the issue seems to be to try:
- restarting excel
- restart the java progam and then excel
- or restart the whole computer.
Some days these options don't seem to fix the issue.
I have updated java.
Is there another method to get this working more consistently - or to reset if its not working on a particular day?
Thanks,
I have an intermittent problem with an RTD add-in that provides live stock/options quotes into excel. The add-in has been provided by the company ("webiress"). I am requesting about 270 quotes at a time (or might be double this if (ask + bid)/2 in one formula is counted as two quotes). Sometimes when I open the excel worksheet, all values update correctly (and will continue to do so for the rest of the day). But some days I will open the worksheet and some values are updating correctly, and others are not returning results.
As I am looking at the screen now, about 95% of the values are being returned correctly - and 5% are returning the result "#VALUE!". There is a small java program which supplies the RTD feed to excel - and if I request a quote for the results that excel isn't returning - I do get a result from java.
The only way to fix the issue seems to be to try:
- restarting excel
- restart the java progam and then excel
- or restart the whole computer.
Some days these options don't seem to fix the issue.
I have updated java.
Is there another method to get this working more consistently - or to reset if its not working on a particular day?
Thanks,
Last edited: