I have my own spreadsheet with how much I invested in each coin, how many I hold, and the current sell value. Once in a while I want to batch update the "sell value" column and let the sheet do its magic and give the total value of my portfolio.
I used to do this manually for each coin, but quickly the process became painful. Almost as painful as realizing how much money I lost with cryptos... I needed a faster way to copy-paste to all rows the latest price of each coin.
Before
- Go to CoinMarketCap and search for my coin
- Copy the coin price
- Select the respective cell in the spreadsheet
- Paste the price (without formatting)
- Repeat this 27 times π°
Today
- Call spotlight (
β+Space
), type fetcher andEnter
- Wait 5 secs, while script reads a config file, calls an API x 27 times, and writes to a file
- Copy all values (
β+A
,β+C
,β+Q
) - Select all rows and paste (
β+V
) π π
- π Ruby version (2017)
- cd
ruby
- Execute
run-bigbang.sh
to install everything required to run the app. - Execute
run-fetcher.sh
orrake
to fetch the prices.
- cd
- π Python version (2020, now with unit tests!)
- cd
python
- Execute
run-bigbang.sh
to install everything required to run the app. - Execute
run-fetcher.sh
orinvoke app
to fetch the prices.
- cd