Bitcoin Forum
September 22, 2025, 10:26:02 PM *
News: Latest Bitcoin Core release: 29.0 [Torrent]
 
  Home Help Search Login Register More  
  Show Posts
Pages: [1]
1  Alternate cryptocurrencies / Announcements (Altcoins) / Re: [ANN] Introducing Cryptosheets: Real-time Excel Add-in for Cryptocurrencies on: August 03, 2018, 03:16:18 PM
The idea is interesting.
But those who believe in you are crazy  Lips sealed

Interesting statement, why do you say that?
2  Alternate cryptocurrencies / Announcements (Altcoins) / [ANN] Introducing Cryptosheets: Real-time Excel Add-in for Cryptocurrencies on: August 03, 2018, 02:36:54 PM
After many months of hard work, failures, firings, and question marks, I’m excited to finally announce Cryptosheets! 👌


https://appsource.microsoft.com/en-us/product/office/WA104381695?src=bitcointalk&tab=Overview

  • Pulls real-time quotes, OHLCV, and trades from over 95+ different exchanges, 3,000+ assets and 11,000+ symbols
  • Pulls the entire 1,700+ cryptocurrency library of CoinMarketCap
  • Up to 5 years worth of Open/High/Low/Close/Volume (OHLCV) data from Cryptocompare

Why does this matter? ❓
We have an entire generation of brilliant financial analysts, traders, investors, portfolio managers (the list goes on and on) who live and die within Excel.

These talented individuals are wizards in Excel from many years of use, but will never learn how to code.

Cryptosheets use cases:

  • Backtesting trading strategies
  • Portfolio valuation and optimization
  • Risk management
  • Research and analysis
  • Third-party integrations
  • Technical analysis
  • Much, much more

Cryptocurrencies are a new asset class. A mountain of knowledge from trading and investing is immediately portable over to digital assets. Cryptosheets aims to ease this transition of knowledge.

The solution: A smarter, faster add-in built specifically for cryptocurrencies
We want to save thousands of hours of Copy->Paste->Spot Check->Pray. A few simple clicks through our interface and you will get whatever data your heart desires. ❤️

Initially we will connect CoinMarketCap, Cryptocompare, and CoinAPI. A large portion of our development resources will be spent integrating the data providers that our users request. 💨

Now ready for your feedback 🎧
Cryptosheets is live on Microsoft Appsource and during phase 1 we will be working relentlessly on speed, efficiency, reliability, and enhancements…all of which your feedback is absolutely critical.

Please do not hesitate to report any bugs you found, or give us any feature requests that you want to see implemented. Feature requests are voted on by users and built based on demand.

How to Install
Follow the steps below for your version of Excel and operating system.

Excel 2016 for Windows

Please install the Cryptosheets add-in for Excel, using the following instructions:

Open Microsoft Excel 2016.
Select Blank Workbook.
Go to Insert > My Add-ins.
In the popup window, choose Store.
Type Cryptosheets in the search box.
Choose Cryptosheets.
Take a moment to look at the Store page to familiarize yourself with the add-in.
Choose Add to install the add-in.

Excel for Mac
Open Excel for Mac
Select Blank Workbook.
Go to Insert > Store.
Type Cryptosheets in the search box.
Choose Cryptosheets.
Take a moment to look at the Store page to familiarize yourself with the add-in.
Choose Add to install the add-in.

Excel Online
Head to https://office.live.com/start/Excel.aspx
Sign in to your Office 365 account
Select New Blank Workbook.
Go to Insert > Office Add-ins.
In the popup window, choose Store.
Type Cryptosheets in the search box.
Choose Cryptosheets.
Take a moment to look at the Store page to familiarize yourself with the add-in.
Choose Add to install the add-in.
3  Alternate cryptocurrencies / Speculation (Altcoins) / 7 Smart Ethereum Price Prediction Methods for HODL’ers on: October 24, 2017, 06:47:25 PM
It is incredibly difficult to predict where the price of Ethereum will go.

This is not a matter of talent, or how “smart” you are — I mean, shit, you have possibly made a good deal of money investing in Ethereum. But now you have additional money to invest, and are unsure if now is the best time to buy.

