Connect Vega to Microsoft Excel or Google Sheets [701 DAI]

cdm commented 3 years ago

Vega bounties

Vega is a proof of stake blockchain for creating and trading derivatives. It provides infrastructure for decentralised markets that settle in assets held on Ethereum, and in future also Bitcoin and other major collateral blockchains. Vega facilitates high speed, permissionless derivatives markets.

The Vega public testnet showcases our technology and we are looking for passionate and talented members of the community to help us build out the vision by working with us to shape the end product.

Description

Inspired by projects like "Cryptosheets" and the team's general love for all things spreadsheet, the task for this bounty is to connect the Vega Testnet API data to Google sheets or Microsoft Excel and provide a set of useful operations e.g. trades for public key, list of markets, etc.

Please refer to Vega Console for an existing GUI that presents Vega API data.

Acceptance criteria

Choose either Google Sheets or Microsoft Excel as the spreadsheet client to work with.
Connect to Vega's APIs (REST, gRPC or GraphQL) from the spreadsheet client in order to load and display Testnet data in the spreadsheet. Note: It is recommended to make the node to connect to customisable (there are several geo-located API nodes).
Whether the code is scripted, embedded or added as a plugin can be decided by you.
Here is a list of potential views/operations* to include:
- List markets and market data
- List governance proposals and voting data
- Party (for a public key) data, including orders, positions and trades
- Last n trades and last n orders on a market
- Vega network statistics
- Advanced: Log in to wallet and place an order on a market
- Advanced: Candle data / charts
- Advanced: Liquidity provision (LP) data
  * for each of these it'd be fun to give guidance on how to obtain the data - chat with us on Discord, Forums, Github or Email and to be rewarded with a bounty significant functionality, as agreed acceptable by the Vega team must be implemented. This is a fun task to tackle! :)
Code should be open sourced under the MIT license.

Familiarity with Vega

We're an exciting blockchain project with a recently launched public testnet, we're adding new features all the time therefore we'd love anyone interested in completing our bounties to get to know our platform first. We feel it is very important for you test out the platform, check out our documentation and understand the way the protocol works to complete our bounties to a high standard. We're friendly, open and helpful, so don't be afraid to ask questions.

How to apply and progress

bountyflow

How to Submit

Publish your submission into a public Github repo with clear and informative README describing how to use it. The submission should include an example spreadsheet - working against the Vega Testnet.

Bounty reward

For this bounty, we will provide a bounty reward of up to 701 DAI, by working on the bounty you understand and accept that this is the reward total.

Due to the interest in working on this it is now a competition/contest style bounty, so we're looking for the best solution ideally creating a 'cryptosheets' like experience in excel/google sheets but connected to Vega.

Finally, please check with us to ensure the solution is acceptable as you develop an entry.

Resources for Developers

Questions & Reviews

You can reach out to us for any queries on our Discord Chat or post your questions in our Community Forums

We're a friendly team and are very keen to help where possible.

Keep Calm and Buidl On!

gitcoinbot commented 3 years ago

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

This issue now has a funding of 701.0 DAI (701.0 USD @ $1.0/DAI) attached to it as part of the vegaprotocol fund.

If you would like to work on this issue you can 'start work' on the Gitcoin Issue Details page.
- Want to chip in? Add your own contribution here.
- Questions? Checkout Gitcoin Help or the Gitcoin's Discord
- $2,208,372.86 more funded OSS Work available on the Gitcoin Issue Explorer

gitcoinbot commented 3 years ago

Issue Status: 1. Open 2. Cancelled

Workers have applied to start work.

These users each claimed they can complete the work by 265 years, 4 months from now. Please review their action plans below:

1) andreygrin has applied to start work _(Funders only: approve worker | reject worker)_.

Hey, I mastered lot of connection to different APIs and also build API on my own. I would like to test a Google Spreadsheet connection to your platform. Also, I'm always interested in crypto platforms so will definitely read your documentation to get know you better. 2) ekawut has applied to start work _(Funders only: approve worker | reject worker)_.

ฉันอยากได้โบนัสโดยการสำรวจตามที่ระบบแนะนำ 3) universalmind303 has applied to start work _(Funders only: approve worker | reject worker)_.

Who Am I: I am a senior Data Engineer - https://www.linkedin.com/in/cory-grinstead My Action Plan

Identify source data, and familiarize self with vega stack
Spike on best connector to use (or best way to build a connector)
Identify data transformation steps needed for simplest view
Implement MVP of getting end to end feature of data coming from node into a spreadsheet
- Identify best data loading technique (batch, micro-batch, or real-time)
Develop additional views.
Identify roadmap for additional features. 4) ervindimitri has applied to start work _(Funders only: approve worker | reject worker)_.

Hello I will study the structure of Vega API and then make the connection between Vega Testnet API data and Google sheets 5) davorblaz has applied to start work _(Funders only: approve worker | reject worker)_.

Interested, have a lot of experience in excel. Let me know if i can help. 6) ralphilius has applied to start work _(Funders only: approve worker | reject worker)_.

I'm a Google Sheets addicts and I love building stuffs around it. I have experience working with crypto APIs to load data into Google Sheets.

https://github.com/ralphilius/CryptoGAS 7) suslimbaugh has applied to start work _(Funders only: approve worker | reject worker)_.

Hello, I have much experience using Excel, VBA for excel automation and other similar tools! I feel that I would be a great fit for this project considering my combined background in finance and computer science. I have a good understanding of crypto, as well as traditional financial markets and feel that I could do great work on this project. Please get back to me! 8) boodovskiy has applied to start work _(Funders only: approve worker | reject worker)_.

Hi! I am interested in participating in this task.

I would like to output the following data in Excel: Party (for a public key) data, including orders, positions and trades Last n trades and last n orders on a market 9) zmf-666 has applied to start work _(Funders only: approve worker | reject worker)_.

hi, I am very interested in this project and this question! 10) yinimanila has applied to start work _(Funders only: approve worker | reject worker)_.

I want to do all the round to do the incentivised testnet

Learn more on the Gitcoin Issue Details page.

dinhnq commented 3 years ago

8) I would like to apply for the related-Google Sheet tasks because I see Vega Protocol very promising and it is truly worth to spend time contributing Vega's community. I'm working on many kinds of programming languages and love to join the crypto world.

brodik1509 commented 3 years ago

I am very interested in this project

dong446 commented 3 years ago

I am very interested in this project

gitcoinbot commented 3 years ago

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

The funding of 701.0 DAI (701.0 USD @ $1.0/DAI) attached to this issue has been cancelled by the bounty submitter

Questions? Checkout Gitcoin Help or the Gitcoin's Discord
$1,976,590.07 more funded OSS Work available on the Gitcoin Issue Explorer

vegaprotocol / bounties