Reddit Posts
[SERIOUS] How To Take Full Advantage Of The Bear Market
Making your own Excel/Calc table to track your average buy and profit values
Vitalik Buterin Proposed a Name For a Crypto on Twitter, Scammers Launched it Immediately
HUSD Stablecoin Loses Dollar Peg and returned.
Anchor Protocol Point Of View and Discussion
Pi network using claimable balance operations of Stellar to lockup mainnet coins for up to 3 years
A touch of hype and facts with personal opinions - a look at Goji Crypto: my positives and negatives!
How to calculate your true average price in a spreadsheet
Trading on the ECOsystem SUM vs the Global Crypto Market
If you don't know how to calculate how many Moons you have coming, here is how.
In all honesty, what strategy do you guys prefer? DCA OR LUMP SUM?
Summit just launched LP locked contract renounced
⛰️$Summit (SUM) is launching right now! ⛰️<2k Market cap and about to climb the highest heights! Launched via Fair Launch Group so its guaranteed SAFU! 🔒
What does Miami Bitcoin Conference mean to Crypto Newbies and their Investment? History Revisited and Lessons Learnt..!!
What does Miami Bitcoin Conference mean to Crypto Newbies and their Investment? History Revisited and Lessons Learnt..!!
Alt(shit)coins and parasocial relationshiops...
I've done the maths so you don't have to. In the last month, if you downvoted 10,000 people, you would receive approximately TWO more moons. STOP DOWNVOTING OR REFUSING TO VOTE PEOPLE.
Debunking "Sound" Investment Advice: (Not Financial Advice)
Mentions
This is a real partnership. Avax is not paying AWS for it's services as most people are implying. This [twitter](https://twitter.com/el33th4xor/status/1613240492392603665) thread by avax founder explains it really well in easy to understand language. And there's this [blogpost](https://aws.amazon.com/pt/blogs/startups/building-application-specific-blockchains-with-aws-on-avalanche/?sc_channel=sm&sc_campaign=AWS_Startup_Blog&sc_publisher=TWITTER&sc_geo=NAMER&sc_outcome=awareness&trk=SUM_blog_AMER&linkId=196852419) by AWS on it
It is a real partnership. Avax is not paying AWS for it's services as most people are implying. This [twitter](https://twitter.com/el33th4xor/status/1613240492392603665) thread by avax founder explains it really well in easy to understand language. And there's this [blogpost](https://aws.amazon.com/pt/blogs/startups/building-application-specific-blockchains-with-aws-on-avalanche/?sc_channel=sm&sc_campaign=AWS_Startup_Blog&sc_publisher=TWITTER&sc_geo=NAMER&sc_outcome=awareness&trk=SUM_blog_AMER&linkId=196852419) by AWS on it
It is a real partnership. Avax is not paying AWS for it's services as most people are implying. This [twitter](https://twitter.com/el33th4xor/status/1613240492392603665) thread by avax founder explains it really well in easy to understand language. And there's this [blogpost](https://aws.amazon.com/pt/blogs/startups/building-application-specific-blockchains-with-aws-on-avalanche/?sc_channel=sm&sc_campaign=AWS_Startup_Blog&sc_publisher=TWITTER&sc_geo=NAMER&sc_outcome=awareness&trk=SUM_blog_AMER&linkId=196852419) by AWS on it
It is a real partnership. Avax is not paying AWS for it's services as most people are implying. This [twitter](https://twitter.com/el33th4xor/status/1613240492392603665) thread by avax founder explains it really well in easy to understand language. And there's this [blogpost](https://aws.amazon.com/pt/blogs/startups/building-application-specific-blockchains-with-aws-on-avalanche/?sc_channel=sm&sc_campaign=AWS_Startup_Blog&sc_publisher=TWITTER&sc_geo=NAMER&sc_outcome=awareness&trk=SUM_blog_AMER&linkId=196852419) by AWS on it
It is a real partnership. Avax is not paying AWS for it's services as most people are implying. This [twitter](https://twitter.com/el33th4xor/status/1613240492392603665) thread by avax founder explains it really well in easy to understand language. And there's this [blogpost](https://aws.amazon.com/pt/blogs/startups/building-application-specific-blockchains-with-aws-on-avalanche/?sc_channel=sm&sc_campaign=AWS_Startup_Blog&sc_publisher=TWITTER&sc_geo=NAMER&sc_outcome=awareness&trk=SUM_blog_AMER&linkId=196852419) by AWS on it
It is a real partnership. Avax is not paying AWS for it's services as most people are implying. This [twitter](https://twitter.com/el33th4xor/status/1613240492392603665) thread by avax founder explains it really well in easy to understand language. And there's this [blogpost](https://aws.amazon.com/pt/blogs/startups/building-application-specific-blockchains-with-aws-on-avalanche/?sc_channel=sm&sc_campaign=AWS_Startup_Blog&sc_publisher=TWITTER&sc_geo=NAMER&sc_outcome=awareness&trk=SUM_blog_AMER&linkId=196852419) by AWS on it
It is a real partnership. Avax is not paying AWS for it's services as most people are implying. This [twitter](https://twitter.com/el33th4xor/status/1613240492392603665) thread by avax founder explains it really well in easy to understand language. And there's this [blogpost](https://aws.amazon.com/pt/blogs/startups/building-application-specific-blockchains-with-aws-on-avalanche/?sc_channel=sm&sc_campaign=AWS_Startup_Blog&sc_publisher=TWITTER&sc_geo=NAMER&sc_outcome=awareness&trk=SUM_blog_AMER&linkId=196852419) by AWS on it
Yes it is. Avax is not paying AWS for it's services as most people are implying. https://twitter.com/el33th4xor/status/1613240492392603665 This twitter thread by avax founder explains it really well. And there's this blogpost by AWS on it https://aws.amazon.com/pt/blogs/startups/building-application-specific-blockchains-with-aws-on-avalanche/?sc_channel=sm&sc_campaign=AWS_Startup_Blog&sc_publisher=TWITTER&sc_geo=NAMER&sc_outcome=awareness&trk=SUM_blog_AMER&linkId=196852419
SUM BANK FRAUD? Thats the same as my password! :Sam Bankman-Fried
A sorry, I accidentally shared an old picture of my process. The three missing words are: SUM BANK FRAUD
Keep a spreadsheet and record each buy with the following categories: Number of Units(sats) / Time of Buy(date) Obtainment Method(bank/app/etc) / Buy Price(spot$ofbtc) / Buy Total(purchase amount) Cost Basis / Running Total of Buys(total sats obtained). =SUM($buytotal$2:buytotal/runningtotal) will calculate cost basis. The spot price of the time you paid for the coin doesnt make it into the equation but you'll want to keep record of all the things for tax purposes just in case.
for your average cost? If you have your coin quantity in one column, buy price in another, you can use =SUMPRODUCT((coin range)\*(buy price range))/SUM(coin range)
it hasn't gotten fucked by "fuck everyone, I got mine" attitude, because that's the attitude of how capitalism started, you do shit for your own selfish benefits, it doesn't mean to be an asshole just means be selfish Meanwhile the government is enforcing stupid rules that screw up the system that worked really fucking well till now, well actually lets say last 10 years, Happy crypto exists, what is mine and I worked for will stay mine unless i get some benefit by giving that away, Im gonna farm my THOL and run it into something bigger CAPITALISM IS A POSITIVE SUM GAME, YALL JUST MAKING IT NEGATIVE SUM WITH STUPID RULES
Are bitcoins in well known exchanges all clean? What are the chances I receive some that was used in a known crime? Also, are bitcoins FILO or FIFO when it cycles thru exchanges? When I buy 1 btc from an exchange, am I just receiving a SUM of 100168584 Satoshi from a mixture of blocks where it was mined?
He LUMP SUM bought for cheap credit as it became available as well as with his (then) USD-denominated treasury. He now DCAs on expendable cash flow. Holy semantics batman.
Let's say column A is the amount of BTC bought, while column B is the price you entered at. The cost of the specific trade would be A*B. You can make a third column C that computes for this using > =(A:A)*(B:B) You also need to compute for the total amount of BTC you have. Total cost / Total amount of BTC > =SUM(C:C)/SUM(A:A)
You don't get it at all. The total amount of fiat that could ever come out of any given crypto is equal to the amount of fiat that went into the crypto. Fees? Same story. Fiat goes in, it can come out, but not in a higher quantity. It is ZERO SUM.
WEALTH IS NOT A ZERO SUM GAME, GET IT THROUGH YOUR HEAD This is basic damn capitalism, as long as it relies on supply and demand IT IS NOT A ZERO SUM not everyone will win, BUT IT IS NOT ZERO SUM IT IS POSITIVE SUM How are you gonna tell me buying a token like Kdx, making me fees off people using swaps for their tokens, is a zero sum in any way? i value that income, more than the one that sold which valued the cash on hand more Ponzi schemes are shitall, its exploitation. It is basically mercantilism Some of you need to open a book and read. Want a good one? read Seven deadly economic sins Some of you come here just to spew out whatever comes to yout mind
1. That money spent elsewhere could also create jobs. Hence the point is moot. 2. Again if you were not buying crypto that money would just go elsewhere. 3. Bank deposits are guaranteed. 4. That is true, if you lose someone else gains. not exactly a benefit is it? 5. Now that is utter bovine scat. Banks carry out billions of transactions everyday. Crypto is certainly not eco-friendly. So, in short Bill was right. Now, does it provide value to some, sure, you hand over your hard earned cash and swap it for digi-coins. The seller then uses your cash to spend it on Lamborghini's, etc, etc.... Simply put Crypto is one huge ZERO SUM GAME. Actually it's a negative sum game. All those organisations are sucking cash out of crypto. The only source of funds into the scheme are the punters.
Correct, but then that is a currency and not an investment. Holding on to dollars for 30 years will earn you zip (in the bank you'll get some interest, not much). In fact you'll lose purchasing power. Currencies are meant to be spent, not saved. Dollars are therefore a NEGATIVE SUM GAME. This is why most people invest in productive assets like companies. They produce goods or services, make profits, and grow. They grow in value, just look at stock market performance over the last 50 years. Do you even understand what a negative/zero sum game is?
Lol interview asked him "Do you have any crypto right now?" and he laughs and says "I don't really wanna comment on that but I see the value of the conversation we're having right now" ...or in other words "YES I DO! I JUST BOUGHT A BIG SUM OF BITCOIN AND I WANT TO PUMP IT UP ASAP!"
Example coin X: Column A B C 1 january 5 coins $1.5 (price rate $1.5 for 1 coin) 3 january 1 coin $2 7 january 5 coins $4 Average buying price = 5/11*1.5 + 1/11*2 + 5/11*4 11 = SUM column B When using excel, it´s easier to use the following formula: =SUMPRODUCT(B1:B3;C1:C3)/SUM(B1:B3) For more information, google "weighted average".
It’s not that people are wrong entirely, Bitcoin IS a new asset type that could potentially change the world… that really isn’t the point though. People aren’t thinking through the microeconomic factors that influence bitcoin buyers/investors. I’ll use myself as a case study: I buy BTC with fiat, just like everyone else. When I’m deciding if I’m going to buy BTC, I examine my possible options… personally I also invest in stocks and real estate. If I see an opportunity to buy a significant dip in Apple or Google, I put money there. Or, maybe I save some money and buy another rental property. Regardless, I CAN’T DO ALL THREE WITH THE SAME SUM OF FIAT. As long as there is an opportunity cost trade off between the stock market, crypto, or other assets they will all be linked to some degree. The bottom line is that people are naive to believe that crypto is “100% it’s own thing”. If we bought BTC using time or some other asset that cannot be purchased with case, maybe that would be the case, but since buying crypto means we have to forego spending that fiat elsewhere they are linked heavily.
Do you even know what a zero sum game is? A service or product is not equal to 0, it is an actual benefit with monetary value. So one person receives the money, the other the product. IT IS NOT A ZERO SUM GAME.
Obviously you can't go back in time, but here's my fairly painless strategy: - Only buy and sell to USD, not crypto-to-crypto - Use one exchange for everything - Export "fills" as CSV - Simple SUM commands in Excel for total Buys (cost) and total Sells (proceeds) Proceeds - Cost = Gains/Losses
I like SUM for a portion of my portfolio as it inherently reduces volatility overall and has constant upside (if not explosive) as the overall market increases. /.02c
If you have the money and you don’t need it: LUMP SUM. Stretching investments creates opportunity costs. Most people are not bothered because they never see these numbers. However, they are real.
It's just math really. =A1 * A2 Multiplies box A1 with A2 =SUM(A1:A5) Sums up all values from A1 to A5 If you know basic math you can use excel to track crypto. But i understand if you rather use an app. I just like the freedom of spreadsheets because apps always have something they're not showing that you want to see.
Market cap = # of shares \* Share price. So In crypto its # of coins \* coin price. Represents the total value of a project. In practice, we use a circulating supply for this. You can use the two numbers to ascertain how much growth is probable. Will a project shed 8 zeros? not likely if the coin supply is several quadrillion for example. Circulating supply is how much of the total supply of coins (max that can be minted) is actually available to buy or sell. Max supply will be blank if there is no cap on how many coins can exist Volume = total value of all trades made with this currency in a time period. This is usually 24h, 7d , or 30d. Usually determined by summing the value of all trades (SUM spot price \* # of coins traded).
I will invest in education, the problem is that I've a SUM of money not doing anything while I don't join university.
binance europe, but this is a problem in all binance accounts worldwide. a vast variety of transactions simply don't show in the trade history. So if you take a look at your statements and SUM all transactions, the total is not equal to your total balance. binance says these are errors, but it looks more like they are stealing lol but you can test it: do a transaction of the type DUST ("transfer small amounts into BNB") and it will not show in your statement later.
My crypto gains ultimately come from global economic growth. Stop being obstinate. WE ARE NOT IN A ZERO-SUM SYSTEM.
Too bad for buttcoiners if you just keep saying "NEGATIVE SUM GAME" and "MUH TETHER", it will not go away. I actually feel bad for you. If you just removed the mental block out of your head that someone else put in there, and DCAed into crypto from 3-4 years ago you would be set. And have the freedom to live the life you choose. Americanscream scammed you my friend. ​ I sold a lot of Bitcoin in June myself, after finding the Buttcoin sub and other "truthers', and getting 'red pilled'. You are not alone
hey SUM. good 2 see u again. i could never hate ADA. \[braveheart\] I love ya always have
Only means cryptography will evolve. We've seen this before, think of the not-so-long-ago days when MD5SUM and WEP were considered secure
Yeah, you're verifying the wrong file. You must run `gpg --verify SHA256SUMS.asc SHA256SUM` and if the signature succeeds then you verify the hash with `sha256sum --ignore-missing --check SHA256SUMS`. Look here for an example: https://gitlab.com/1ma/dockertronics/-/blob/master/bitcoin/Dockerfile#L7-L18
I created a spreadsheet Excel for all the coins I hold. Easiest way to summarize how it's setup below... * Each sheet within the workbook is dedicated to 1 currency or token * Left side of each sheet--all the purchases I've made * Column 1: Coin Quantity, * Column 2: Coin Cost, * Column 3: Order Amount (auto calculated) * At the bottom, the excel file SUMS the Coin Quantities and the Order Amounts in Columns 1 and 3 * Right side, same thing but for Sales. Just use a "-" for the Coin Quantities * At the bottom, SUM Coin Quantities and Order Amounts for Sales * At the top I have a "Snapshot" that uses that information to show the Total USD Investment and Cost-per-Coin. * For your investment, just subtract the Total Sale SUM of Order Amounts from the Total Purchase SUM of order amounts. * For the Coin Quantities, SUM the Total Purchase SUM of Coin Quantities and the Total Sale SUM of Coin Quantities * For Cost-Per-Coin, divide the total USD Investment from above by the coins in your wallet I then have an "Overview" tab in the workbook that puts everything together into one sheet to view everything at once. This is where I've also built a few calculators that I use. I also track the total amount of USD deposits/withdraws I've made on the Overview sheet, which SUM into a "Total Investment" cell that I subtract from my "Current Portfolio Amount" cell to show me my total profit/loss. If you use the Coin Market Cap API excel integration, your workbook will pull real-time prices for each coin (after you set it up how you like).
Not true. If it becomes the only coin then it is the entire SUM of the market which will be greater than 1.
Yes, because a few people that puth their minds together can generate wealth out of thin air. /s Coins that have use cases build up their market cap by acting as a service. I PAY a little to use DApps on the Ethereum network. I PAY a little for the convenience, speed, and decentralized trust of Stellar Lumens as a borderless currency. I PAY a little to trade my fiat for a limited supply and store of value of bitcoin. The money I put into the network increases the market cap and value of the coin. When a coin has no use case, its value exists ONLY as speculation. Every green arrow you see on your Shiba portfolio is a direct mirror of someone's red. It is a ZERO SUM GAME. The only way for one person to make $1 million on SHiba is for 1000 other people to lose $1000 each(or some variation). Hell, Shiba is actually "negative sum" due to the infinite supply.
I’m leaning more towards IPSO and SUM
Nice quention, I'll follow the answers. Especially if there are any safety concerns. Since I know nothing about excel, I manually update the prices. I already have a setup w/ the coins I have, the amount I have of each, and the last price I checked. And than just =price*amount for each coin and the total =SUM(coin1:coin8)
Ergo is a hidden gem. ada and ERGO team are working together and it implements cross-chain functionality with COGITO and SUM. Once it gets listed on big exchanges ,it will hit higher prices
just use your logic ! 1) El Salvador president knew he had to buy BTC for months and give that to his people at the 30$ per person. 2) the day before he needs them, he starts buying 3) the day BTC becomes a legal tender, a flash crash happens of 20% around the crypto board. 4) IMF, Worldbank, and governments did want to stop El Salvador, but could not for the moment. 5) Binance and others announced from 100x leverage to 20x leverage and for higher net accounts that was only x4. = SUM of all, Binance and whales knew a fight would be coming and protected the downfall. Also, they pushed prices higher by increasing the short interest on BTC. the drop of today has international force behind to let the BTC El Salvador project fail and stop other countries from following the same road. THIS IS THE FIGHT OF CENTRALISED FIAT AGAINST DECENTRALISED CRYPTO AND IT JUST HAS STARTED. CRYPTO WILL WIN AT THE END.
# ideas ALWAYS VARY FROM ONE TO ANOTHER AND FROM PLACE TO ANOTHER ... IT IS FOOL IDEA TO THINK THAT RICH COMES FROM THE HUGE SUM OF MONEY HAD INVESTED .
well There's always 2 sides of a coin. everyday, we're being updated on liquidation n many readers commenting about "don't leverage" or something along that line. But we're forgeting that the whole day the crypto market is going down, So these liquidations seem to be on those who bet that market is going higher (or UP)... like what we all (hodlers) want... For our info, Exchanged traded derivatives especially, are ZERO SUM game. while these traders (bullish ones) lost hundreds of millions, there are corresponding traders (bearish ones) who benefit/profit from the lower markets.
A sad tale. But an instructive one. It would be nice if people took responsibility for their actions, particularly actions based on greed. The Market is a 0SUM game. In order to make money, someone else has to lose it. The Market is like a wrecking ball: a mechanism for squeezing the most money from the greatest number of individuals. You wouldn’t step into an octagon unaware, not expecting to have a rough time of it. Why would you get involved in a market that you weren’t aware that to get rekt was a possibility? 😳
I guess I'll just put on my lump sum helmet, jump into my lump sum cannon and fire myself to the lump sum bank to withdraw my lump sum and put it all on $LUMP the new community driven token on the SUM Blockchain
The SUM function of an excel spreadsheet doesn't care of it's one account or many causing a loss Banks are looking at crypto flight in the aggregate and it's that sum, and especially the trend, that's bothering them, enough to push for KYC laws on all DeFi. If they didn't care they wouldn't be trying to essentially break DeFi by imposing KYC on decentralized anonymous dApps
Check the last snapshot CSV- SUM em all together and divide by the column count.
This coin is gonna be so powerful when they implement cross-chain functionality with COGITO and SUM.
Looks like I should not have included the positive/negative sentiment's above. I scored those for each post. So if a post has 3 positive sentiments and 1 negative, it will score a 50% for that post. 1 positive sentiments and 3 negative a -50%. Etc. The sentiment score column is the Average sentiment score of the symbol (which is correct). The positive/negative scores are the SUM across the whole month. So positive/negative are mostly good just to see the individual post. But the Sentiment score is accurate since it is an average.
Elon MuskAFEE HAS SUM SPLAININ’ TO DO
I use Google sheets because it’s free. And super easy, no reason to make this complicated! Just do for example (A1) ETH (B1) =10.45+234.76+281.67 (amounts your invested) (C1) =(same as B2 but how much ETH you got for your money) =B1/C1 To add other currencies, do the same for rows 2,3,4 etc. To know your total invested amount, take the sum of column B. For example =SUM(B2:B12)
Who else has the problem of not able to resist buying in slightest dips when you have your salary in your account and not having a penny when the market goes down like this? Got my sal on 1st and spent 95% of it on cryptos before may 5th and couldn't buy anything during dip. **LESSON LEARNT! ** **NEVER LUMP-SUM INVEST. DCA IS THE WAY** **ALWAYS HAVE ATLEAST 35% OF YOUR INVESTMENT IN FIAT, YOU NEVER KNOW WHEN A GOLDEN OPPORTUNITY LIKE THIS COMES**
BEST WAY TO SUM UP CRYPTO RIGHT NOW? *Antiques Road Show price decrease noise*
Do you listen to yourself when you say dumb shit? BTC started alone so duh it was 100% and fucking DUH does it go down once more and more shitcoins with infinite supply and fake prices get added. That's the whole point of the shitcoiner that came up with the metric in the first place. SUM over daily growing shitcoin count(shitcoin price \* shitcoin coin supply) is going up... fucking DUH.
Dot1+dot2+dot3+... = SUM(Dot1:Dotn). There, hope that helps
Do you understand that IDC about percentages? I care about total gain. If I own 1 BTC and sell profit on it, I'm going to make more than if I own 1 dodge and sell profit on it. Why? Because again, BTC will move more incrementally larger in SUM than a smaller coin. Any smaller coin, I'm not just singling out dodge. And all this said BTC isn't my favorite coin lulz. I just make the most profit with it (because of above reason).
I'm (fairly) new as an investor. Long time listener, first time caller. When I started my strategy is was simple =SUM(HODL+DCA)... net effect? $$$$
You did fuck up bad. Not as bad as they guy who lost 30k (or was it 25k). Either way, from now on check a million times before sending. Some guy did suggest typing the hash into a cell in excel and then copy pasting the hash into another cell and then do a SUM of one cell minus the other. It should come out 0. However i dont use excel that much so i dont know if that'll work. Can someone correct me if i have it wrong.
Bossman's, whilst we're in the red - can anyone help me think of a modelling question for Excel? I'm teaching my dad how to use Excel, the real basics of how to prepare tables, +-\*/ cells, use SUM formulae and so on. My first question for him to crack was a "house building" example with like all the materials he will need and the cost per unit and so on. Allowed him to work out total costs then add in a mechanism for discounts/premiums. Anyone can think of another useful example that flexes basic Excel quite well?