Even the best Ethereum traders/investors in the world are left dumbfounded about when to invest.

Luckily, Ethereum price prediction tools have emerged that are helping investors and analysts better predict where Ethereum prices are going to go.

Why is it so difficult to predict Ethereum prices?

Putting a value on a cryptocurrency is fundamentally different from a stock.

Stock valuations are typically heavily based around one big component: cash flow. The most well-known methods for valuing stocks: DCF, Graham Formula and EBIT Multiples are all based in some form or another on cash flow and profitability.

Cryptocurrencies do not have cash flow, and thus it becomes impossible to use the traditional methods of stock forecasting. What this means is we have to find alternative methods for pricing this amazing technology.

I have outlined 7 different ways we can come to an Ethereum price prediction to help out future investing.

1. Chris Burniske’s cryptoasset valuation, aka “I am very thoughtful in my analysis”

Chris Burniske of Placeholder capital and author of the book “Cryptoassets: The Innovative Investors Guide to Bitcoin and Beyond” recently released a very promising and thoughtful piece on Medium outlining a new way to value Cryptoassets.

The outline of the model is this:
Instead, valuing cryptoassets requires setting up models structurally similar to what a DCF would look like, with a projection for each year, but instead of revenues, margins and profits, the equation of exchange is used to derive each year’s current utility value (CUV). Then, since markets price assets based on future expectations, one must discount a future utility value back to the present to derive a rational market price for any given year.
Said a different way, the goal of the model is to derive the asset’s utility (for example, Filecoin’s utility is price per GB)and what that utility will look like in the future. Then, discount the utility value to what it would cost today.

The model does have a good amount of subjective inputs, so the price estimates I came up with varied significantly. I highly recommend heading over to the Medium piece and completing your own analysis.

Complexity: High

Confidence level: Promising

Time to finish: High

Price estimate: $603-$1,532

2. Cost of Production Model, aka “The cake is a lie

Initially created for Bitcoin, the cost of production model can be tailored for Ethereum. This analysis was completed by Adam Hayes in March 2015 at the New School for Social Research.The basis of the paper explains that pricing is not based on more traditional methods, but instead centered around the uniqueness of cryptocurrencies — mining statistics.

Directly from the paper:
Break-even points are modeled for market price, energy cost, efficiency and difficulty to produce. The cost of production price may represent a theoretical value around which market prices tend to gravitate.
The authors did state that certain factors such as future technology and utility may prove to be more valuable than the coin in and of itself. These factors could prove challenging for putting a true value on a cryptocurrency.

Complexity: Medium

Confidence level: Promising

Time to finish: High

Price estimate: $367

3. Economics of Price Formation, aka “I am most likely smarter than you”

The Economics of Price Formation method captures the relationship between BitCoin price and supply-demand fundamentals of BitCoin, global macro-financial indicators and BitCoin’s attractiveness for investors.

Written by Pavel Ciaian, Miroslava Rajcaniova, and d’Artis Kancs, the bones of the analysis focuses on vector autoregression (VAR) which I am definitely not covering here. However, the finding of the paper suggests that:
BitCoin market fundamentals have an important impact on BitCoin price, implying that, to a large extent, the formation of BitCoin price can be explained in a standard economic model of currency price formation.Tweet: BitCoin market fundamentals have an important impact on BitCoin price
Since the inputs used in the paper are the same, the findings can be carried over to Ethereum. Also of note, is that one of the main inputs of the 1st method, velocity, is also used in this paper.

Complexity: Extremely High

Confidence level: Hard-to-tell

Time to finish: High

Price estimate: Incomplete

4. Compound Annual Growth Rate (CAGR), aka “I work in Finance”

Borrowed from the financial world, CAGR seeks to estimate the size of an industry (or in this case, market cap of Ethereum) over a period of a few years.

The cryptocurrency world is expected to grow by 35%, based on CoinDesk data. Using this data, we can estimate what the market cap of Ethereum will be in five years. The required inputs are:

