A simple BitCoin trading robot in Excel


I am looking for an API interface with Excel 2013 for OKCoinUSD ([url removed, login to view]) on the 1 week BTC future. The amount of information requested through the API (and continuously updated) should be:

Last 30 5 min bars, open,high,low,close

last 30 15 min bars, open, high, low, close

last 30 30 min bars,open,high,low,close

Current market position

Current wallet balance

Best bid

Best offer

Last traded

Last update from API

In addition there should be an order management section:

Buylimit, sell limit, exit long limit, exit short limit, stoploss long, stoploss short

The limits will be calculated by the user in excel but the ordermanagement should send the respective orders to the exchange, and also ensure it does not put in multiple orders, if the order is only partly filled etc.

I have an example spreadsheet which is attached (two sheets, datasheet and tradesheet).

I will NOT work with someone who does not have the proper experience with APIs, Bitcoin trading and investment experience. You must have programmed something similar before and you must understand trading terms and how to handle orders.

If successful the programmer can be awarded several similar projects at a later date.

Compétences : Bitcoin, Excel, Visual Basic

en voir plus : will work for bitcoin, bitcoin how does it work, best bitcoin wallet, simple dice script bitcoin, excel options trading, excel backtest trading, excel problem trading concern, access vba excel task manager simple, robot trading tradestation, excel based trading software, search excel vba csv simple database, simple time management excel, robot trading mt4

Concernant l'employeur :
( 1 commentaire ) london, United Kingdom

Nº du projet : #8458099

Décerné à:


Hi, I am VB and GIS developer and well versed in Excel and programming of Excel using VBA or even developing Add-in for Excel using VSTO of .NET. I gave also courses in Excel for UN employees here in Palestine - Gaz Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 12 jours
(20 Commentaires)

3 freelance font une offre moyenne de $377 pour ce travail


Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation. Am on sk....p : yalanand

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(4 Commentaires)

Hi. I am a [login to view URL] Developer living in Paris, I have read your specifications and i want to realize your application. i have already developed several applications you can find in my folio. I need more informat Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(4 Commentaires)