02-25-2021, 06:06 AM
Dollar Cost Average (DCA) spreadsheet to help with research (mostly for newbies)
<!-- SC_OFF --><div class="md"><p>I was replying to a comment on another thread about DCA (Dollar Cost Averaging). With the influx of people new to crypto or perhaps even trading for that matter, I decided to share here my perspective. I often use a spreadsheet to mess around with various prices to see various scenarios (DCA, profit/loss, etc.)</p> <p>Each coin I put in it's own tab. This allows me to play around with whatever I've purchased to see if I were to buy in at another price how that would affect my DCA and/or profitability. I try to enter previous transactions as close I can but not so detailed that I need to have 100's of rows. Once I've have past trades (and average costs) calculated. This allows me to enter the current price at bottom of spreadsheet (or using the live price from googlefinance function) and then enter the number of coins I want (or tweak the line to allow me to enter how much I want to spend) and see how it changes my DCA, profit/loss, etc.</p> <p>Then as my first tab I have as a Summary. This pulls in the COUNT and COST for each of the individual tabs and then allows me to mess around with the current price to see how some scenarios may play out. I don't use this one that much honestly. Usually used merely as porn to make me fantasize how rich I could be if something goes crazy. </p> <p>Feel free to check out a sample spreadsheet with some notes and examples on it:</p> <p><a href="https://docs.google.com/spreadsheets/d/1MhbD3xDpv3dV8MTWCk0c8v5KkHdzTciFYK8qUMKsv2o/edit">https://docs.google.com/spreadsheets/d/1MhbD3xDpv3dV8MTWCk0c8v5KkHdzTciFYK8qUMKsv2o/edit</a></p> <p>NOTE: I tried to use the google function on some to pull in live prices but others are not available so require you to enter them (or a value you are wanting to see profit/loss for, etc.)</p> <p>I assume I'm not alone in using something like this?</p> </div><!-- SC_ON --> submitted by <a href="https://www.reddit.com/user/FrontHandNerd"> /u/FrontHandNerd </a> <br/> <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/lrpqmk/dollar_cost_average_dca_spreadsheet_to_help_with/">[link]</a></span> <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/lrpqmk/dollar_cost_average_dca_spreadsheet_to_help_with/">[comments]</a></span>Kind Regards R
<!-- SC_OFF --><div class="md"><p>I was replying to a comment on another thread about DCA (Dollar Cost Averaging). With the influx of people new to crypto or perhaps even trading for that matter, I decided to share here my perspective. I often use a spreadsheet to mess around with various prices to see various scenarios (DCA, profit/loss, etc.)</p> <p>Each coin I put in it's own tab. This allows me to play around with whatever I've purchased to see if I were to buy in at another price how that would affect my DCA and/or profitability. I try to enter previous transactions as close I can but not so detailed that I need to have 100's of rows. Once I've have past trades (and average costs) calculated. This allows me to enter the current price at bottom of spreadsheet (or using the live price from googlefinance function) and then enter the number of coins I want (or tweak the line to allow me to enter how much I want to spend) and see how it changes my DCA, profit/loss, etc.</p> <p>Then as my first tab I have as a Summary. This pulls in the COUNT and COST for each of the individual tabs and then allows me to mess around with the current price to see how some scenarios may play out. I don't use this one that much honestly. Usually used merely as porn to make me fantasize how rich I could be if something goes crazy. </p> <p>Feel free to check out a sample spreadsheet with some notes and examples on it:</p> <p><a href="https://docs.google.com/spreadsheets/d/1MhbD3xDpv3dV8MTWCk0c8v5KkHdzTciFYK8qUMKsv2o/edit">https://docs.google.com/spreadsheets/d/1MhbD3xDpv3dV8MTWCk0c8v5KkHdzTciFYK8qUMKsv2o/edit</a></p> <p>NOTE: I tried to use the google function on some to pull in live prices but others are not available so require you to enter them (or a value you are wanting to see profit/loss for, etc.)</p> <p>I assume I'm not alone in using something like this?</p> </div><!-- SC_ON --> submitted by <a href="https://www.reddit.com/user/FrontHandNerd"> /u/FrontHandNerd </a> <br/> <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/lrpqmk/dollar_cost_average_dca_spreadsheet_to_help_with/">[link]</a></span> <span><a href="https://www.reddit.com/r/CryptoCurrency/comments/lrpqmk/dollar_cost_average_dca_spreadsheet_to_help_with/">[comments]</a></span>Kind Regards R