As of 10/23 — Current Market Cap ($27B, sourced from CoinMarketCap) — Available supply of coins (95M, sourced from CoinMarketCap) — CAGR (35%, from CoinDesk) — Coin inflation, or anticipated coins (1%, per Ethereum whitepaper)

In the picture below, we have forecasted the market cap and price of Ethereum out to 2022:

We have also provided a handy Google Sheets spreadsheet utilizing the Spreadstreet Google Sheets plugin to automatically bring in coin information for the calculation. You can find that sheet here:

Google Sheets link here

Complexity: Low

Confidence level: Low

Time to finish: Low

Price estimate: $412-$1,315

5. Max Market Cap, aka “Ethereum will grow to be bigger than Bitcoin”

Max market cap is a theoretical maximum that is calculated taking the market cap of the most popular coin (in this case Bitcoin) and plugging it in for a seperate cryptocurrency.

In the Ethereum example, the formula is very simply:

Available Coins (Ethereum) / Market Cap (Bitcoin)

This results in a max theoretical value of $1,038 for Ethereum, which as of 10/23 would be a 364% increase. This analysis gets really hilarious when you start using some of the less popular coins such as BAT (46,000% increase) and the useless Dogecoin (88,000% increase). Take with a grain of salt, but still very interesting to see.

Complexity: Low

Confidence level: Low

Time to finish: Low

Price estimate: $1,038

6. NVT Ratio, aka “I also sometimes engage in technical analysis”

NVT Ratio is another valuation methdology outlined by Chris Burniske, albeit at a much simpler calculation method.

The calculation is:

Network Value / Estimated Transaction Volume

Where I differ from Chris’ advice is I tailored the calculation to give me the value of Ethereum if it were to hit it’s max historical peak. For this example, the 30-day trailing average of transaction volume in the last year peaked on December 16th, 2016 at ~126. If we take the current daily transaction volume of ~$498M, this gives us a new market cap of $63B (126 * $498M).

Using this new market cap of $63B, if we divide that by the current supply of 95M, we get a new price of $664.

Once again, we have included this calculation in the Google Sheets found here:

Google Sheets link here

Complexity: Low

Confidence level: Low

Time to finish: Low

Price estimate: $1,012

7. Dartboard, aka “Go f**k your methods, I don’t need you”

Because, the dartboard method of Ethereum price prediction is honestly better than most of the crap out there. HODL. Tweet: “Because, the dartboard method of Ethereum price prediction is honestly better than most of the crap out there. HODL.”

Complexity: Extremely low

Confidence level: Higher than most

Time to finish: Extremely low

Price estimate: ]$9,000

How you can implement these methods with the valuation spreadsheet

The spreadsheet can be setup to update as often as you like by using the following instructions:

● Download the Spreadstreet Google Sheets add-in
● Click the Google Sheets link here. In the new window, click File — Make a copy.
● Important Open the template, click the menu Add-ons / Spreadstreet / Help / View in store, and then click Manage and in the dropdown menu click Use in this document.
● All formulas should update as expected. If not, try refreshing the sheet


The sheet includes CAGR, Max Market Cap, and NVT Ratio. The sheet does not include the cryptoasset valuation, cost of production model, or the economics of price foundation as those methods are significantly more involved. This sheet also does not include the dartboard method, as that requires a physical dartboard.

Good HODL’ers aren’t sprinters. They choose each and every investment with care. They know the rules. But they also know how to break the rules. Deliberately. Emphatically. Ruthlessly.

Original blog post can be found here: https://spreadstreet.io/blog/7-smart-ethereum-price-prediction-methods-hodlers/

John
4  Economy / Service Announcements / [ANN] An Easier Way to Connect Cryptocurrency Services to Spreadsheets on: October 18, 2017, 03:15:07 PM


TL;DR: I created an easier way for non-programmers to access their favorite Bitcoin and cryptocurrency services within Google Sheets. You can find it here:

https://chrome.google.com/webstore/detail/spreadstreet/fghpmppcbabgnpekploacbjijhppnkpp?authuser=0

Hey all,

