Not an accountant, so if I get it wrong someone please correct me. But index fund shares are an asset: something you own. So is your car, your house (if you own it), and your computer. When you buy an asset, you paid a certain price for it. When you sell it, you pay a different price. Until you sell it, though, you don't actually have the money, so it hardly matters what its value is until you sell it. If you buy $100 of an index fund and a year later it has grown by 10%, you don't actually have $110 yet until you sell it. So you just track that you have a certain number of shares of the fund. Let's say each share sells for exactly $20 when you bought them, so you have exactly 5 shares. Later the share price is $22, but you don't have $110 yet, you still have exactly 5 shares. When you sell them, then you'll have $110.
So you record two entries:
January 1st, 2025:
-$100 checking account
+5 shares VFINX at $20 ea
January 1st, 2026:
-5 shares VFINX at $22 ea
+$110 checking account
At this point you have "realized" ("made real") $10 of profit from this asset. You bought it for $100 and sold it for $110, so the IRS wants you to pay taxes on the $10 profit you made. (This is capital gains tax). Until you sold them, some people would consider you to have $10 profit in "unrealized capital gains", but you did not actually have that profit until you sold the shares. This is important to remember, because if you start counting on that $10 profit but then the share price drops because the economy took a hit, suddenly you don't have $110 worth of shares, you have $90 worth of shares, and you'll make a loss if you sell them now. (This is one of the reasons why only the economically illiterate would propose a tax on "unrealized capital gains": that means taxing people for income they have not actually received, but merely could theoretically receive. Which is both immoral and stupid.)
Hope this explanation helps a little. And as I said, if I got something wrong, please correct me and explain how I was wrong; I'm not an accountant. I understand the basic principles, but it's entirely possible I was off on some detail or other.
A fancy term of art for all this is "cost-basis accounting". Your (double entry) account tracks only the cost basis (how much you have spent and when you spent it for what commodity) not the current price. Current price fluctuates with the market and you can track the price as well to build an unrealized gain/loss statement. This sort of statement is not an account, it's a report on an account. (And yeah, "unrealized" means what it says that it isn't real money in your accounts, just money you potentially could make if you sold/converted/traded what was in your accounts.)
> (This is one of the reasons why only the economically illiterate would propose a tax on "unrealized capital gains": that means taxing people for income they have not actually received, but merely could theoretically receive. Which is both immoral and stupid.)
But your statement misses the important point of situations where people use the unrealized gains as collateral for a loan which they then use (for example to live off of). This in fact effectively "realizing" them without paying appropriate taxes on them. As long as gains are purely theoretical and not used for any transactions they should remain untaxed. As soon as they become "active" by being sold, or for example in unlocking additional assets by being collateral for a loan, they should be taxed.
Same concept as a retirement account. You can sell within a retirement account and rightfully don't have to pay taxes because you don't really have "access" to the cash. It's still "locked" within the account. Only when you withdraw to have access to it and make it active/real do you pay taxes. But if you take out a large loan leveraging that retirement account as collateral (or against an unrealized gain) you are not making it active and correctly should pay taxes.
If it's a loan, it must be repaid. At that point, the debtor is going to either sell some stocks, thereby actually acquiring real income (and paying capital gains taxes), or use some other source of cash and not touching the stocks. In the former case, he will pay tax on that income at the time when he actually sells the stocks. In the latter case, he paid taxes on that cash at the time when he received it as income, so it's already been taxed and shouldn't be taxed twice. (Which is why inheritance taxes are immoral — they're double-taxation — but that's a totally separate subject).
As for retirement accounts, same principle applies. Collateral is collateral, it's a contingency. It might or might not ever be touched. If it's touched, then there will be real income involved. If it isn't touched, then there was no income.
But as for the idea of paying taxes on things used as collateral for a loan, that only makes sense if you consider money received as a loan as income. And if you do, you're going to get yourself in serious trouble. LOANS ARE NOT INCOME. They have to be repaid, and they actually cost you money in the long term because you also have to pay interest. If you treat loans as if they were income, you'll quickly find yourself neck-deep in credit card debt and in serious financial trouble. On the other side of the equation, if the IRS were to treat loans as if they were income and tax them (or the collateral used to secure the loan), they would do immense damage to the economy.
I feel I should also mention one more thing. The fact that you don't have the money until you sell the shares is also why "net worth" can be a highly misleading concept. (All numbers in the following example are fictional and made up on the spot, BTW). Billionaire Gill Bates, whose net worth is reported to be $20 billion, does not actually have 20 billion dollars. He has $5 million (million, not billion) of actual dollars in his bank account(s), but the rest of his net worth is in assets: he owns 200 million shares of MegaSoft Corp, whose share price is currently $100 per share. If MegaSoft Corp's shares suddenly drop in value (say, because a hacker group announces that MegaSoft's Doors 12 OS is full of, well, backdoors and suddenly nobody wants to buy it anymore) and now their shares are selling for $90, then Gill Bates's net worth will become 18 billion dollars instead of 20 billion. Did he "lose" 2 billion dollars in one day? NO. He never had those dollars. The "net worth" calculation is just the theoretical amount of money he could make if he sold all his shares.
And in fact, he could never actually make that amount of money by selling all his shares, because if he did put 200 million MegaSoft shares on the market, he'd never be able to find buyers for all of them at the current share price, and he'd be forced to drop his asking price by quite a bit before he managed to sell all 200 million shares. Not to mention the fact that if he tried to sell his entire holdings of MegaSoft Corp, many people would wonder what he knows about MegaSoft's long-term prospects, and would be afraid to buy those shares, driving the share price down even further. Gill Bates would be lucky to make $5 billion, let alone his theoretical net worth of $20 billion, if he were to suddenly sell all his shares. (If he sold them in a trickle over the course of ten years, he might well make the full $20 billion in the end, but not if he dumped them all on the market at once).
This is why (well, it's just one of the many reasons why) net worth is misleading. It's a theoretical number, but the actual amount of wealth someone has in practice entirely depends on market conditions at the moment they need the money, as well as how urgently they need it. (If the market is low right now, can they afford to wait six months for it to recover? Or do they need the money tomorrow and have to sell at a lower-than-ideal price?)
Net worth is the denominator for things that people actually want to, which typically don’t require converting it all to cash at once. For example, pulling 4% of your net worth per year is one way to fund a retirement. So you won’t know if you’re ready to retire unless you’re tracking net worth.
For very rich people like Gill Bates, net worth is going to be the denominator for massive loans, tax strategies, and corporate maneuvering. Again, none of that will require converting the entire net worth to cash all at once. That doesn’t mean it’s not real.
Finance is a complex subject, sure, and it gets more complex the bigger the numbers. That doesn’t mean it’s misleading.
Accounts (in the accounting sense) are unitless, and refer to whatever meaning we ascribe to them, so we can transfer value from $ to shares, or USD to GBP or whatever.
Lalit describes this I think really well in his article
I use the Raycast + Whisper Dictation. I don't think there is anything novel about it, but it integrates nicely into my workflow.
My main gripe is when the recording window loses focus, I haven't found a way to bring it back and continue the recorded session. So occasionally I have to start from scratch, which is particularly annoying if it happens during a long-winded brain dump.
This reminded me of this passage from Anxiety Is the Dizziness of Freedom by Ted Chiang:
> None of us are saints, but we can all try to be better. Each time you do something generous, you're shaping yourself into someone who's more likely to be generous next time, and that matters.
The soul takes on the color of its thoughts - Marcus Aurelius. In context, he wrote about the reams of thoughts that fly in our heads and how we automatically rubber stamp most of them as "true".
User Defined Functions (UDFs) are another option to consolidate the logic in one place.
> Using Functions on Indexed Columns
In other words, the query is not sargable [0]
> Overusing DISTINCT to “Fix” Duplicates
Orthogonal to author's point about dealing with fanout from joins, I'm a fan of using something like this for 'de-duping' records that aren't exact matches in order to conform the output to the table grain:
ROW_NUMBER() OVER (PARTITION BY <grain> ORDER BY <deterministic sort>) = 1
Some database engines have QUALIFY [1], which lends itself to a fairly clean query.
I have an iPhone SE 2nd Generation. After a recent repair I was forced to upgrade to iOS 26.
My biggest gripe is the buggy keyboard. It shrinks a bit horizontally every time I open it. When using a mobile browser (I tested on a few), website footers and similar elements will get stuck above where the top of the keyboard would normally be, as if there was an invisible keyboard.
These tweaks to minimize the glass effect go a long way, such that I'm not as put off by the overall design as I was in its stock configuration.
I was hoping for more of the author’s own perspective over those ninety years. Instead, it read more like a stitching project of other people's ideas. In particular the barrage of quote fragments disrupted the flow and made it harder for me to engage with the main point of each section.
It is often the case, that one’s perspective is a personal synthesis of external ideas. The act of quoting great past authors is also a way of recognizing where your influences come from. To describe by association how you think, or aspire to.
These are very difficult topics to properly talk about and correctly express all the nuance in the feeling that you try to convey, and many authors are quoted because they nailed a particular description, evocative of the feeling an author is trying to express and that he feels he can’t do a better job at explaining.
Similarly to how you can narrate a story through a sequence of pictures you can narrate an idea through a sequence of raw concepts, encapsulated in quotes.
I have never seen this behavior on macOS and doesn’t make sense. However, some applications will save files by creating a copy and overwriting. Maybe that’s what the author experienced?
I really liked the display showing me climb the leaderboard in realtime. I found it particularly motivating, albeit a bit distracting for a game where I need to keep my eyes elsewhere :)
reply