search

itsff / crypto-rtd

Excel RTD server sourcing GDAX ticker data via websockets
MIT License
16 stars 6 forks source link

Not getting updates #1

Open Njel opened 6 years ago

Njel commented 6 years ago

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 commented 6 years ago

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

itsff commented 6 years ago

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

Njel commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

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 commented 6 years ago

@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