Bitcoin spreadsheet reddit Note: if you want to dig into the full dataset, you can find the entire spreadsheet of all 250,000+ weekly DCA outcomes in Bitcoin's history here. Adding 0. Visit the github page for support and updates. This sub (r/cashapp) is for discussions regarding Cash App. I made a spreadsheet that helps you track your net gain for each transaction and your total net gain. Hi all, I need a Crypto Portfolio Tracker to enable me compare my bought price vs current price to help determine when to sell please. I'm not sure the ROI is working correctly here, at least not for incremental investments. ) The table named Bitcoin Price (2014-2023) contains data on Bitcoin's open, high, low, close, adjusted close prices, volume, and dates, spanning 10 years with 3228 rows and 8 columns, making it a valuable resource for analyzing Bitcoin's historical price trends and volatility. I buy $1 worth of bitcoin per day and have a spreadsheet to keep track of how much I've invested, how much in BTC I have, and how much it is worth in USD. All Bitcoin News. Bitcoin Model is an open-source model designed to simulate long-range outcomes of various Bitcoin strategies tailored for individuals, corporations, institutions, and nation-states. The Workbook has the following features: Sep 28, 2025 · Learn how to create a crypto portfolio spreadsheet tracker in Excel that tracks live & historical crypto prices, or download our free template! About Bitcoin Model is an open-source model designed to simulate long-range outcomes of various Bitcoin strategies tailored for individuals, corporations, institutions, and nation-states. It offers peer-to-peer money transfer, bitcoin and stock exchange, bitcoin on-chain and lightning wallet, personalised debit card, savings account, short term lending and other services. Bitcoin Transaction Tracker (Spreadsheet) I've seen a few posts about people wanting to track their purchases along with other metrics such as cost basis, etc so I've built this google sheets document to help you out! In this guide, we’ll break down everything you need to know to create a crypto tracker for Excel and Google Sheets. This guide will walk you through several methods to get BTC prices in Google Sheets, from the We would like to show you a description here but the site won’t allow us. Due to a high number of requests, I've updated my crypto tracking spreadsheet to now support the top 5000 crypto (moons included). I often use a spreadsheet to mess around with various prices to see various scenarios (DCA, profit/loss, etc. This is the utility script used in the Cryptocurrency Financial Spreadsheet - link. I was replying to a comment on another thread about DCA (Dollar Cost Averaging). Can you track cryptocurrency on Excel? Yes. I made a Bitcoin accounting template in Excel to share This is the spreadsheet I use to track my transactions. For those not familiar with using scripts in a Google Spreadsheet, simply open your spreadsheet and go to Tools -> Script Editor. Bitcoin Transaction Tracker (Spreadsheet) I've seen a few posts about people wanting to track their purchases along with other metrics such as cost basis, etc so I've built this google sheets document to help you out! We would like to show you a description here but the site won’t allow us. uses a google apps library i submitted to the gallery called "Bitcoin Utilities" that makes it easier to get data direct from exchanges. I unfortunately had about $2500 worth of coins on the platform on the date they filed for bankruptcy (and had JUST moved my Bitcoin there a week or two prior - just my luck). [Excel] I made a Cryptocurrency tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance. Mark Moss "The ONLY Bitcoin Retirement Strategy You Need. Industry leaders, exchanges, block explorers, analytics services, defi networks & more. 5 BTC in prizes (over $1,500) WILL be paid out. I made a Bitcoin tracking spreadsheet with live crypto price updates, moon math, and a history of your Portfolio and trading performance. Updated Version (13) - now supports 1000 cryptocurrencies. Rather than a long text explainer, please see the video. How do you all keep track of all your trades for tax purposes? I’m planning on using pancakeswap to trade, along with coinbase… Feb 20, 2025 · Learn how to get Bitcoin prices in Google Sheets with simple to advanced methods. With Bitcoin, you can be your own bank. Taking the 20 pip challenge but with my own spin, update after a week I was using Blockfolio until FTX went under. So my main take away from the last bull run is you go into the bull market not knowing what is going on and you will assume you will figure out the top and sell perfectly. The easiest way to use it is to make a copy of the spreadsheet above. I've recently been developing my own BTC transactions tracker using Google Sheets that I'd like to share with anyone interested. This does not happen even and you will get burnt. trueHey there fellow Bitcoin enthusiasts. So that I can put in how much I bought them for sold them so i can see what my profit/loss and for record keeping. I just have to imput the purchase price and the bitcoin amount. I will try to list every essential detail, from its perks and uses to the templates you can use. Please check it out and give me some feedback. 5. This guide will walk you through several methods to get BTC prices in Google Sheets, from the Bitcoin is the currency of the Internet: a distributed, worldwide, decentralized digital money. Bitcoin is the currency of the Internet: a distributed, worldwide, decentralized digital money. Sep 28, 2025 · Learn how to create a crypto portfolio spreadsheet tracker in Excel that tracks live & historical crypto prices, or download our free template! 4 days ago · In this article, I will discuss everything you need to know on how to track your crypto portfolio with Google Sheets. But if you look at the bottom line, adding 1 GPU from 49 to 50 delays the ROI by 0. This is a spreadsheet that I have developed for myself gradually over the last couple years. BitcoinAll. With the influx of people new to crypto or perhaps even trading for that matter, I decided to share here my perspective. Cryptoprices version 14 : r/CryptoCurrency Gaming Sports Business Crypto Television Celebrity Go to CryptoCurrency r/CryptoCurrency r/CryptoCurrency This is a bitcoin arbitrage table i made using google spreadsheets. updates once a minute. The automatic calculations and charts make it very user-friendly. 22 days at 81k per hour is only ~486k, 1/4 of the cost of that 50th GPU. Unlike… Does anyone knows how to get the current ATH into a google spreadsheet without using an api? (cryptofinance doesn't work for me). Straight up there is some self promo here (my video is at the bottom) but you can get everything you need in We would like to show you a description here but the site won’t allow us. Hey guys, I have started trading and I wanna make a spreadsheet to track my trades, I tried to find some templates for tracking trading. Archived post. It also keeps track of how much you had paid for each bitcoin. " - Free money? Mark Moss demonstrate a way to perpetually borrow (and repay) fiat money with BTC colateral. Bitcoin spreadsheet Was wondering if anyone has a google docs spreadsheet example that has all the formulas and prices on it where you can put in when you bought and for how much/sold etc. Updated Version (13) 4 days ago · Here are two free Crypto Portfolio Tracker Google Sheets Templates you can download and use yourself for tracking all your crypto assets quickly and easily. Right now in 2023 there is $22,500,000 of daily demand for newly mined bitcoin at these price levels ($25,000 × 900 coins = $22,500,000). Jul 22, 2025 · Looking for a simple method to manage your crypto investments? In this guide, we’ll delve into the process of creating an Excel crypto tracker in 2025. All Bitcoin discussion. Create a new script if it prompts you and cut and paste the code below. : r/Bitcoin r/Bitcoin • by johnprescott2000 View community ranking Posted by u/Mississippi-joe - 2 votes and 1 comment Get cryptocurrency prices directly in your spreadsheets. If you're only building the farm to leave it on for bitcoins and not doing crafts everywhere else, then it will never be worth it. where's the guy with the spreadsheet showing every major move since the beginning. I'm in search of someone skilled in Excel& Crypto sheets to assist in creating a spreadsheet that tracks real-time Bitcoin prices, network difficulty/hash rate, and estimated mining rewards based on hash rate. Bitcoin Bet Tracking Spreadsheet I made a Google Spreadsheet template for tracking bitcoin betting and I figured maybe others would get some use out of it as well. I did and i'm sure that many of you will have had similar experiences. Cryptosheets has been used by over 155,856+ people across Excel and Googlesheets. Feb 20, 2025 · Learn how to get Bitcoin prices in Google Sheets with simple to advanced methods. Bitcoin Wallet Spreadsheet I created this wallet spreadsheet to aid in keeping track of various wallets, to calculate my exposure to exchanges and to check the values in my cold storage wallets. Whether you're managing a personal portfolio, tracking market trends for business, or just satisfying your curiosity, pulling live data automatically saves immense time and effort. Could start working on my own sheet, but just curious if anyone here has a template they really like that's worked for them that others (myself included) could utilize! Hi there, I'm new in Excel. We update our BTC to USD price in real-time. 8M subscribers in the Bitcoin community. You can also track your investment decisions with the portfolio tracker - like an income statement. I only make about $40,000 a year so I can't afford to make mistakes. Updated Version (12) : r/CryptoCurrency Gaming Sports Business Crypto Television Celebrity Go to CryptoCurrency r/CryptoCurrency r/CryptoCurrency Bitcoin is the currency of the Internet: a distributed, worldwide, decentralized digital money. Wanted to share my google spreadsheet with the reddit community. Updated Version (13) So my main take away from the last bull run is you go into the bull market not knowing what is going on and you will assume you will figure out the top and sell perfectly. Knowing Microsoft products, is there a chance that even when the veracrypt file is unmounted, that file is still accessible? Archived post. I have all the data please help me. It allows you to enter your initial price paid for your coins and the amount bought and uses that as a basis for your W/L in USD. Whenever rates come up I see people talking about Newton. This spreadsheet tracks your crypto and keeps a record of your gains, losses and historical positions. I need a free spreadsheet either Excel or Google that has live tracking of prices and compares to my transactions, seperating fees etc please. You can also add Any recommendations for a Google docs or Excel spreadsheet template that can track Bitcoin transactions, including tax basis? My experience with CoinTracker sucks, and though Koinly seems a bit better, I think I’m better off just taking control of the record keeping on a spreadsheet. Newton is definitely the cheapest in terms of spread (aside from Bitcoin Well) but they pass the mining fee the users to withdraw (anything over $5) which right now is a huge charge. Of course I stripped out my personal info. Excel sheet to pull live BTC price based on Date&Time cell : r/Bitcoin r/Bitcoin Current search is within r/Bitcoin Remove r/Bitcoin filter and expand search to all of Reddit Hey everyone! I'm looking for examples of stock + crypto portfolio trackers in Google Sheets. Based on the AMA with the Tax Attorney here on r/bitcoin a while back, I've determined that the best way to consider Bitcoin for taxation purposes is treating it as an ordinary asset with FIFO method. All the time. Can anyone help me out with the Leverage trading portfolio template? 5. They have too many zeros and it's affecting other calculations. I will also provide a step-by-step guide showing you how to create a crypto tracking spreadsheet on your own. It automatically gives you the current price for your coins based on the exchange of your choice. In this guide, we walk through how to setup your crypto tracker. BAT and RDD work but seem to have issues. Quick background on me: I've been a lurker of several different crypto related subs for a few years now, and only got around to making this account a little while ago. But I've also exchanged a few thousand dollars worth of crypto for other tokens via UniSwap (which is a taxable event). Which spreadsheet is available for free and which I can find guides to add live updates? Is there such a thing or I have to pay? To start with, is there a way to add my trades from Binance and Kraken to a spreadsheet easily? ie not manually? Then add, live Bitcoin spreadsheet Was wondering if anyone has a google docs spreadsheet example that has all the formulas and prices on it where you can put in when you bought and for how much/sold etc. Users can input their own assumptions, making it a model that everyone can use. Unlike traditional currencies such as dollars, bitcoins are issued and managed without any central authority whatsoever: there is no government, company, or bank in charge of Bitcoin. I know there are services like CoinGecko that allow tracking positions, but I want to use Google Sheets for maximum customization. The official bitcoin mining forum / subreddit / chat room / place to be! I'm wondering if he's still on track. Curious if anyone here has a good spreadsheet they’d be willing to share that they use for tracking all their bitcoin purchases, price, quantities, averages, fees, etc. Anybody know of a good tutorial that they could share? Excel Spreadsheet for Investment Forecasting and Portfolio Tracking Hey guys, I made an excel spreadsheet that will help simplify the decision to invest what, in which cryptocurrencies, and when. Well then, now that we have a nice connection to either the CoinMarketCap API or the CoinGecko API, it is time to start building a simple portfolio tracker in Excel. The live Bitcoin price today is $86,101. 6 days ago · For private investors looking to manage their cryptocurrency holdings with minimal hassle, tracking your portfolio in Google Sheets is an excellent option. Simple way of getting Crypto Prices in Google Sheets? : r/sheets r/sheets Current search is within r/sheets Remove r/sheets filter and expand search to all of Reddit Bitcoin is the currency of the Internet: a distributed, worldwide, decentralized digital money. Tracking a crypto portfolio through excel can be a great way to stay on top of market movements. It's also important for me to include stock data in my portfolio. Maybe they are other real currencies? In spreadsheets use cell calculation: =GoogleFinance ("CURRENCY:XMRUSD") Substituting the desired crypto ticker [Edits for typos and adding tickers] Archived post. Cryptocurrency Spreadshseet Utils This page is provided for posterity. trueLooking to make a comprehensive budget to start tracking my spending and saving. We would like to show you a description here but the site won’t allow us. Now I don't post here often, but I like sharing stuff that can actually have weight over here when I do. Cash App is a financial services application available in the US. The goal is to correlate this data with my estimated mining rewards, watts used per miner, and ultimately calculate ROI and the bottom line. . For those of you using a Google Spreadsheet to keep track of your Bitcoin, I figured out how to get live exchange data in the sheet! Bitcoin is the currency of the Internet: a distributed, worldwide, decentralized digital money. Excel VBA is not the best language for wallet processing, but the ease of spreadsheets will drive innovation for better UI. Bitcoin Spreadsheet Contest. current value is considerably higher, but they just finished their court proceedings and apparently I'll be getting about 70% of my holdings back (based on the $2500 [Excel] I made a Cryptocurrency tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance. But be warnedthe spreadsheet is massive and might bring your computer to a crawl! Image 1: all weekly DCA scenarios in Bitcoin's history Image 2: Longest unprofitable weekly DCA in Bitcoin's history It's not about bitcoin, it's about the fact CoinGecko is throttling the API since it's free and Google makes a lot of requests since it is the source for all the Sheets that use their API. I've discovered a flaw in my original logic, as I might want to sell some of this. There are so many ways to exit the market, here is just one idea I had that makes sense to me. 12 votes, 55 comments. This will alleviate any real time snooping of your keystrokes, but if there is a keylogger already installed on your PC then you are SOL. I figured it could be of use to others in r/Bitcoin so I've decided to share it! To use it, just edit your hash rate, the exchange rate and the network hash rate to the current values, then put in an optional estimated weekly network hash rate increase number if you want to see how an increase in nethash will impact your earnings. Does anyone have a spreadsheet template for taxes I can use? I HODL most of my crypto (which is not a taxable event). I used to do something like that spreadsheet, but not I use the Coin Ticker app for iOS and it saves me time. Thanks in advance. He should have put a disclaimer in the post, but airwing takes the cost of the fuel from his constant crafting, so the bitcoin farm is "free". Blog page contains MD5 and SHA1 checksums for the spreadsheet to download. Explore an extensive and diverse collection of datasets including native provider APIs and custom mashups. I couldn't find anything that showed what you needed to work towards the bitcoin farm easily so I decided to make a quick colour coded spreadsheet so here you go anyone else looking for the same thing I was: A made a crypto tracking spreadsheet with live crypto price updates, moon math, and a history of your Portfolio and trading performance. Lets do the same equation for this upcoming 2024 halving at todays price. Free API for Google Sheets and Excel with Bitcoin, Ethereum, Solana and other major cryptocurrencies. Mods are active, so please make sure to read the rules before posting. Please I made a crypto tracking spreadsheet with live crypto price updates, moon math, and a history of your Portfolio and trading performance. Hey guys, I was just wondering if bitcoin / bitcoin cash, is just a big spreadsheet? I've heard this term being bandied around 'blockchain is just a large relational database / sql database/ excel spreadsheet' and offers no business value. Since I could not find anything that suited my needs, I decided to make a spreadsheet to do just that! The link to the spreadsheet is here: Google Sheets - Cryptocurrency Transaction Tracker An example spreadsheet (filled out) is here: Google Sheets - SAMPLE Cryptocurrency Transaction Tracker 45 votes, 12 comments. I have found it very helpful for keeping track of my bitcoin holdings (great for tax purposes). I'm obviously bias towards Bitcoin Well and wouldn't mind someone fact checking this to May 27, 2025 · Create your crypto portfolio tracker in Excel with live prices and performance data, and finally stay on top of your investments. Hi there, I'm new in Excel. Are Excel Spreadsheets a safe place to keep passwords? I have all my passwords in an AES encrypted veracrypt vault saved in an excel spreadsheet. Dear community, My name is Pasoon and I would like to share with you a google spreadsheet tracker for both cryptocurrencies and stocks. Unlike… 11K subscribers in the BitcoinAll community. I wrote this simple script to keep track of the current value (in USD) of the bitcoin holdings on my monthly budget spreadsheet. I made bitcoin tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance (Updated). It was a big undertaking to switch to an excel spreadsheet, but that’s what I did despite there being no way to export the 1000’s of transactions I had entered manually and with API connections. I've tried creating one myself but ran into issues with importing data for DeFi tokens and some less This spreadsheet is exactly what many of us have been looking for to track our Bitcoin purchases effectively. That's it really. Feb 20, 2025 · Tracking Bitcoin's price directly in Google Sheets transforms a simple spreadsheet into a dynamic crypto monitoring tool. 98 USD. I need your help to make a table that shows bitcoin's average return in a specific day of the year. Made various calculations and bought a testing card and have a few upcoming Projects, such as the Stealth Mining Project. In Column Q I also give text instructions on how each type of transaction should be entered. The math around the bitcoin farm is as subjective as it is objective. A google spreadsheet tracker for cryptocurrency & stocks with cool features such as newsfeed, screener and other tools! Is there a spreadsheet with information on the exchanges like this one for the cards (… I’m looking for a solid tutorial to create an excel spreadsheet that automatically computes crypto gains and losses with the LIFO method (using imported buy and sale data). New comments cannot be posted and votes cannot be cast. This link contains a shared zip file with a macro enabled Excel workbook hosted on Google Docs. Is there a spreadsheet with information on the exchanges like this one for the cards (… Bitcoin Bet Tracking Spreadsheet I made a Google Spreadsheet template for tracking bitcoin betting and I figured maybe others would get some use out of it as well. Useful cryptocurrency tools (like getting the current price, of Bitcoin, Ethereum) for Google Spreadsheets. How to get all live crypto rates in Google Sheets or Excel to create a portfolio tracker. First, a… 93K subscribers in the BitcoinMining community. Never before in bitcoins history has a halving left this much demand (in dollar terms) without any new bitcoin to buy. The demo sheet includes fake buy/sell transactions using BTC historical prices directly from Google Finance. Track live data, analyze trends, and manage your crypto portfolio easily. I wanted to share a portfolio tracker I've built over the past couple of years. 33 USD with a 24-hour trading volume of $42,753,962,837. I just started getting active with bitcoins a couple of days ago. This tracker allows you to check: Your all-time buy/sell performance (realized vs realized gains, portfolio cost vs current value) Your buy/sell performance Bitcoin is the currency of the Internet: a distributed, worldwide, decentralized digital money. thanks. For example, I want to calculate bitcoin's average return on Mondays in 2013. This spreadsheet calculates the basis and short-term/long-term gain/loss for each transaction of sent coins. You can see USD, EUR and CNY based exchanges at one glance whereby all prices are converted to USD : r/Bitcoin [Store] Ukrainian prices | Accepting Keys, BTC (Bitcoins) | Spreadsheet | Ask me prices (The Elder Scrolls Online: Imperial Edition Upgrade — 7 keys, Ryse: Son of Rome - 10 keys) Bitcoin is the currency of the Internet: a distributed, worldwide, decentralized digital money. This is totally free and works for any local currency like USD, EUR, AUD, etc We would like to show you a description here but the site won’t allow us. To not make the post too long, I will try to keep this guide quite basic and mainly suitable for the hold-strategy. DOGE and LINK are on the Google Finance Crypto tab but do not seem to work in the spreadsheet format. The most popular and trusted Bitcoin block explorer and crypto transaction search engine. I but the values of the Bitcoin and Etherium Crypto Currencies are wrong. Any suggestions appreciated. The Instructions tab gives a bunch of examples on how to use it. I understand how you made it, total cost of GPUs divided by hourly earning rate. My biggest recommendation is don’t get stuck using a services that doesn’t allow you to export to Excel spreadsheet Anyone has a good excel spreadsheet to keep track of my bitcoins? Bitcoin is the currency of the Internet: a distributed, worldwide, decentralized digital money. The most secure way to use the Cold Code method is to follow the instructions that come with the product, but if you elect to use my spreadsheet, I recommend after downloading that you disconnect your PC from the internet and enter your data in the spreadsheet. 22 days. Are you ready to combine the inflation resistance of bitcoin with the tax advantages of an IRA? The retirement calculator is your starting point. As such, it is more resistant to wild inflation and corrupt banks. I wanted to compare them and a few other platforms to Bitcoin Well. WHAT math you use depends entirely on your play style, lifestyle, and simply how much time you spend in game. I got into crypto late 2017 and it's become a passion/hobby of mine, something about it just sucks you We would like to show you a description here but the site won’t allow us. rcaof eyt djcz ezamiu cfqbjrg dyqhddj ysm cwlmjujs xbjnk mjt lpvq nam zisc ccg rxhix