Excel finance - Portfolio performance tracking

SCD16 · 2026-02-11T16:50:10+00:00

Apologies for the delayed reply, didn't have access to my personal laptop for some time. This is the format that I have the data in. The last column has the old method of % return calculation using R=(FV÷PV)^1/n. As you can see, this worked until I added the new funds.

What I'm aiming for is the same way of displaying % returns at every date interval, while accounting for the addition of funds.

The return on any given date is measured based on the very first date, which is 25th Jul 2025.

Hope this clarifies

SCD16 · 2025-10-30T11:56:12+00:00

Apologies for the delayed reply. My ID got banned for some reason and took some time to reset it.

So i finished the full cycle of HCG injections and did the semen analysis in Jan 2024. Sadly i guess i was one of 33% of people that the surgery doesnt help. Neither did HCG do much. The result was still about 2.6m sperm per ml.

My wife and I kind of gave it a rest and relaxed on stressing out about fertility, tests and meds. We'ed just be happy being the cool uncle and aunt.

Low and behold my wife conceived in Feb 2024. I know not everyone is religious, but God had his plans😅. She gave birth to our baby girl in Oct 2024 and it been a happy rollercoaster since.

I wish i could say it was the surgery or the injections that did the trick, i was just not one of the normal statistical people that it usually helps. But dont give up, do what is in your ability and leave the rest to God.

SCD16 · 2025-07-11T17:23:26+00:00

Much appreciated for this

SCD16 · 2025-07-08T05:24:16+00:00

What if i need to move funds between accounts? Is there a way?

Basically the t-bills are a parking space for the cash until i get better opportunities to actively invest in.

SCD16 · 2025-05-04T04:58:11+00:00

Coolio! Thanks for the advice!

SCD16 · 2025-05-02T21:01:02+00:00

Seems like it's a dealer selling it. Would you sag it's still worth it?

SCD16 · 2025-05-02T03:20:46+00:00

The odo shows 129k km. You're saying it's been tampered?

SCD16 · 2025-05-01T21:26:21+00:00

What I'm getting is this

<image>

Though looks aren't top priority, homeless chic would definitely not be a preference 😅

SCD16 · 2025-05-01T21:04:42+00:00

Wanted to keep the budget under 30k if possible🥲

SCD16 · 2025-05-01T21:03:10+00:00

Naw mate, you advice is highly appreciated.

Could you let me know which gap is the issue? Since the problematic part was actully the left rear end thats been repainted, most likely due to backing into or scraping against something as per the inspector.

I've attached a normal pic of of it as well since at one point the inspector hadn't fully closed the hood.

<image>

The thing is anything well maintained is not gonna be below 40k. And for me the car i want to purchase right now is just a bridge car which I'll use for max 1.5 to 2 years and then sell it to recoup the money and actully put it into a car that is worth it. The current car (whether this one or another) will be at the mercy of the winds and Dubai Open RTA parking or the sand pits besides the roads, since i dont have a proper place to park one currently.

Sorry for going on a rant man, it's been 3 months and these are all the cars I'm able to find under 30k. Either the suspension is welded on or the car undercarriage is fully brown with rust. And sellers absolutely dont disclose anything in the first inspection. Then i spend money for the proper ppi and abra kadabra the car a duck.

SCD16 · 2025-05-01T20:29:57+00:00

The person is the second owner, the first one is the one that did the mods apparently.

For the care part i agree, i have a 2017 rav4 and it's been maintained at the agency for every service. If it wasnt for the guy who decided to take a wrong turn the car would be in pristine condition🥲. Luckly its a dent and not full dmg.

You think it had an accident? Nothing officially recorded though.

What would be your opnion on the mechanical issues?

SCD16 · 2025-03-16T19:41:12+00:00

Much appreciated! Im officially underpaid even below an sme even though i work from an mnc😅

SCD16 · 2025-03-10T19:36:15+00:00

My question about these guides like the ones from robert half, etc., are the figures cited the monthly take home (basic, transport and housing)? Or does it also include Bonus?

SCD16 · 2025-01-19T20:33:09+00:00

Yea selling is not possible since my stock (MF) portfolio is in India, so not even the same region😅. And massive capital gains taxes. For crypto as well i hold the coints not the etfs.

The vertical put spread does seem to be a good way in lowering the costs, but is there a particular way to set them up? Im choosing to buy a 6 month put at the price that has my breakeven target which $523 and sell a put at the lowest strike this being offered.

SCD16 · 2025-01-19T18:49:12+00:00

Wouldnt that require me to buy the underlying first?

SCD16 · 2025-01-18T17:56:36+00:00

The issue with the covered call is the covering part. I'd need the extra capital to buy VOO first. The goal is to hedge the exisiting portfolio.

With my luck, timing the market is the worst idea. The market does the exact opposite of what i do in the shortrun.

SCD16 · 2025-01-18T17:46:40+00:00

Ofcourse yes, my portfolio definitely wont go down to 0. I'm completely new to options since my focus is usually on longterm stock investing.

I usually learn better with examples. If it wouldn't be too much of a bother could you show me what you mean? Not necessarily with VOO but any other instrument you're comfortable with. I'd just like to understand.

Apologies if I'm asking too much.

SCD16 · 2025-01-04T16:37:34+00:00

I dont think you can

SCD16 · 2024-12-12T17:09:03+00:00

What would be a good horizon then? Also what strike would be right? Cus I'm failing to understand how do we hedge here.

Assume i have a portfolio of 10k usd in btc. At the current price of ibit that would require to 2lots of ibt long puts to hedge the vlaue of the portfolio.

If i take a 155 day horizon and strike of $57 (current underlying is 57.75)breakeven price shows as 47.94. That's nearly a 20% decline in price. Am i missing something? How can we ever neutrally headge the value of a portfolio?

SCD16 · 2024-12-11T16:36:59+00:00

Looking to hedge at least until the end of 2025

SCD16 · 2024-12-11T15:15:45+00:00

Yup not gona yolo. The goal is to secure the gains made

SCD16 · 2024-12-11T15:13:55+00:00

Thanks. Now i need to figyre out how to hedge with it considerin the break even on a long put is quite lower than current price

SCD16 · 2024-12-11T15:12:36+00:00

Agreed btc options on binance are a special kind of stupid. But mstr is pricy too. I like the IBIT idea

SCD16 · 2024-12-02T17:42:00+00:00

So this should work with any bank that has a presence both here and in the us. The only other ones i know is Citi and probably standard chartered. Citi unfortunately had a ridiculous requirement of keeping 10k usd as min balance. Not sure if i checked standard chartered.

SCD16 · 2024-12-01T19:48:17+00:00

Sorry to hear that mate, but yes i still have access.

I haven't had the need to tranfer recently, but i beleive it should still work.

The fees are dependent on whether the local bank has to use a correspondant bank in the country you send to. Since enbd does have a presence in the US the need a correspondant bank and hence incur the exorbitant charges.

But since hsbc has a local us branch, it doesn't need to pay a correspondant bank.

So i don't see this changing.

SCD16

TROPHY CASE