I know some users of cryptocurrencies prefer to use spreadsheets (including myself) so I created a Google Sheets add-in that pulls certain API endpoints from popular Bitcoin and cryptocurrency services. I never had the time to develop software engineering skills, but the tool allows regular joes like myself to harness the power of APIs.
Requirements:

  • Google Sheets
  • Spreadstreet add-in (can download with the link above, or from within sheet)

Installing

Step 1: Download the Google Sheets add-in
Step 2: Open any Google Sheet
Step 3: In Google Sheets top toolbar, click the Add-ons tab. Open the Spreadstreet add-on and click “Open”.

Services and endpoints included:

Bitcoin Charts
  • Markets: Returns a table with elements from each market

Bitfinex
  • Ticker
  • Trades
  • Book
  • Candles

Bittrex
  • Markets: Used to get the open and available trading markets at bittrex along with other metadata.

Blockchain
  • Difficulty: A relative measure of how difficult it is to find a new block.

Stock Twits
  • Recent Symbol Messages: Return the most recent 30 messages for the symbol

GDAX
  • Products: Get a list of available currency pairs for trading
  • Historic Rates: Historic rates for a product. Rates are returned in grouped buckets based on requested granularity.

Cryptonator
  • Complete Ticker: Returns actual volume-weighted prices, total 24h volume, rate change as well as prices and volumes across all connected exchanges

Cryptocompare
  • Mining Contracts: Returns all the mining contracts.
  • Mining Equipment: Used to get all the mining equipment available on the website. It returns an array of mining equipment objects.

CoinMarketCap
  • Ticker: The ticker is a high level overview of the state of the market. It shows you the current best bid and ask, as well as the last trade price.

Hoping this is something that is useful to the group, and I am more than happy to help peeps setup the sheet so they can use it. Just send me a message on here or to my inbox.

Full disclosure

I have set the add-in to be a 14-day free trial, and $15 a month after. I am currently exploring ways to make the service free, such as:
Sponsored connections: Free connections that anybody can use where the service pays me to host them on the add-in
Community submitted connectors
Rate-limited free plan (currently do not have development talent to implement)
I am in no way affiliated with any of the services listed, except for the actual add-in itself. I just happen to find the services very valuable.

Helpful template to get you started

I created a sheet that has some initial instructions, as well as a setup for Bitfinex. It brings in candles data, and recent tweets related to the symbol of your choosing. You can find that sheet here (File -> Make a copy):

https://docs.google.com/spreadsheets/d/1P5WkVIk-e8jhVMS7TaptSKI83c1Ut5crLM1r8CUFUXc/copy#gid=0   

A note on security:

Our industry is rife with corruption. I know the hesitation involved with installing something that is script-based, like a Google Sheets add-in. I am here to help ease those fears with a couple of facts:

  • This is a U.S. based company, and I am a one-man show (for now)
  • My business location, phone number, and e-mail are all public knowledge as required by the laws of the United States
  • I am here to provide a valuable service, and something that I hope becomes a treasured tool within the space
  • The app is on the Google store, and they do a full review of all applications before allowing them to be pushed to the store. While not perfect, you can be reasonably assured they catch most malicious programs
  • If you are still hesitant, there are a couple of ways to test it without installing on your main computer, such as testing it in a virtual environment first.

Additional Resources

Help documents: https://spreadstreet.io/docs/

Using the built-in “SS” function: https://www.youtube.com/watch?v=gMqqEQ9ArDc

First time install and login: https://youtu.be/aLjtPR4T2bg
5  Economy / Trading Discussion / Re: Bitcoin & other coins to USD forecasts on: October 11, 2017, 06:22:23 PM
DatePairPrice (P)Move (P)Move% (P)Price (R)Move (R)
11.10.2017BTC/USD4712.654774-51
-1.06

11.10.2017
ARDR/USD0.2030034450.0000
0.00

11.10.2017ETH/USD300.33138291.870.6270129666
11.10.2017XRP/USD0.2619414310.001.45
11.10.2017LTC/USD50.752191050.17
0.34
11.10.2017XMR/USD86.26459678-0.20
-0.2260041869

11.10.2017DASH/USD289.3173569-1.61
-0.55

