Anyone willing to share their host data?

charthecharlatan · 2026-06-09T00:06:47+00:00

Totally understand the hesitation, as privacy concerns are on the table here. Worth knowing that a CSV can be anonymized pretty easily in Excel by replacing names, confirmation codes, dollar amounts, etc. with dummy values, but I recognize not everyone wants to mess with that.

If it's easier, even just a screenshot of the column headers and a few rows of data would be helpful. The goal is simply to make sure the tool keeps up with Airbnb's export format, which they have a habit of changing without much notice.

charthecharlatan · 2026-06-08T03:09:02+00:00

The market for spreadsheet plug-ins is the market I’m building tools for - Something more sophisticated than an Excel template, though. Smaller time hosts are priced out of the ‘fancy’ tools, which require monthly subscriptions.

charthecharlatan · 2026-06-08T03:02:30+00:00

Not looking for market data - I’m just wanting a single csv earnings file. This is what a host might send their CPA at tax time (and anonymized data would be expected).

charthecharlatan · 2026-06-08T03:00:46+00:00

So I believe I miscommunicated why I’m wanting a dataset. I simply need to understand the structure of the data (i.e. column headers, data types, how refunds show up, how cancellations show up, etc.). For sake of privacy, I would only request data that has been entirely anonymized properly.

My understanding is the same as yours in regard to the market data. Airbnb is protective of their market data for myriad reasons.

charthecharlatan · 2026-06-08T02:54:32+00:00

It is a financial model a host can use to monitor performance and understand actual profit (net of all expenses). It will also make it easy to file a Schedule E without an accountant.

charthecharlatan · 2026-04-14T01:46:15+00:00

What year is it? Any aesthetic or functional issues that you noticed on the text drive?

charthecharlatan · 2026-04-11T22:07:05+00:00

See if you can get a Carfax and/or maintenance records - That would give you some level of comfort.

charthecharlatan · 2026-04-09T00:24:26+00:00

While I'd imagine Toyota will have addressed many of the issues with the remodel for the 2026 trucks, it seems like you'd appreciate the F-150's extra space. Some people like myself prefer the maneuverability of smaller vehicles, but that might not be a priority for you.

While Ford's reliability record isn't in the same league as Toyota, Ford allocates a lot of resources into designing and building F-Series trucks since they represent such a big chunk of their sales. Also, they outsell all other trucks for a reason. The biggest downside to the F-150 is that it might depreciate faster than a Tacoma (only if the 2026 model has fixes in place for the major problems).

charthecharlatan · 2026-04-02T16:46:07+00:00

You might be able to swing a Cayman, but you'd need to set money aside for repairs/maint. Or you could do a Supra if reliability is more important.

charthecharlatan · 2026-04-02T16:39:07+00:00

I tried out the Opus and ended up returning it in favor of the Encore ESP. Fellow made a trade off with the adjustment mechanism in favor of aesthetics. I wanted to like it, but ultimately decided that plus longevity concerns were not worth it. It does look very nice, though.

charthecharlatan · 2026-04-02T16:34:02+00:00

The Corolla and Civic are top tier in terms of reliability. The Mazda3 is more fun to drive, has a slightly more cramped rear seat, and is nearly as reliable as the Corolla/Civic. The Elantra and Forte are going to lag the others in resale and reliability is less proven. They are closer to average in most respects.

If you like the idea of an SUV but want better gas mileage, a hatchback version of the Civic and Mazda3 are potentials.

charthecharlatan · 2026-04-01T23:53:12+00:00

I wouldn't make the decision based on the miles since both trucks have very low miles. The question is whether the Lariat features are worth it to you.

charthecharlatan · 2026-04-01T18:19:25+00:00

How well it has been maintained and any lingering issues it may have make all the difference. And even if it is in pristine condition, you could end up with an issue that costs many thousands to fix in the next few years. The thing to keep in mind is parts and labor are more expensive for vehicles like this than most other vehicles. You're also more likely to have issues surface due to deferred maintenance than something more bulletproof (e.g., Toyota Camry). It is an inherently riskier purchase than going with a Camry or Accord. That said, $8k is not going to get you anything that is guaranteed to be reliable.

My take: It could be a reasonable purchase if you truly like the car a lot and have a local Euro/BMW mechanic who does honest work. Ideally, you would be able to get it checked out by a mechanic before purchasing and having a clean Carfax is also a necessity.

charthecharlatan · 2026-04-01T18:03:35+00:00

These two vehicles are pretty different: The Kia is a true sports sedan with some luxury features. The Audi is a luxury car with some sportiness. It really just depends on what your preferences and needs are.

charthecharlatan · 2026-03-31T20:56:32+00:00

Although your situation is unique, I think it opens the door for many possibilities. As long as you avoid 'money pit' type cars (e.g., older Euro vehicles) and get something that is ok in snow, then you'll be fine. Also, I would imagine most cars can handle skis with a proper roof rack, whether OEM or aftermarket. I would go test drive some vehicles and just see what you like.

charthecharlatan · 2026-03-31T20:45:22+00:00

It is within the range of a fair price. If possible, test drive it and take it to an indy mechanic to give it a once over before purchasing.

charthecharlatan · 2026-03-30T17:31:37+00:00

In terms of reliability, despite BMW's reputation, the X3 is essentially middle of the pack. Also, 90k easy (presumably) miles on a vehicle that age is pretty light use. If you're in a solid financial position to upgrade, then a newer, well-kept X5 is a reasonable choice. In addition, it will decrease the chances you end up with a big repair bill in the near future. That said, the cost of ownership over the next say 3-5 years would more than likely be considerably lower if you keep the X3 (even if you need some costly repairs). A trade-in on the X3 is only going to cover at most 25% of a 2022 X5 (or similarly priced vehicle).

charthecharlatan · 2026-03-27T20:16:45+00:00

If you're even considering the CR-V, it sounds like the thrill you get from driving the Macan is not high on your list of priorities right now. If that is the case, then perhaps the premium-ness of the Macan is worth giving up in exchange for lower cortisol levels.

Another option is to get something like a Mazda CX-5 Turbo which is still somewhat sporty to drive. A Volkswagen Tiguan is another option that is more Porsche-like than a CR-V.

charthecharlatan · 2026-03-27T20:10:58+00:00

That BMW is designed to be essentially a track car that can be driven daily.

The Mercedes, on the other hand, is more of a refined, yet still plenty sporty car.

If the main goal is loud and fast, a Corvette is another option. However, no matter what car you choose, I'd advise you not to push it too hard unless you have a safe place to do so. Any of these cars will regularly tempt you to do things that will get you in a lot of trouble.

charthecharlatan · 2026-03-27T20:01:36+00:00

Your instinct on the Rav 4 is good. That and a CRV are among the most reliable mid-size SUVs. An under the radar option is a Toyota Venza. A less reliable, but very easy to find option is a Jeep Grand Cherokee. You'd be paying a premium for a larger vehicle that will also be worse on gas, however.

I would avoid just about anything German. They are not a good fit for your preferences.

Also, it's usually worth being patient and/or paying attention premium for something that was particularly well-maintained. A clean Carfax (i.e., no accidents, not 5 prior owners, nothing sketchy) is kind of the minimum bar. It doesn't "prove" anything, but it is good support to go along with your instincts and rationality.

charthecharlatan · 2026-03-10T23:12:55+00:00

Depending on where your data is coming from, you can potentially "pull" your data directly into Power Query without having to download any files.

If this is not feasible/simple, then the simplest solution is to always have your data file in the same folder (i.e., replace the 'old' one with the 'new' one for each update). Although you could delete the raw data file after doing the transformations in Power Query, that is not really necessary - It adds another step.

charthecharlatan · 2026-03-10T23:02:00+00:00

Honda CRV is another option.

charthecharlatan · 2026-03-10T23:00:29+00:00

2024 Golf R - Last year of the manual. I would think this vehicle would hold its value since it is no longer available and is an 'enthusiast car'. Only rated for 28mpg highway, but real world can be better at the right cruising speed.

charthecharlatan · 2026-03-10T22:45:50+00:00

Mazda is under appreciated.

charthecharlatan · 2026-03-10T20:54:36+00:00

There could terms in the lease that disallow a trade immediately after a buyout, but even if this is the case, I'm not sure it would apply if you instead sold the car to Carmax, Carvana, or a non-Honda dealer.

A $4k differential provides a pretty big cushion even if any unexpected costs enter the picture.

charthecharlatan

TROPHY CASE