Skip to content

This repository allows user to use Bitbns API via Google Sheet API.

License

Notifications You must be signed in to change notification settings

bitbns-official/bitbns-google-sheets-api

Repository files navigation

Contributors Forks Stargazers Issues LinkedIn


Bitbns Google Sheets API

This repo allows user to use Bitbns API via Google Sheets. This had advantage of not needing any servers or deep tech knowledge to do API trading etc. The bundled application allows user to create Systematic Investment Plan(SIP) in any token listed on Bitbns at desired frequency(hourly, daily, weekly or monthly)
Explore the docs »
· Report Bug · Request Feature

Table of Contents
  1. About Bitbns
  2. Built With
  3. FAQs
  4. Changelog
  5. Getting Started
  6. Usage
  7. Issues
  8. Contact
  9. Acknowledgements

About Bitbns

www.bitbns.com

Built With

FAQs

  • Refer to this doc for more information

Changelog

  • Refer to this doc for changelogs.

Getting Started

  1. Make a copy of this google sheet.
  2. Go to bitbns website to generate API keys or click on this link
  3. Copy the public and private key and paste them into config sheet in the corresponding cells.
  4. Go to add ons and select Bitbns API SIP and then select Bitbns SIP. This adds a sidebar in your copy of sheet.
  5. It is important that you use primary google account for trading. If not,then you would have to the application in incognito mode because of primary account issue with google apps script.

Usage

  • After adding the sidebar, you can simply select the token from the given list, and select the frequency and the amount to be invested. The minimum amount should be greater than equal to ₹100. You will get a confirmation alert on the screen when placing the SIP.
  • After the SIP is placed ,the details about that would appear on the SIP sheet.
  • To delete an SIP, you have to enter the trigger id of the SIP and click on delete SIP.
  • It is very important to not change the trigger id of any SIP as it is very crucial for smooth working of the application. In case you accidentaly change the trigger id and forget what it was originally, you would have to go to the script editor and run the "Delete all SIP" file.
  • You can check your bitbns wallet for more details about your purchases and sellings.
  • For more details, here is the medium article about that.

Issues

  • Can't use a secondary account without being in incognito beucase of this issue in GAS(Google Apps Script).
  • The issues faced here might be reflected in the application as well.

Acknowledgements

License

MIT License

Copyright (c) August 2017-2021

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Contact

About

This repository allows user to use Bitbns API via Google Sheet API.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published