Simple & Accurate "2 Clicks" Bitcoin Mining Calculator ...

A place for Indians to discuss and evaluate Investments

A place to discuss investments, insurance, finance, economy, and markets in India.
[link]

r/sportsbook: sports betting "discussion"

sports betting "discussion"
[link]

05-30 08:54 - 'Excel and Google Sheet Calculators to Track your Trading Profit with FIFO and LIFO methods' (self.Bitcoin) by /u/pksoni removed from /r/Bitcoin within 3047-3057min

'''
Spreadsheet is ready to calculate FIFO Profits up to 2000 transactions, which can easily be extended further by dragging the formulas as per your requirement.
You will just have to put Transaction Type (buy or sale), Date Transaction, Bitcoin Quantity and Price. Sheet will display important data for every row:
[Bitcoin Cryptocurrency FIFO Gain Excel Calculator]1
You can purchase this tool from Eloquens.com marketplace for USD $10 only. LIFO (Last in First Out) and Google Sheet versions are also available.
FIFO Profit Excel Calculator: [link]3
LIFO (Last In First Out) Profit Excel Calculator: [link]4
**You can purchase it for Bitcoin, Ethereum, Litecoin or other cryptocurrency from [link]5
Please let me know if you have any question or suggestion to improve this template.
[Bitcoin Cryptocurrency FIFO Gain Excel Calculator]2
'''
Excel and Google Sheet Calculators to Track your Trading Profit with FIFO and LIFO methods
Go1dfish undelete link
unreddit undelete link
Author: pksoni
1: r**d****om/*i*k/btwdml*vid**/wljbrh1*6w031/player 2: i.*edd.i*/**a*yln7*w*31.jpg 3: www.el*q*ens.com/t*o*/3M*IAv/e*g*ne*ring/cryptocurre**y-*xcel-*empl*t*s/bitcoin-*ry***curr*n***fi*o-Prof*t*ca*cu*ato*-fo*-*axa*i*n 4: *ww.eloque*s.com/t*ol/3B4l**9X/eng*ne**i*g/cryptoc*r*ency-exc*l-tem*late*/bi**o*n-crypto*ur***cy-lifo-*as***n-fir**-*ut*Pro**t-cal**l***r-for-taxa*i*n 5: www.fifocalculator.com**
Unknown links are censored to prevent spreading illicit content.
submitted by removalbot to removalbot [link] [comments]

05-30 08:54 - 'Excel and Google Sheet Calculators to Track your Bitcoin Trading Profit with FIFO and LIFO methods' (self.Bitcoin) by /u/pksoni removed from /r/Bitcoin within 1696-1706min