11.10.2017DCR/USD27.87393978-0.08
-0.2721295886

11.10.2017ZRX/USD0.221609988
0.02
8.47
11.10.2017STRAT/USD3.483807634
0.082.46

11.10.2017NEO/USD29.686073920.35
1.18

11.10.2017OMG/USD9.110533697
1.02
12.61475522

* Those are only prototype results, to show the possibilities of our tools. We don’t recommend to trade on it. We don’t take any responsibility for potential losses on your trading activities or other risks that you take by using those prototype results.
** Close price are aggregated for the market and are not tied to any exchange
Legend
date - day for which the close price is forcasted ( close price for current day calculated on 00:01 GMT of the next day)
pair - currency pairs for which forecast are generaited
Price (P) - predicted close price for "date", 1am GMT
Move (P) - the absolute difference between previous close price and the predicted one
Move% (P) - relative percentage difference between previous close price and the predicted one
Price (R) - real price for "date", 1am GMT
Move (R) - the absolute difference between previous close price and the real next one

Do you, or have plans to, have an API?
6  Economy / Service Announcements / Re: If you need data and work in Excel, check out Spreadstreet.io on: June 07, 2017, 05:44:38 PM
Thank you for your hard work, John. Spreadstreet.io is very helpful in managing the database i have.

Thanks, nmaryrai Smiley I very much appreciate it.
7  Economy / Service Announcements / If you need data and work in Excel, check out Spreadstreet.io on: June 07, 2017, 01:01:37 PM
https://spreadstreet.io

My name is John, and back in February of this year I started working on a website where Bitcoin traders and investors could go to get easy access to datasets and trading tools (such as technical analysis templates). This platform would require no coding knowledge, and would be tailored to folks who prefer to do analysis within spreadsheets such as Excel and Google Sheets.

Quick About Me

I am a former Fortune 500 financial analyst, where I managed two $3 billion portfolios. I've been investing/trading since 2002/2003. If you take a look at my kindle cloud reader, you will see over 100 books dedicated to trading and investing of all sorts - technical analysis, fundamental analysis, daily options trading strategies, value investing, volatility trading, quantitative trading, algorithmic trading, and bullshit trading.

I think Bitcoin and crypto is the future, and I believe that it is on an unstoppable path. My ultimate goal is to become a cost-leader in the field, and be tailored towards the individual investor. You shouldn't have to pay hundreds to thousands of dollars for top-notch tools.

Features at a Glance

  • Currently over 500+ datasets, and more being added every week (see below for full list)
  • Spreadsheet based trading templates (currently technical analysis, will expand to other areas in the future)
  • Aggregated RSS News feed
  • Messenger-like chat functions
  • Bitcoin calendar of upcoming events
  • Dropbox-like navigation (housed on Nextcloud)
  • Ability to sync directly with shared drives
  • Mobile and desktop apps

Databases currently included (updated daily)

  • Bitcoin Charts Exchange Rate Data
  • Bitcoin Charts Tick Data
  • Bitcoin Watch mining statistics
  • Bitfinex exchange rate data
  • Bitstamp USD/Bitcoin exchange rate
  • Blockchain
  • BNC Liquid Index (premium)
  • BNC Digital Currency Indexed EOD (premium)
  • BTC-e
  • BTER historical spread data
  • Global Digital Asset Exchange (GDAX)
  • Local Bitcoins

All datasets are available as a tab-delimited, CSV file. The datasets are a mix between raw tick data, OHLCV, spreads, mining and economic statistics. They can be used for backtesting, analysis, and charting.

Investing/Trading Templates


  • Williams %R
  • 12 and 26 day EMA
  • Relative Strength Index
  • Moving Average Convergence-Divergence
  • Average True Range
  • Many more to come as I find time to build them out

On The Horizon

  • Excel plugin to automatically bring data into a spreadsheet (really excited about this)
  • Google sheets add-in

Potential Ideas

  • Giving premium users a partial Bitcoin every month, based on sub price, almost like a savings/investing/trading vehicle

I'm open to answer questions or talk more about the project if there's interest. Hope it helps the traders and investors out there.

John
Pages: [1]
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!