Tracking All Evo Listings in The USA From Facebook Marketplace
#1
Newbie
Thread Starter
Tracking All Evo Listings in The USA From Facebook Marketplace
The Google Sheets spreadsheet
The dashboard to filter and see market trends
A form to add listings you found
If there's something I like looking at other than Evos it's the Evo market.
I was already looking through the market on a daily basis so I thought it would be a good idea to properly track it and share the results. I'll keep this sheet updated for the foreseeable future since I haven't seen something like this for any other car.
I'll try to post monthly graphs and stats in the comments.
The dashboard to filter and see market trends
A form to add listings you found
If there's something I like looking at other than Evos it's the Evo market.
I was already looking through the market on a daily basis so I thought it would be a good idea to properly track it and share the results. I'll keep this sheet updated for the foreseeable future since I haven't seen something like this for any other car.
I'll try to post monthly graphs and stats in the comments.
Last edited by Tameed; May 25, 2023 at 06:17 PM. Reason: Adding new and important information that should be at the top
The following 10 users liked this post by Tameed:
damstr (May 30, 2023),
DontStopMe (Oct 19, 2023),
fid (Apr 6, 2023),
Pilosalas (Nov 21, 2023),
redSLed (Apr 4, 2023),
and 5 others liked this post.
#2
Evolving Member
Thanks for taking the time to do this!
#4
Newbie
Thread Starter
Sale price? Yes.. to an extent. I'll be checking off the 'Sold' checkboxes for the Evos once a month since posts that say they are sold tend to stay up for ~6 months. The problem comes when Evos are sold but instead of the seller marking the post as sold they just delete the post, no way to really check those except for going through each link and checking if the post still exists, but even then we don't know if the seller actually sold it or not.
I checked out the other thread, thought about posting the sheet there but I didn't want it to be buried!
#6
Newbie
Thread Starter
I wish. There are a couple of problems that get in the way...
- Facebook doesn't allow web scraping and if you try the possibility of getting banned is high, so I can't have a scraper go through and find the postings for me.
- The archiving platform I'm using can archive Facebook posts but doesn't have an API available yet.
- The one part I can automate is basic information like year, model, location, miles, color, but that takes 10 seconds to do manually so not really worth it
- information on the body parts is typically only shown in the pictures, can't automate that.
- information on performance parts is way too diverse. Postings could have the info in the pictures or post details, and the actual info itself is either the full name of the product and the part, just the part that was modified, the product name only, or abbreviations of the part of product name.
All this to say, it's manual right now.
- Facebook doesn't allow web scraping and if you try the possibility of getting banned is high, so I can't have a scraper go through and find the postings for me.
- The archiving platform I'm using can archive Facebook posts but doesn't have an API available yet.
- The one part I can automate is basic information like year, model, location, miles, color, but that takes 10 seconds to do manually so not really worth it
- information on the body parts is typically only shown in the pictures, can't automate that.
- information on performance parts is way too diverse. Postings could have the info in the pictures or post details, and the actual info itself is either the full name of the product and the part, just the part that was modified, the product name only, or abbreviations of the part of product name.
All this to say, it's manual right now.
#7
First, good job on the research. However, I have a few suggestions...
What it appears you are trying to accomplish is tracking values of Evos, which the traditional market book-values are not doing well with. If that is the case, here is my suggestions:
- Only record "sold" values, or the "final Asking price" listed.
- "Asking" prices are great, but actual "Transaction" prices are what really matter. That's why it's easiest to watch the Bringatrailer.com stats, and what I tried to accomplish on the original thread I created called 06 Evo Values.
- If you are documenting vehicles from one site, Facebook Marketplace, you should document all major 3rd Party Used Car Listing sites: Cargurus.com, Autotrader.com, Cars.com, Carfax.com, Truecar.com, Edmunds.com, Ebay.com, and Bringatrailer.com. Additionally, you may want to watch for outliers at Hagerty.com, Hemmings.com, Mecum, Barrett, Sothebys, etc... Also, don't rule out Manheim Auction Transactions... Every now and then, one gets sold there.
- You may want to just really dial-in your Google Sheet, then open it up to allow anyone to add to it. That way, you don't have to have the burden of this project all on your own. If you did that, you could have separate Tabs for each Model Year and Trim Level. If you set up the sheet correctly, it could calculate the Averages each time a new car is added, and give a sort of real-time average value. This is basically what Manheim's Market Index does for Auction transactions.
Hopefully, this is helpful. I have been in the car business for 20 years, and the Evo is hands down my absolute favorite car of all time.
What it appears you are trying to accomplish is tracking values of Evos, which the traditional market book-values are not doing well with. If that is the case, here is my suggestions:
- Only record "sold" values, or the "final Asking price" listed.
- "Asking" prices are great, but actual "Transaction" prices are what really matter. That's why it's easiest to watch the Bringatrailer.com stats, and what I tried to accomplish on the original thread I created called 06 Evo Values.
- If you are documenting vehicles from one site, Facebook Marketplace, you should document all major 3rd Party Used Car Listing sites: Cargurus.com, Autotrader.com, Cars.com, Carfax.com, Truecar.com, Edmunds.com, Ebay.com, and Bringatrailer.com. Additionally, you may want to watch for outliers at Hagerty.com, Hemmings.com, Mecum, Barrett, Sothebys, etc... Also, don't rule out Manheim Auction Transactions... Every now and then, one gets sold there.
- You may want to just really dial-in your Google Sheet, then open it up to allow anyone to add to it. That way, you don't have to have the burden of this project all on your own. If you did that, you could have separate Tabs for each Model Year and Trim Level. If you set up the sheet correctly, it could calculate the Averages each time a new car is added, and give a sort of real-time average value. This is basically what Manheim's Market Index does for Auction transactions.
Hopefully, this is helpful. I have been in the car business for 20 years, and the Evo is hands down my absolute favorite car of all time.
Trending Topics
#9
Newbie
iTrader: (2)
Serious props to you sir!!
We greatly appreciate the efforts you have already made and for sharing your work. evoixde is on the right track too in suggesting getting to the point where this can be more of a crowdsourced tool, rather than a significant solo project. That said, I get that it may be a bit of a labor of love too. That is why this old dude still has his Evo 8 that I bought back in 2003 when they were fresh on the streets of the US. I am still crazy about these cars and like to keep up on things like pricing so I can one day tell the ol' wife, "I told you so!!!" LOL
Keep up the great work Tameed.
We greatly appreciate the efforts you have already made and for sharing your work. evoixde is on the right track too in suggesting getting to the point where this can be more of a crowdsourced tool, rather than a significant solo project. That said, I get that it may be a bit of a labor of love too. That is why this old dude still has his Evo 8 that I bought back in 2003 when they were fresh on the streets of the US. I am still crazy about these cars and like to keep up on things like pricing so I can one day tell the ol' wife, "I told you so!!!" LOL
Keep up the great work Tameed.
#11
Evolving Member
Excellent work. Echoing evoixde - the car's selling value is pretty key in the market. Ever since that Hagerty article I've watched the "sold for" prices start to do the R34 / A80 Supra thing (not that extreme... yet, anyway).
Great stuff.
Great stuff.
#12
Newbie
Thread Starter
Hi guys, I made a couple of changes since originally making this.
- Due to popular demand I've added the ability for anyone to add any listings they found via a form here and at the top of this thread
- I've added a work-in-progress dashboard to filter out and see the actual data here and at the top of this thread
- Created a tool for myself to automate scrapping the data off of Facebook marketplace listings and have it added to the sheet with the essential data checked off. This will result in more up-to-date data and way less work for me. The tool also creates an archive of the listing on Imgur.
I was slacking off in April (as you could tell by the large gap of missing listings) but things should run more smoothly from now on.
- Due to popular demand I've added the ability for anyone to add any listings they found via a form here and at the top of this thread
- I've added a work-in-progress dashboard to filter out and see the actual data here and at the top of this thread
- Created a tool for myself to automate scrapping the data off of Facebook marketplace listings and have it added to the sheet with the essential data checked off. This will result in more up-to-date data and way less work for me. The tool also creates an archive of the listing on Imgur.
I was slacking off in April (as you could tell by the large gap of missing listings) but things should run more smoothly from now on.
The following users liked this post:
deylag (May 26, 2023)
#13
Evolved Member
iTrader: (23)
This is a good thing because I have called out a couple individuals already for buying Evos and adding in an Adjusted Owner Markup (+10-15K) and trying to resell them. By tracking old listing prices hopefully this will facilitate better decision making when people are interested in buying Evos.
#14
Man these things are selling for more than what I bought it for brand new back in 2007. Thats freakin nuts. You guys thing the prices will ever go down? Its the only thing keeping me from buying a new one.