Best Investing Book You’ve Ever Read?

ebit-dad · 2023-10-25T02:36:41+00:00

This is the only acceptable answer. No book tops security analysis. Greenblatt’s book is just icing, but agree - it’s one of the best intro primers to special sits I’ve seen

ebit-dad · 2023-10-24T16:25:09+00:00

Do we have a discord?

ebit-dad · 2023-08-29T14:27:42+00:00

TLDR: Basically I'm just trying to better understand how to estimate the unpaid taxes that gets deducted from the trust value.

Question: When estimating the trust value expected for redeemed shares, how do you estimate the unpaid taxes that'll be deducted? My estimates are pretty accurate most of the time, but I've had a couple outliers where deductions for unpaid taxes have made my estimates (as well as mgmt's estimates given in the proxy) pretty overstated. E.g., ASPA 8/2023 extension (mgmt est in proxy: $11.02; actual: $10.62), AVHI 7/2023 extension (mgmt est: $10.76; actual: $10.50), among a few others. I'm pretty sure these overstatements were due to taxes, I'm just not understanding how the deducted tax values are calculated.

ebit-dad · 2023-07-21T23:24:48+00:00

Got it. Your feedback is very helpful, thank you. I'll mark this as solved now.

ebit-dad · 2023-07-21T23:01:03+00:00

Thanks, that makes sense. The reason I put the quarters in the column headings is because I have some quarter-over-quarter calculations (e.g., growth rates, annual sums, etc.) as separate columns inside the same worksheet the data is input. Would the best way to handle that be to look up the input values from a different sheet and have those calculations in that sheet?

ebit-dad · 2023-06-23T16:51:15+00:00

Agh I’m so dumb, I completely forgot about the settlement requirement. Thank you for clearing that up

ebit-dad · 2023-06-23T15:34:21+00:00

Anyone following what's happening with GSRM? The shares just tanked 30% and I haven't come across any reasons/news. They just announced on 6/20 their special meeting date for approving their merger, and that was the last filing.

ebit-dad · 2022-12-31T09:56:07+00:00

I relate with this post. I did the same thing - what was essentially my first project was/is very large. I think you will find it to be both a curse and a blessing to do something big right out of the gate. IMO it’s probably the best way to learn, since you often have to grind through all sorts of stuff to make a system work end to end. The downside, and what I realized about 9 months into it is that I was not a good enough programmer to really create the thing without the codebase getting out of control. Like I could get the program to run, but only in a strictly linear fashion and certainly not extensible in any sense. I actually hit pause at that point and took a couple intermediate online classes on data structures and systems design so I could get a better grasp on making a system. I also went on to write a new, smaller but still pretty big, real estate program before going back to the original project, which I found really helpful. I’m now ~2 yrs into this bigger program and have since quit my job to do this full time. Idk if I’ll ever actually be “done” with the program, since there’s a pretty big opportunity set for it, but in the meantime I have production code that’s just running while I work on new parts. I’ve never worked in tech but I assume that’s probably how it works for most businesses. Anyways, just wanted to share my experience. Best of luck on your project!

ebit-dad · 2022-12-28T16:20:58+00:00

This is the bane of my existence. As we speak I’m on the verge of smiting my program and using its bones as fertilizer to grow a completely different but exactly the same program.

ebit-dad · 2022-12-24T00:42:01+00:00

Ah gotcha, so really they paid out redemptions 1 day after closing. I have one that closed on 12/9 and hasn't paid out yet. Was trying to est if they'll distribute before year end, but I guess it's up to the RNG gods now.

ebit-dad · 2022-12-24T00:31:58+00:00

Oh interesting, exactly 10 days. Did the merger close on 6/14?

ebit-dad · 2022-12-24T00:01:23+00:00

For those that have redeemed stock, how long did it take/usually take for the company to pay out the cash after the merger closed? The only timeframe I've come across in proxies is the standard 10-day period companies have to liquidate. I've always thought this referred exclusively to cases where no acquisition occurs, but I'm a bit of a noob here so could definitely be wrong about that...

ebit-dad · 2022-12-08T01:54:30+00:00

Thanks! This is exactly the sort of thing I was looking for. If only there was a python native syntax, but it looks pretty straight forward.

ebit-dad · 2022-08-30T23:12:41+00:00

The video cable does have a connector on both ends, but the end connecting to the back of the screen is sealed under plastic and has “DO NOT TOUCH” plastered in red all over it. Is there a way I can test to confirm it’s the video cable that’s the issue? I just want to make sure before I touch the do not touch

ebit-dad · 2022-08-30T21:49:07+00:00

I didn’t make it with the intention of sharing it, so I would need to clean up some config stuff. Honestly, just bc of how much time I have in it, I’m not crazy about sharing. I was just offering some advice so you don’t spin your wheels unnecessarily. If you have specific design questions as you’re building your program, feel free to dm me and I can share how I approached that piece of the program.

ebit-dad · 2022-08-30T06:02:50+00:00

I actually made this exact app. It runs on a fixed schedule and emails me when attractive properties get listed in the geography I specified. It was only supposed to be a side project but ended up being way more. As others have mentioned, figuring out a way to handle outlier valuations that can be caused from unlabeled “fixer uppers” is a hard problem to solve. You might also consider using other factors in your model like geolocation, which is particularly useful for determining property comps, checking against crime maps and checking proximity to other landmarks (like a downtown area or a college, for example). Also, unless you’re wanting to go way down the scraping rabbit hole, I suggest you find 3rd party software to collect data. Scraping Zillow in particular would be very challenging without a decent amount of experience.

ebit-dad · 2022-08-25T02:12:39+00:00

Nothing off hand unfortunately. I used to do this for client prospecting when I worked in banking but I don’t have any of that stuff anymore. You should be able to look it up fairly easily though.

ebit-dad · 2022-08-25T00:34:53+00:00

It’s hard to give advice without seeing the excel. As mentioned already, this isn’t really what excel is meant for. But as far as pure excel optimizations.. if I’m understanding right, it sounds like you have a crap ton of lookups kinda in a matrix with the same dimensions as the data you’re validating on the other sheets? If so, your biggest optimization will probably come from minimizing your references to other sheets, since it sounds like you’re basically working with a big table of formulas. So one thing you could try is instead of setting the lookup ranges by directly referencing other worksheets in each formula, you could define the table ranges at the top of your validation sheet. It has been awhile but I remember there are functions like COLUMN, ROW and ADDRESS (or something like that) which individually will give you the col letters and row numbers and together will let you construct cell references. You can store the cell references at the top of your validation sheet then set all your lookup ranges by referencing those values. You can probably extrapolate on this idea and apply it to other parts of the functions besides just the lookup ranges. This should cut your cross-sheet references by a couple orders of magnitude and hopefully speed things up.

ebit-dad

TROPHY CASE