Finding Past Candles on Ethereum Using Binance Net: The “DateTime.AddSeconds” Issue
As an avid cryptocurrency trader, you are probably no stranger to working with data streams from various exchanges. However, when searching for past candles on Ethereum using the Binance.Net API wrapper, a common issue arises that can render your code unusable. In this article, we will explore why “DateTime.AddSeconds” is not working properly and provide a solution to overcome this limitation.
The problem is DateTime.AddSeconds
When used, the “DateTime.AddSeconds” method adds seconds to the specified date/time value. This can be problematic in certain scenarios, especially when working with candlestick data from exchanges that record their prices in UTC (Coordinated Universal Time).
In Ethereum, candles are usually stored as UTC timestamps, which means that any changes to the timestamp using the “DateTime.AddSeconds” function will not result in the previous candle being displayed correctly.
Workaround: Use “DateTime.FromTicks” or “DateTime.ParseExact”
To find the previous candle, you need to convert the timestamp to a DateTime object. However, since Binance Net uses ticks for API returns (instead of seconds), you need to use one of two approaches:
DateTime.FromTicks: This method allows parsing UTC timestamps stored as ticks (int64 values) and returns a DateTime object.
var previousCandle = await Binance.Net-api.Client.Candles.GetPrevious(orders, 0);
var previousDate = new DateTime(previousCandle.DateUTC.SecondsSinceEpoch / TimeSpan.TicksPerSecond);
DateTime.ParseExact: If you have a UTC timestamp as a string in the format YYYY-MM-DDTHH:MM:SSZ, you can use this method to parse it into a DateTime object.
var previousCandle = await Binance.Net-api.Client.Candles.GetPrevious(orders, 0);
string previousTimestamp = previousCandle.Timestamp;
Date and time? previousDate = DateTime.ParseExact(previousTimestamp, "yyyy-mm-ddTHH:mm:ssZZ", null);
Using DateTime.FromTicks
To get the most out of the above solution, use the following code snippet as a starting point:
var orders = await Binance.Net-api.Client.Order.GetOrdersAsync(ordersymbol, ordertype, datetime. now, new OrderInfo { Side = Side.Buy });
var previousCandle = await Binance.Net-api.Client.Candles.GetPrevious(orders, 0);
var previousDate = new DateTime(previousCandle.DateUTC.SecondsSinceEpoch / TimeSpan.TicksPerSecond);
// Use previous candle data
Using DateTime.ParseExact
You can parse UTC timestamps into strings in a specific format (e.g. “YYYY-MM-DDTHH:MM:SSZ”) using the following code snippet:
var orders = await Binance.Net-api.Client.Order.GetOrdersAsync(ordersymbol, ordertype, datetime. now, new OrderInfo { Side = Side.Buy });
string previousTimestamp = orders[0].CandleTime;
Date and time? previousDate = DateTime.ParseExact(previousTimestamp, "yyyy-mm-ddTHH:mm:ssZ", null);
In summary, when working with Binance Net and looking for past candles on Ethereum, “DateTime.AddSeconds” is not a reliable method due to the difference between pips and seconds. You can overcome this limitation by using “DateTime.FromTicks” or “DateTime.ParseExact” and retrieve past candle data accurately.
Remember to ensure accurate timestamp parsing and conversion when working with APIs that store their prices in UTC.