This will be my last post of the year and I wanted to say thank you for all of your support. I’m so grateful for the conversations and all the business of course, but there’s so much more.
This year was not easy as I spent six nights in the hospital and took three months off work to heal from a really bad ulcerative colitis flare. I’m thankfully doing very well now and I’m happy. But I couldn’t have done this alone.
Thank you for the kind words, advice, flowers, meals, cards, prayer, and all the ways you showed support. I’m especially grateful to those who donated to the GoFundMe because it sustained my family and helped us pay off medical bills.
It might sound cheesy, but you carried me this year. And I will never forget that.
Merry Christmas. May you know profound joy and a deep-seated peace regardless of your circumstances or the craziness of 2020.
Much love,
Ryan Lundquist
——————- now a spreadsheet if that’s your thing ——————-
A SPREADSHEET FOR CHRISTMAS?
It’s not the new PlayStation, a leg lamp, or a Bob Ross chia pet, but it’s pretty cool even if it sounds lame. This spreadsheet will help you make quick neighborhood graphs and it can work anywhere as long as you can export data from your MLS.
What does it do? This spreadsheet makes ten or so visuals as I shared about last week. This is a tool to quickly understand a few neighborhood dynamics. This isn’t a template to find out exactly what prices are doing. It’s more about the relationship things like bedroom count or lot size has with price.
STEPS TO USE THE TEMPLATE:
1) Download the spreadsheet here.
2) Decide what data you want to show. It’s up to you.
3) Create a custom export in MLS (see how to video).
4) Paste data from MLS into the template (see how to video).
5) Share graphs on social media, newsletters, etc…
IMPORTANT NOTE: Metrolist updated all of their terminology since I made the video, so when you make the template for the spreadsheet as I show you in the video you’re going to have to figure out what the new terms are. For instance, instead of “Selling Price” it’s now “Buyer Price.” This template should work just as I show in the video, but you must tell MLS to export the correct categories.
HOW TO VIDEO:
I talk for ten minutes or so about how to use this template. If you have questions, let me know. Please call your MLS if you cannot figure out how to export though because that’s not something I can help you with. Watch below (or here).
NOTE ON DATA: It’s important to think about the data you use. It could be a neighborhood, zip code, or MLS area. You might use all neighborhood sales or maybe just a sliver such as 1400-1700 sq ft homes. I suggest showing maybe the past 90 days or 180 days of sales so we capture a recent trend (or maybe it’s useful to see one year of sales?). Remember, if there is too much data it’s going to look like chaos. In short, experiment and figure out what works.
FEEDBACK: I have lots of graph tutorials here, but I’ve never made a template like this before for the public, so let me know which visuals you like best and/or what might work better in the future. I’m open to doing more of these if there is interest and it’s useful. Just remember this template isn’t meant to do everything or dissect prices in depth, so please see it in context. Thanks.
I hope this is helpful. Thanks for being here.
If you liked this post, subscribe by email (or RSS). Thanks for being here.