'''
Spreadsheet is ready to calculate FIFO Profits up to 2000 transactions, which can easily be extended further by dragging the formulas as per your requirement.
[Bitcoin Cryptocurrency FIFO Gain Excel Calculator]1
You will just need to put Transaction Type (buy or sale), Date Transaction, Bitcoin Quantity and Price. Sheet will display important data for every row:
You can purchase this tool from Eloquens.com marketplace for USD $10 only. LIFO (Last in First Out) and Google Sheet versions are also available.
FIFO Profit Excel Calculator: [link]2
LIFO (Last In First Out) Profit Excel Calculator: [link]3
**You can purchase it for Bitcoin or other cryptocurrency from [link]4
Please let me know if you have any question or suggestion to improve this template.
'''
Excel and Google Sheet Calculators to Track your Bitcoin Trading Profit with FIFO and LIFO methods
Go1dfish undelete link
unreddit undelete link
Author: pksoni
1: re*dit.com/link/bu**mc/v*deo/sl*36***v2**1/*laye* 2: www.el*q*ens.com/tool*3M*IA**eng*ne*ring/cryptoc*rren*y-ex*e**templat*s/bi*co*n-cry**ocu*rency-**f**Pr*fit-ca*cul***r-**r-tax**ion 3: w*w.el*quens.com*t*ol/3*4l*y**/engineering/****tocurren**-excel*t***lates****co**-**yp*ocu*rency-*if*-last-i*-firs*-**t-Profit-ca*culator-fo*-ta*at*on 4: www.fifocalculator.com**
Unknown links are censored to prevent spreading illicit content.
submitted by removalbot to removalbot [link] [comments]

05-30 08:54 - 'FIFO Excel/Google Sheet Calculators available on Eloquens marketplace' (self.Bitcoin) by /u/pksoni removed from /r/Bitcoin within 2918-2928min

'''

[Bitcoin Cryptocurrency FIFO Gain Excel Calculator]1
'''
FIFO Excel/Google Sheet Calculators available on Eloquens marketplace
Go1dfish undelete link
unreddit undelete link
Author: pksoni
1: i.redd.i**g*1m*zlatw0*1.*p*
Unknown links are censored to prevent spreading illicit content.
submitted by removalbot to removalbot [link] [comments]

05-30 08:44 - 'Simple Excel Calculator to Track your Bitcoin Trading Profits using FIFO' (self.Bitcoin) by /u/pksoni removed from /r/Bitcoin within 195-205min

'''
Spreadsheet is ready to calculate FIFO Profits up to 2000 transactions, which can easily be extended further by dragging the formulas as per your requirement.
[Bitcoin Cryptocurrency FIFO Gain Excel Calculator]1
You will just have to put Transaction Type (buy or sale), Date Transaction, Bitcoin Quantity and Price. Sheet will display important data for every row:
You can purchase this tool from Eloquens.com marketplace for USD $10 only. LIFO (Last in First Out) and Google Sheet versions are also available.
FIFO Profit Excel Calculator: [[link]5
LIFO (Last In First Out) Profit Excel Calculator: [[link]6
You can purchase it for Bitcoin or other cryptocurrency from [**[link]7
'''
Simple Excel Calculator to Track your Bitcoin Trading Profits using FIFO
Go1dfish undelete link
unreddit undelete link
Author: pksoni
1: r*d**t.com/link/b*pal9/vi*eo/t0*d*vnz*a13*/p***er 2: www**loqu*ns.*om/*ool/3MdIA*/e*gin*eri*g/***pto*urrency-ex*el-templa*es/bi*coin-*rypto*urre**y-f**o-*r***t-***cula**r-for-taxatio* 3: www.*lo*uens.com/**ol/3B4lfy*X*eng***ering**ryptocu*re**y-excel-templat*s/bi*coin**r**to*ur**ncy*l**o-last**n-f*rst-out*Pr*f*t-calc*la*o*-fo*-taxa*io* 4: w*w.fifocalc***tor**om 5: w*w.eloquens*co***ool/3MdI*v/engi*eering*c*ypt*cur**n**-excel-t*m**ates/bitco*n***y*t*cu**en*y-fifo-**ofi*-c**cu**tor-for-taxat*on]^^2 6: ww*.el*quens.com/tool/3B4lfy9X/*ngin*er*n*/**yp*ocu*r*n****xcel**e*plates/bitcoin*c*yp*ocur*ency-l*fo-*ast-*n-first-out*Pr*fit-**l**l*t*r-f*r**axation*^*3 7: www.fifocalculator.com**]^^4
Unknown links are censored to prevent spreading illicit content.
submitted by removalbot to removalbot [link] [comments]

05-30 08:54 - 'Track your Bitcoin Trading Profit with FIFO Excel and Google Sheet Calculators' (self.Bitcoin) by /u/pksoni removed from /r/Bitcoin within 2932-2942min

