Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Not getting updates #1

Open
Njel opened this issue Dec 12, 2017 · 8 comments
Open

Not getting updates #1

Njel opened this issue Dec 12, 2017 · 8 comments

Comments

@Njel
Copy link

Njel commented Dec 12, 2017

I used this tool for a couple of days and it was working prefect in Excel. Now it has been a few days I am not able to receive updates anymore. I tested that I can still connect to the websocket using a different program. In Excel the value I am getting is "<?>". So the communication between Excel and the RTD server is working. It seems to be the connection from the RTD server to the GDAX feed. The TestApp in the project is also not working and doesn't generate any error message.

@itsff
Copy link
Owner

itsff commented Dec 13, 2017

@Njel Are you still experiencing issues? I know GDAX had planned maintenance over the last 2 days.

@itsff
Copy link
Owner

itsff commented Dec 13, 2017

@Njel Out of curiosity - which fields are you subscribing to? Just the last price or something more?

@Njel
Copy link
Author

Njel commented Dec 13, 2017

I am subscribing to all the fields. What I noticed is that every time I restart Excel if I open a small workbook with already a RTD formula first I don't get the feed. But then if I add a new formula in a cell subscribing to the BID field then all the refresh start working and I can open my main workbook to get the refresh working also. It looks like the first time the system try to establish a connection it fails. But then because I am adding a new feed, not one that I already have in the spreadsheet, I guess the system need to subscribe to that new feed and the connection is established correctly. Let me know if you have any other questions. Thanks for taking the time to reply. Great tool BTW.

@itsff
Copy link
Owner

itsff commented Dec 22, 2017

I hope to get some coding time during the Christmas and will fix these issues. I may drop the web socket and switch to polling, since Excel gets updated on a timer anyway. That will make it more reliable.

@nikolhaas65
Copy link

nikolhaas65 commented Apr 15, 2018

I have the same, however, the update restarts after couple of changes of each RTD-feed, e.g.
"BTC-USD" -> "BTC-US" -> "BTC-USD"
This action is able to restart every feed. I guess that these are becoming loose after you shutdown Excel and restart it again. Perhaps, the async-link gets broken, I don't know. I guess, an additional mechanism is needed to terminate all feeds when Excel is closing.

@itsff
Copy link
Owner

itsff commented Apr 18, 2018

I need to add re-connect logic to ensure the connection gets restored, and instruments resubscribed. I'd like to switch to a newer webscket library, but this would also trigger an upgrade to .NET 4.6.1
Do any of you rely on the old .NET 4.0?

@itsff
Copy link
Owner

itsff commented Apr 18, 2018

I upgraded the project to .NET 4.6 and added automatic re-connect of the web socket. Please let me know if you see any issues.

@usb56
Copy link

usb56 commented May 1, 2018

@itsff I still have the issue with getting updates, recompiled the project again and again, but the excel doesn't get any data from the server.

error

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants