Rock and roll

A few years ago I went through a phase of putting on shows. I might still be in that phase, actually, we’ll see what happens this year. But anyway, I did some events. One was a bike polo tournament with a party after. Two were alleycat races, both with a show after. The last was a small polo tournament, on a weeknight and no party.

Understand that when I say “I” put these events on, all I mean is that I took part the financial risk and the blame, and did a little organizing. In every case, stuff like this happens with an army of volunteers, many of whom have very small jobs (bring the coffee urn, unlock the doors for us, something like that), but without whom the event could not occur. Every time I run an event and it works, it’s because a few people decided they wanted it to happen, and I got volunteered to coordinate. I love it, but I can take very little credit.

By far my favorite job is handling the bands. I get to choose an act, book them, negotiate a fee, transport their equipment and possibly their bodies, make a speech about how awesome they are, pass the hat, give them drinks. For a few moments there, I let my imagination run away with me.

I know everyone daydreams, it’s a part of being human. I think I’m the only one, though, who writes down my juvenile fantasies and publishes them where everyone I know can see and feel awkward about my oversharing, and tries to get more people to read it.

In this fantasy I’m a rock and roll promoter. I never got good enough at music to be the star of a band, but I get to have a little bit of reflected glory this way. I put on events every week, I have an entourage that I roll with. When I’m looking for a band, I get put on the list at clubs, get sent to the VIP room to watch the show, and listen to the band kiss my ass after they play. “Sure, you’ll do,” I say, and turn them over to my assistant to work out schedules and details, after offering them a fee that makes them stop talking for several moments.

This is a job I could do. It’s one that really appeals, because it doesn’t rely on asking some boss if I can make a living, please. One guy with the power to grant or revoke an entire salary with a single decision. My boss in real life is rad, but even so, I don’t like it. Instead I put on a dope party and everyone who shows up gets one seven-dollar vote as to whether the band and I get to eat this week. Democracy.

But reality is very different from my daydream. Not so much with the VIP room, more like texting a drummer 4 times to ask whether they can do Saturday night, and calling 5 different bands before I find one that can play. Never mind if they’re good or not. If they show up on time and sober, they’re hired. This operation can’t afford “good” yet.

Instead of hundreds of party animals lined up out the door, it’s more likely to be like alleycat #2 – the venue didn’t bother to promote it, we picked the wrong time of day, and only seven racers showed up. The band nearly outnumbered the audience, and although their professionalism was outstanding, they didn’t get paid well at all.

Sometimes you don’t win. Oh well. The lesson I got was that any time you have a little power, it’s not because you wrest it from the ground and compel legions with the force of your personality. Rather, it’s because the community has seen that you’re competent and willing, so they give you some resources which you’re expected to use in their service.

I’m still trying to figure out how I can live that life of service, and get the little bit of power I crave. Working at a job is not too bad, but 8 hours in the office slip away unnoticed, and then I have the whole evening and weekend to do real living. I am not interested in Game of Thrones. I don’t care for video games. I want to build stuff. Still looking. I’ll let you know how it goes, especially the flaming disasters.

 

What cars are hot in Victoria?

I just got back from a month abroad, and I wonder if I’ve forgotten how to code. I ask around the office, how has it been? Did anything break while I was away?

Not only did nothing break, my boss was so bored that he’s been bothering the office manager and taking extra days off. I should probably investigate and find out what his deal is, but first I have a burning question.

What cars sell quickly on the used car market in Victoria, and what do they sell for?

This info is available through UsedVictoria – kind of. They have an RSS feed. So you can enter some search terms and they’ll show you the last 25 items posted with those criteria. You can’t page through the results, so that doesn’t give me any historical data. Any info I gather will start from today. But I can scrape the feed and save it in my own database, and graph it later once I have a body of data. Ok, here we go.

What’s going on: we ask UsedVic’s server for all the car ads they have with the following criteria: private sales only, priced between $400 and $6000. This returns a few hundred results, but the RSS feed will only give us 25. Oh well. I save each item in my database – the title, description, search criteria, date it was posted, and price.

The price, mind you, is in no way accurate. When I buy a car on UsedVic, I haggle. People who buy from me usually try to haggle as well. So the actual selling price is likely a couple hundred lower than what’s listed, in most cases. However, it does give you a little information. The listed price is the starting point of negotiation, so people generally won’t go see a car unless the listed price is at least in the realm of reality and their budget. If someone has set the price of a vehicle unrealistically high, the car will sit on the market for a long time.

This happened in the case of a rather spectacular Suzuki DRZ400SM that was posted last winter. It had several fancy racing upgrades, combined with an expensive but utterly tasteless metallic pink paint job. If I could have had that bike for $2000, I would have done so in a second even it was covered in swastikas and cocks. Paint is cheap. But the guy wanted $6500 for it, and the ad stayed up for something like 3-4 months. (Ask me how I know. Yes, I was checking every week. I have a problem. Don’t worry about me, mow your own lawn.)

So how to deal with the fact that we only get 25 items returned? Easy – check back every 2 hours. Usually 2-6 items are posted per hour. So I add a check to see if each item is already in my database, and if it isn’t, add it. This code is kind of inefficient. If any of the real programming nerds get hold of it, I will be embarrassed. But it’s good enough for my purposes, for now, probably.

So I wrote a cronjob to run this every 2 hours and report back to me when it’s done. Okay, cool.

Now how do we track items that are sold? It’s tough to count something that isn’t there. Not too tough though. More code:

You can also search for an ad using the exact title, and you’ll generally get back only that one exact result. Since I have the titles saved, I can do that. In my database, I have a column labelled “sold”. When the item is entered, that column is set to false.

This script gets a list of all items in my database that have “sold” set as false, and searches for them. If an item is not found, “sold” gets set to true, and the current date is recorded as well.

Listings expire after thirty days, which should help keep this script from getting out of control as it hits the UsedVictoria servers over and over again. After a few weeks, I’ll have hundreds of unsold listings in my database, and once a day, the script will request every single one of them. I may end up blocked by UsedVic pretty soon if the numbers get too high. But no worries for now.

Finally, I want the data in a manageable, bite-sized format. You can see the results at rocketships.ca/srs/scraper.

The table lists all cars that were posted and sold within the last thirty days, the number of days each was on the market, and the price requested. It’s still not as fine grained as I would like, but I think this will give me at least a vague answer to my question – which cars are hot in Victoria?

My theory: Miatas. I await hard data.

Next step is to decide what to do with the data. I had an idea about buying cars from the mainland, where they’re a bit cheaper, and flipping them locally. I feel like I could make a small profit doing this. However, to make it worth my time, I need a profit of at least $300 – that’s what I pay myself for working on the weekends.

So let’s say I bought a 1990 Miata for $1800 on the mainland and sold it for $2300 here. Those numbers are realistic, based on my experience to date.

I have to go the mainland ($18 there, $74 back), get my pedestrian ass to the seller’s house somehow (unless they’re kind enough to meet me at the ferry), check the car to make sure it isn’t shit (Honestly, what do I know? Not much, man. I’m a writer, not a mechanic.), and then the really fun part – figuring out insurance.

If I transfer my own car insurance to the new car, I will have to pay GST on the car. 12% of 1800 is $216. Big chunk of my profit gone right there. I can maybe get a temp permit, which is only $30 or so, but then I really have to get home smartly on the next boat, I don’t get to joyride the car while I’m waiting for a seller, and I can’t allow buyers to take a test drive. The insurance costs some money, so does registration, so does the plate if I haven’t organized that properly, and you have to pay a fee if you insure for less than a full year or if you want to pay monthly. Costs maybe $1200 for the full year? depending on the car and whether my points have expired yet.

There are ways around these issues, namely, lyin’ and breakin’ the law. I’ve bought and sold something like 20 vehicles over the years, and I will not claim perfect observance of the rules. But any business plan that relies on illegal behaviour is a bad idea, and out of the question according to my principles.

So out of $500 profit, I might get to keep $300, legally. But that’s not the main issue. You can only get away with buying and selling a certain number of cars per year before the government starts to get suspicious. I think it might be around 6. After that you have to get a dealer’s license, which is ex$pen$$ive. I’m not really prepared to go down that road – messing around with cars is alright for a hobby, but used car salesmen are considered the scum of the earth by most humans, and for good reasons. So I would have to find a way to respect myself for doing it, first. My friend Dylan does it by specializing in high end racecars. My friend Ben doesn’t do used cars – he’s an honest to god legit new car salesman who provides warranties. But there are others who are pretty slimy.

With that problem unsolved, I have made the data and the code publicly available. Enjoy.