'''
Spreadsheet is ready to calculate FIFO Profits up to 2000 transactions, which can easily be extended further by dragging the formulas as per your requirement.
[Bitcoin Cryptocurrency FIFO Gain Excel Calculator]1
You will just have to put Transaction Type (buy or sale), Date Transaction, Bitcoin Quantity and Price. Sheet will display important data for every row:
You can purchase this tool from Eloquens.com marketplace for USD10 only. LIFO (Last in First Out) and Google Sheet versions are also available.
[Bitcoin Cryptocurrency FIFO Gain Excel Calculator]2
FIFO Profit Excel Calculator: [link]3
LIFO (Last In First Out) Profit Excel Calculator: [link]4
**You can purchase it for Bitcoin or other cryptocurrency from [link]5
Please let me know if you have any question or suggestion to improve this template.
'''
Track your Bitcoin Trading Profit with FIFO Excel and Google Sheet Calculators
Go1dfish undelete link
unreddit undelete link
Author: pksoni
1: i.redd.it*cu*xih*m**031**pg 2: *edd*t.co*/link/bt*8bu**ide*/bbtyfz**qw*3*/*layer 3: www.*loqu*n*.*om*to*l/3MdI*v*en*in***ing/crypto*ur*ency-*xc*l-te**lat*s*bitc*in**ryptocur*ency-fifo*Pro*i*-**lculator-for-*axat*o* 4: *ww**lo*uens.*om/t*o**3B4l*y9X/*ngi*eering*crypt***rrency-e***l*temp*ate**bitcoin-cry*toc*r*e*c*-li**-last-*n-first***t-Pr*fit-calculator-fo**t*xa*ion 5: www.fifocalculator.com**
Unknown links are censored to prevent spreading illicit content.
submitted by removalbot to removalbot [link] [comments]

04-17 07:53 - 'Track your Trading Gains with FIFO Excel and Google Sheet Calculators' (self.Bitcoin) by /u/pksoni removed from /r/Bitcoin within 0-5min

'''
If you trade in shares, commodity or cryptocurrency and want to keep track of your trading profit or loss using FIFO method, here is an easy to use “FIFO Gain Excel Calculator” with Google Sheet version.
Besides showing FIFO Gain or Loss after every transaction, spreadsheet will also show you other important data e.g. Cumulative Cost of Inventory Purchased, Cumulative Earning from Sell of Inventory, Total Inventory Purchased, Total Inventory Sold, Inventory in Hand after every transaction.
Spreadsheet is ready to calculate FIFO gains up to 2000 transactions, which can easily be extended further by dragging the formulas as per your requirement.
Sheet automatically highlights the rows for Buy and Sell transactions in Green and Orange colors so user can easily identify a Buy or sell transaction.
You will just have to put your trading details i.e. Transaction Type (buy or sale), Date & Time of Transaction, Inventory Quantity in columns A to D and sheet will automatically calculate FIFO gains and other important data for every row. Columns P, Q, R and S contain formulas for calculating costs of Inventory sold in parts. These contain intermediate results. You may show or hide them as per your choice.
You can set trading fees for buy or sell transaction in 2 ways:
First method is to set a fixed percentage for all Buy and Sell transactions in cells B1 and B2. It will be used to fill amount of commission (in $) for each transaction in column F and remove values from column E.
In second method you can manually fill amount of variable commission (in $) for each transaction in column E. In that case, value in column F will NOT be used by sheet.
[FIFO Gain Excel Calculator]1
You can purchase this tool from Eloquens.com marketplace for USD $10 only. LIFO (Last in First Out) and Google Sheet versions are also available.
FIFO Gain Excel Calculator: [link]2
LIFO (Last In First Out) Gain Excel Calculator: [link]3
If you want to purchase it for Bitcoin, Ethereum, Litecoin or other cryptocurrency, please visit [link]4 or send equivalent amount to the addresses given in description and email your transaction detail to [email protected]. You will get the tool in your mailbox after payment confirmation.
BTC : 1NYqYEUGY7h1cbKVkW12wmFfcZMnv6DEa7
ETH : 0x3Cbd9480E480f1d755E5b2389b0E57cABE41e982
LTC : LKFcSetKJY2xufP7UUNZdA8EbPwegKAxg3
Please let me know if you have any question or suggestion to improve this template.
'''
Track your Trading Gains with FIFO Excel and Google Sheet Calculators
Go1dfish undelete link
unreddit undelete link
Author: pksoni
1: red*i*.com/link/**53g5/v**eo/v*a*nukb**s*1/pla*er 2: *ww.**oque*s*co*/t**l*3MdIAv*eng*nee**ng/c*ypt**urre**y-*xcel**empl*tes/b*tcoin-cryptocurrency-*ifo-ga*n-cal**lator**o**t*xation 3: *ww.eloquens.co*/t*ol/3B4*f**X/engine*r*ng/c**ptocurren*y-**cel**e**l***s/*itc*in-cryptocurrency-*i*o-l*st-i*-firs*-out*gain-c*lcu***or-*or***x*tion 4: www.fifocalculator.com
Unknown links are censored to prevent spreading illicit content.
submitted by removalbot to removalbot [link] [comments]

Track your Trading Gains with FIFO Excel and Google Sheet Calculators /r/Bitcoin

Track your Trading Gains with FIFO Excel and Google Sheet Calculators /Bitcoin submitted by ABitcoinAllBot to BitcoinAll [link] [comments]

Bitcoin Cryptocurrency FIFO Gain Excel and Google Sheet Calculators for Taxation /r/Bitcoin

Bitcoin Cryptocurrency FIFO Gain Excel and Google Sheet Calculators for Taxation /Bitcoin submitted by ABitcoinAllBot to BitcoinAll [link] [comments]

Bitcoin Cryptocurrency FIFO Gain Excel and Google Sheet Calculators for Taxation /r/BitcoinBeginners

Bitcoin Cryptocurrency FIFO Gain Excel and Google Sheet Calculators for Taxation /BitcoinBeginners submitted by cryptoanalyticabot to cryptoall [link] [comments]

Bitcoin Cryptocurrency FIFO Gain Excel and Google Sheet Calculators for Taxation /r/BitcoinBeginners

Bitcoin Cryptocurrency FIFO Gain Excel and Google Sheet Calculators for Taxation /BitcoinBeginners submitted by ABitcoinAllBot to BitcoinAll [link] [comments]

Bitcoin Cryptocurrency FIFO Gain Excel and Google Sheet Calculators for Taxation /r/btc

Bitcoin Cryptocurrency FIFO Gain Excel and Google Sheet Calculators for Taxation /btc submitted by ABitcoinAllBot to BitcoinAll [link] [comments]

Bitcoin Cryptocurrency FIFO Gain Excel and Google Sheet Calculators for Taxation

Bitcoin Cryptocurrency FIFO Gain Excel and Google Sheet Calculators for Taxation submitted by cryptoallbot1 to cryptoall [link] [comments]

Bitcoin Listed on Microsoft Excel — Calculating Satoshis Simplified

Bitcoin Listed on Microsoft Excel — Calculating Satoshis Simplified submitted by crypt0sparta to Bitcoin [link] [comments]

Bitcoin Listed on Microsoft Excel — Calculating Satoshis Simplified

Bitcoin Listed on Microsoft Excel — Calculating Satoshis Simplified submitted by crypt0sparta to btc [link] [comments]

With tax season around the corner, thought I'd share this cost basis calculator I've made. (Excel VBA) /r/Bitcoin

With tax season around the corner, thought I'd share this cost basis calculator I've made. (Excel VBA) /Bitcoin submitted by BitcoinAllBot to BitcoinAll [link] [comments]

Bitcoin share calculation in EXCEL SHEET

Bitcoin share calculation in EXCEL SHEET submitted by ososru to Bitcoin4free [link] [comments]

Bitcoin share calculation in EXCEL SHEET

Bitcoin share calculation in EXCEL SHEET submitted by Rufflenator to 3bitcoins [link] [comments]

Bitcoin Listed as a Currency on Microsoft Excel — Calculating ‘Sats’ Simplified

Bitcoin Listed as a Currency on Microsoft Excel — Calculating ‘Sats’ Simplified submitted by leftok to atbitcoin [link] [comments]

Can someone tell me how to calculate bitcoin mining profit. I want to build my own model in excel I just need the formula. Thanks!

submitted by YaBoiBeezy to BitcoinMining [link] [comments]

Can someone tell me how to calculate bitcoin mining profit. I want to build my own model in excel I just need the formula. Thanks! /r/BitcoinMining

Can someone tell me how to calculate bitcoin mining profit. I want to build my own model in excel I just need the formula. Thanks! /BitcoinMining submitted by BitcoinAllBot to BitcoinAll [link] [comments]

Bitcoin Newcomers FAQ - Please read!

Welcome to the /Bitcoin Sticky FAQ

You've probably been hearing a lot about Bitcoin recently and are wondering what's the big deal? Most of your questions should be answered by the resources below but if you have additional questions feel free to ask them in the comments.
It all started with the release of the release of Satoshi Nakamoto's whitepaper however that will probably go over the head of most readers so we recommend the following videos for a good starting point for understanding how bitcoin works and a little about its long term potential:
Some other great resources include Lopp.net, the Princeton crypto series and James D'Angelo's Bitcoin 101 Blackboard series.
Some excellent writing on Bitcoin's value proposition and future can be found at the Satoshi Nakamoto Institute.
Some Bitcoin statistics can be found here and here. Developer resources can be found here. Peer-reviewed research papers can be found here.
Potential upcoming protocol improvements and scaling resources here and here.
The number of times Bitcoin was declared dead by the media can be found here (LOL!)

Key properties of Bitcoin

Where can I buy bitcoins?

Bitcoin.org and BuyBitcoinWorldwide.com are helpful sites for beginners. You can buy or sell any amount of bitcoin (even just a few dollars worth) and there are several easy methods to purchase bitcoin with cash, credit card or bank transfer. Some of the more popular resources are below, also check out the bitcoinity exchange resources for a larger list of options for purchases.
Here is a listing of local ATMs. If you would like your paycheck automatically converted to bitcoin use Bitwage.
Note: Bitcoins are valued at whatever market price people are willing to pay for them in balancing act of supply vs demand. Unlike traditional markets, bitcoin markets operate 24 hours per day, 365 days per year. Preev is a useful site that that shows how much various denominations of bitcoin are worth in different currencies. Alternatively you can just Google "1 bitcoin in (your local currency)".

Securing your bitcoins

With bitcoin you can "Be your own bank" and personally secure your bitcoins OR you can use third party companies aka "Bitcoin banks" which will hold the bitcoins for you.
Note: For increased security, use Two Factor Authentication (2FA) everywhere it is offered, including email!
2FA requires a second confirmation code to access your account making it much harder for thieves to gain access. Google Authenticator and Authy are the two most popular 2FA services, download links are below. Make sure you create backups of your 2FA codes.
Google Auth Authy OTP Auth
Android Android N/A
iOS iOS iOS

Watch out for scams

As mentioned above, Bitcoin is decentralized, which by definition means there is no official website or Twitter handle or spokesperson or CEO. However, all money attracts thieves. This combination unfortunately results in scammers running official sounding names or pretending to be an authority on YouTube or social media. Many scammers throughout the years have claimed to be the inventor of Bitcoin. Websites like bitcoin(dot)com and the btc subreddit are active scams. Almost all altcoins (shitcoins) are marketed heavily with big promises but are really just designed to separate you from your bitcoin. So be careful: any resource, including all linked in this document, may in the future turn evil. Don't trust, verify. Also as they say in our community "Not your keys, not your coins".

Where can I spend bitcoins?

Check out spendabit or bitcoin directory for millions of merchant options. Also you can spend bitcoin anywhere visa is accepted with bitcoin debit cards such as the CashApp card. Some other useful site are listed below.
Store Product
Gyft Gift cards for hundreds of retailers including Amazon, Target, Walmart, Starbucks, Whole Foods, CVS, Lowes, Home Depot, iTunes, Best Buy, Sears, Kohls, eBay, GameStop, etc.
Spendabit, Overstock and The Bitcoin Directory Retail shopping with millions of results
ShakePay Generate one time use Visa cards in seconds
NewEgg and Dell For all your electronics needs
Bitwa.la, Coinbills, Piixpay, Bitbill.eu, Bylls, Coins.ph, Bitrefill, LivingRoomofSatoshi, Coinsfer, and more Bill payment
Menufy, Takeaway and Thuisbezorgd NL Takeout delivered to your door
Expedia, Cheapair, Destinia, Abitsky, SkyTours, the Travel category on Gyft and 9flats For when you need to get away
Cryptostorm, Mullvad, and PIA VPN services
Namecheap, Porkbun Domain name registration
Stampnik Discounted USPS Priority, Express, First-Class mail postage
Coinmap and AirBitz are helpful to find local businesses accepting bitcoins. A good resource for UK residents is at wheretospendbitcoins.co.uk.
There are also lots of charities which accept bitcoin donations.

Merchant Resources

There are several benefits to accepting bitcoin as a payment option if you are a merchant;
If you are interested in accepting bitcoin as a payment method, there are several options available;

Can I mine bitcoin?

Mining bitcoins can be a fun learning experience, but be aware that you will most likely operate at a loss. Newcomers are often advised to stay away from mining unless they are only interested in it as a hobby similar to folding at home. If you want to learn more about mining you can read more here. Still have mining questions? The crew at /BitcoinMining would be happy to help you out.
If you want to contribute to the bitcoin network by hosting the blockchain and propagating transactions you can run a full node using this setup guide. If you would prefer to keep it simple there are several good options. You can view the global node distribution here.

Earning bitcoins

Just like any other form of money, you can also earn bitcoins by being paid to do a job.
Site Description
WorkingForBitcoins, Bitwage, Cryptogrind, Coinality, Bitgigs, /Jobs4Bitcoins, BitforTip, Rein Project Freelancing
Lolli Earn bitcoin when you shop online!
OpenBazaar, Purse.io, Bitify, /Bitmarket, 21 Market Marketplaces
/GirlsGoneBitcoin NSFW Adult services
A-ads, Coinzilla.io Advertising
You can also earn bitcoins by participating as a market maker on JoinMarket by allowing users to perform CoinJoin transactions with your bitcoins for a small fee (requires you to already have some bitcoins.

Bitcoin-Related Projects

The following is a short list of ongoing projects that might be worth taking a look at if you are interested in current development in the bitcoin space.
Project Description
Lightning Network Second layer scaling
Blockstream, Rootstock and Drivechain Sidechains
Hivemind and Augur Prediction markets
Tierion and Factom Records & Titles on the blockchain
BitMarkets, DropZone, Beaver and Open Bazaar Decentralized markets
JoinMarket and Wasabi Wallet CoinJoin implementation
Coinffeine and Bisq Decentralized bitcoin exchanges
Keybase Identity & Reputation management
Abra Global P2P money transmitter network
Bitcore Open source Bitcoin javascript library

Bitcoin Units

One Bitcoin is quite large (hundreds of £/$/€) so people often deal in smaller units. The most common subunits are listed below:
Unit Symbol Value Info
bitcoin BTC 1 bitcoin one bitcoin is equal to 100 million satoshis
millibitcoin mBTC 1,000 per bitcoin used as default unit in recent Electrum wallet releases
bit bit 1,000,000 per bitcoin colloquial "slang" term for microbitcoin (μBTC)
satoshi sat 100,000,000 per bitcoin smallest unit in bitcoin, named after the inventor
For example, assuming an arbitrary exchange rate of $10000 for one Bitcoin, a $10 meal would equal:
For more information check out the Bitcoin units wiki.
Still have questions? Feel free to ask in the comments below or stick around for our weekly Mentor Monday thread. If you decide to post a question in /Bitcoin, please use the search bar to see if it has been answered before, and remember to follow the community rules outlined on the sidebar to receive a better response. The mods are busy helping manage our community so please do not message them unless you notice problems with the functionality of the subreddit.
Note: This is a community created FAQ. If you notice anything missing from the FAQ or that requires clarification you can edit it here and it will be included in the next revision pending approval.
Welcome to the Bitcoin community and the new decentralized economy!
submitted by BitcoinFan7 to Bitcoin [link] [comments]

Wandering From the Path? | Monthly Portfolio Update - August 2020

Midway along the journey of our life I woke to find myself in a dark wood, for I had wandered off from the straight path.
Dante, The Divine Comedy: Inferno, Canto I
This is my forty-fifth portfolio update. I complete this update monthly to check my progress against my goal.
Portfolio goal
My objective is to reach a portfolio of $2 180 000 by 1 July 2021. This would produce a real annual income of about $87 000 (in 2020 dollars).
This portfolio objective is based on an expected average real return of 3.99 per cent, or a nominal return of 6.49 per cent.
Portfolio summary
Total portfolio value $1 848 896 (+$48 777 or 2.7%)
Asset allocation
Presented visually, below is a high-level view of the current asset allocation of the portfolio.
[Chart]
Comments
The portfolio has increased in value for the fifth consecutive month, and is starting to approach the monthly value last reached in January.
The portfolio has grown over $48 000, or 2.7 per cent this month, reflecting the strong market recovery since late March
[Chart]
The growth in the portfolio was broadly-based across global and Australian equities, with an increase of around 3.8 per cent. Following strong previous rises, gold holdings decreased by around 2.2 per cent, while Bitcoin continued to increase in value (by 2.5 per cent).
Combined, the value of gold and Bitcoin holdings remain at a new peak, while total equity holdings are still below their late January peak to the tune of around $50 000. The fixed income holdings of the portfolio continue to fall below the target allocation.
[Chart]
The expanding value of gold and Bitcoin holdings since January last year have actually had the practical effect of driving new investments into equities, since effectively for each dollar of appreciation, for example, my target allocation to equities rises by seven dollars.
New investments this month have been in the Vanguard international shares exchange-traded fund (VGS) and the Australian shares equivalent (VAS). These have been directed to bring my actual asset allocation more closely in line with the target split between Australian and global shares set out in the portfolio plan.
As the exchange traded funds such as VGS, VAS and Betashares A200 now make up nearly 30 per cent of the overall portfolio, the quarterly payments they provide have increased in magnitude and importance. Early in the journey, third quarter distributions were essentially immaterial events.
Using the same 'median per unit' forecast approach as recently used for half yearly forecasts would suggest a third quarter payout due at the end of September of around $6000. Due to significant announced dividend reductions across this year I am, however, currently assuming this is likely to be significantly lower, and perhaps in the vicinity of $4000 or less.
Finding true north: approach to achieving a set asset allocation
One of the choices facing all investors with a preferred asset allocation is how strictly the target is applied over time, and what variability is acceptable around that. There is a significant body of financial literature around that issue.
My own approach has been to seek to target the preferred asset allocation dynamically, through buying the asset class that is furthest from its target, with new portfolio contributions, and re-investment of paid out distributions.
As part of monitoring asset allocation, I also track a measure of 'absolute' variance, to understand at a whole of portfolio level how far it is from the desired allocation.
This is the sum of the absolute value of variances (e.g. so that being 3 per cent under target in shares, and 7 per cent over target in fixed interest will equal an absolute variance of 10 per cent under this measure).
This measure is currently sitting near its highest level in around 2 years, at 15.0 per cent, as can be seen in the chart below.
[Chart]
The dominant reason for this higher level of variance from target is significant appreciation in the price of gold and Bitcoin holdings.
Mapping the sources of portfolio variances
Changes in target allocations in the past makes direct comparisons problematic, but previous peaks of the variance measure matches almost perfectly past Bitcoin price movements.
For a brief period in January 2018, gold and Bitcoin combined constituted 20 per cent, or 1 in 5 dollars of the entire portfolio. Due to the growth in other equity components of the portfolio since this level has not been subsequently exceeded.
Nonetheless, it is instructive to understand that the dollar value of combined gold and Bitcoin holdings is actually up around $40 000 from that brief peak. With the larger portfolio, this now means they together make up 17.2 per cent of the total portfolio value.
Tacking into the wind of portfolio movements?
The logical question to fall out from this situation is: to what extent should this drive an active choice to sell down gold and Bitcoin until they resume their 10 per cent target allocation?
This would currently imply selling around $130 000 of gold or Bitcoin, and generating a capital gains tax liability of potentially up to $27 000. Needless to say this is not an attractive proposition. Several other considerations lead me to not make this choice:
This approach is a departure from a mechanistic implementation of an asset allocation rule. Rather, the approach I take is pragmatic.
Tracking course drift in the portfolio components
As an example, I regularly review whether a significant fall in Bitcoin prices to its recent lows would alter my monthly decision on where to direct new investments. So far it does not, and the 'signal' continues to be to buy new equities.
Another tool I use is a monthly measurement of the absolute dollar variance of Australian and global shares, as well as fixed interest, from their ideal target allocations.
The chart below sets this out for the period since January 2019. A positive value effectively represents an over-allocation to a sector, a negative value, an under-allocation compared to target.
[Chart]
This reinforces the overall story that, as gold and Bitcoin have grown in value, there emerges a larger 'deficit' to the target. Falls in equities markets across February and March also produce visibly larger 'dollar gaps' to the target allocation.
This graph enables a tracking of the impact of portfolio gains or losses, and volatility, and a better understanding of the practical task of returning to target allocations. Runaway lines in either direction would be evidence that current approaches for returning to targets were unworkable, but so far this does not appear to be the case.
A crossing over: a credit card FI milestone
This month has seen a long awaited milestone reached.
Calculated on a past three year average, portfolio distributions now entirely meet monthly credit card expenses. This means that every credit card purchase - each shopping trip or online purchase - is effectively paid for by average portfolio distributions.
At the start of this journey, distributions were only equivalent to around 40 per cent of credit card expenses. As time has progressed distributions have increased to cover a larger and larger proportion of card expenses.
[Chart]
Most recently, with COVID-19 related restrictions having pushed card expenditure down further, the remaining gap to this 'Credit Card FI' target has closed.
Looked at on an un-smoothed basis, expenditures on the credit card have continued to be slightly lower than average across the past month. The below chart details the extent to which portfolio distributions (red) cover estimated total expenses (green), measured month to month.
[Chart]
Credit card expenditure makes up around 80 per cent of total spending, so this is not a milestone that makes paid work irrelevant or optional. Similarly, if spending rises as various travel and other restrictions ease, it is possible that this position could be temporary.
Equally, should distributions fall dramatically below long term averages in the year ahead, this could result in average distributions falling faster than average monthly card expenditure. Even without this, on a three year average basis, monthly distributions will decline as high distributions received in the second half of 2017 slowly fall out of the estimation sample.
For the moment, however, a slim margin exists. Distributions are $13 per month above average monthly credit card bills. This feels like a substantial achievement to note, as one unlooked for at the outset of the journey.
Progress
Progress against the objective, and the additional measures I have reached is set out below.
Measure Portfolio All Assets
Portfolio objective – $2 180 000 (or $87 000 pa) 84.8% 114.6%
Credit card purchases – $71 000 pa 103.5% 139.9%
Total expenses – $89 000 pa 82.9% 112.1%
Summary
What feels like a long winter is just passed. The cold days and weeks have felt repetitive and dominated by a pervasive sense of uncertainty. Yet through this time, this wandering off, the portfolio has moved quite steadily back towards it previous highs. That it is even approaching them in the course of just a few months is unexpected.
What this obscures is the different components of growth driving this outcome. The portfolio that is recovering, like the index it follows, is changing in its underlying composition. This can be seen most starkly in the high levels of variance from the target portfolio sought discussed above.
It is equally true, however, of individual components such as international equity holdings. In the case of the United States the overall index performance has been driven by share price growth in just a few information technology giants. Gold and Bitcoin have emerged from the shadows of the portfolio to an unintended leading role in portfolio growth since early 2019.
This month I have enjoyed reading the Chapter by Chapter release of the Aussie FIRE e-book coordinated by Pearler. I've also been reading posts from some newer Australian financial independence bloggers, Two to Fire, FIRE Down Under, and Chasing FIRE Down Under.
In podcasts, I have enjoyed the Mad Fientist's update on his fourth year of financial freedom, and Pat and Dave's FIRE and Chill episodes, including an excellent one on market timing fallacies.
The ASX Australian Investor Study 2020 has also been released - setting out some broader trends in recent Australian investment markets, and containing a snapshot of the holdings, approaches and views of everyday investors. This contained many intriguing findings, such as the median investment portfolio ($130 000), its most frequent components (direct Australian shares), and how frequently portfolios are usually checked - with 61 per cent of investors checking their portfolios at least once a month.
This is my own approach also. Monthly assessments allow me to gauge and reflect on how I or elements of the portfolio may have wandered off the straight way in the middle of the journey. Without this, the risk is that dark woods and bent pathways beckon.
The post, links and full charts can be seen here.
submitted by thefiexpl to fiaustralia [link] [comments]

Trading Bitcoin: 4 Steps to Calculate Your Position Size ... USI Tech Compounding Calculator Excel Download - How to Earn Up To 300 Percent Free BTC in 140 Days Mining Bitcoin with Excel - YouTube EXCEL BITCOIN HESAPLAMA - (JSON İLE) - 1 How to use Excel to fetch Bitcoin Trading info?

Find out what your expected return is depending on your hash rate and electricity cost. Find out if it's profitable to mine Bitcoin, Ethereum, Litecoin, DASH or Monero. Do you think you've got what it takes to join the tough world of cryptocurrency mining? "Bitcoin Cryptocurrency FIFO Gain Google Sheet Calculator" is a very easy-to-use, handy Excel sheet for calculating the gains in Bitcoin and other crypto trading using FIFO method. Sheet is ready to calculate FIFO gains up to 2000 transactions, which can easily be extended further by dragging the formulas as per your requirement. In order to properly create a useful bitcoin calculator, you need an Excel spreadsheet that has components like this: Put the price that you know of under the $ column. Label the months. Click on the D column, under Difficulty + 10%, and place the same value you put beside the Current difficult in previous step, in this case it's (=B6) If you are looking for some very easy-to-use, handy tools for calculating the gains in Bitcoin Cryptocurrency or any other stock market trading, you are at the right place. We provide you with the best Excel Spreadsheet and Google Sheet calculators with FIFO and LIFO methods. "Bitcoin Cryptocurrency Long Term Capital Gains FIFO Calculator For Taxation" Price: $20. Check Here! "Bitcoin ... Does a Bitcoin calculator on an excel application offer any advantage? For the most part, the freely available Bitcoin calculators on the internet can meet most of your needs effectively. They are also convenient because you do not need skill and knowledge in addition to what you have regarding trading. Indeed, very few people can create a simple calculator on excel. While most of us using it ...

[index] [31328] [3748] [23963] [43247] [26829] [21115] [33157] [12146] [11109] [51418]

Trading Bitcoin: 4 Steps to Calculate Your Position Size ...

EXCEL BITCOIN CALCULATOR (WITH PARSING JSON) - 2 - Duration: 4:44. Excel Nedir 68 views. 4:44. Excel Crypto Spreadsheet Part 2. How to import web data into your excel - Duration: 3:42. ... Pull a Spreadstreet dataset into Excel in minutes with the Excel Add-In. No programming skills required. Just a few clicks through our interface and you are good to go. No programming skills required. BitMEX CALCULATOR for Profits and Fees calculations in Excel file. Explained ... Use new our smart BitMEX RISK calculator. How to hedge Bitcoins at BitMEX exchange? Calculator explanation here and ... Learn how to mine Bitcoin with an Excel spreadsheet. Check out the following video for info on 21's Bitcoin computer, which can actually be used to mine Bitc... Very easy-to-use handy Excel sheet for calculating the gains in bitcoin and other crypto trading using FIFO method. You simply have to insert your trading details and the spreadsheet will ...

#