Bitcoin Forum
March 19, 2018, 09:19:22 PM *
News: Latest stable version of Bitcoin Core: 0.16.0  [Torrent]. (New!)
   Home   Help Search Donate Login Register  
Pages: [1]
Author Topic: How to Download Backtesting Candles For Any Exchange  (Read 2047 times)
Jr. Member
Offline Offline

Activity: 41
Merit: 0

View Profile
August 19, 2013, 07:39:12 PM

Here's another method I have found to download candles for the Gekko backtester. This lets you get information for ANY time period or exchange.

1. Pick your time period and interval on bitcoincharts, for hourly this tops off at 5 months
2. Hit "load raw data" at the bottom of the chart
3. Highlight the beginning of your selection
4. Scroll to the bottom and shift click the end of your selection
5. Open excel and click and drag your selection into excel
6. Repeat 1-5 as necessary for your desired time period
7. Delete the volume and weighted price columns
8. Use this formula to convert to unix timecode:=(A2-DATE(1970,1,1))*86400
9. Click the bottom right corner of the formula square and drag to the end of your data
10. Copy unix timecodes
11. Right click, paste values only into timestamp column
12. Rename column timestamp to date (not sure if necessary?)
13. Save in CSV format
14. Run the backtester using your shiny new candles

Strangely, these candles are slightly different than whynothing's and nitrous', and lead to totally different backtest results. I encourage others to try this method and to provide input. I am inclined to trust these candles more than the calculated ones, since bitcoincharts is widely used.

Please don't hesitate to ask any questions if my instructions are unclear!

Tip Jar: 15JYcTR2kr79i5Sxzjgk93WywXRkQtTgtf
Hero Member
Offline Offline

Posts: 1521494362

View Profile Personal Message (Offline)

Reply with quote  #2

Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
Sr. Member
Offline Offline

Activity: 246
Merit: 250

View Profile
August 20, 2013, 11:50:49 AM

Hi, for anyone following this thread, I have posted some reasons for the data discrepancies here and here. In short: don't worry about the differences, all this data should still be useful to anyone who needs it.

Also, well done and thanks to TradesLikeAPotato for finding a new method for easily obtaining trade data (especially for all exchanges)!

Donations: 1Q2EN7TzJ6z82xvmQrRoQoMf3Tf4rMCyvL
MtGox API v2 Unofficial Documentation:
MtGox API v2 Unofficial Documentation Forum Thread:
Pages: [1]
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!