Author |
Message |
otherbeach Samba Member
Joined: September 15, 2016 Posts: 281 Location: Illinois
|
Posted: Thu Oct 20, 2016 11:24 am Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
dawerks wrote: |
Can you also put 'days on market'?
I would discard anything that has been up for 2+ months or something arbitrary. Most of the buses in the classifieds are insanely priced and most of them don't move, but who knows right?
When I list a bus, I find a similar bus in the ads and list it for 1/3 of it, and it still takes a while to sell. I've sold everything from 23 Window's to Panels and they all sold for 1/2 to 1/3 of what's listed in the ads, but my location isn't the best and I don't mind giving a deal (I get them for cheap). I know if I hold onto a bus without working on it for a year, I'm not going to get around to it, so I move it on.
There is a TON of buses, just because they are listed here for stupid prices doesn't mean that is the only market for them. |
Actually that feedback helps! I can try and extract original listing date and maybe even update listing date, but that takes additional work. |
|
Back to top |
|
|
edgood1 Samba Member
Joined: September 30, 2004 Posts: 2049 Location: Plymouth, MA
|
Posted: Thu Oct 20, 2016 11:30 am Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
how are you extracting the data? manually?
I'm well versed at parsing web pages. I even have a little perl script that parses stuff from the samba classifieds... _________________ 1987 Syncro Westfalia powered by Subaru
1963 Panel to Deluxe Bus project :::: (photo album)
'65 Westfalia |
|
Back to top |
|
|
otherbeach Samba Member
Joined: September 15, 2016 Posts: 281 Location: Illinois
|
Posted: Thu Oct 20, 2016 12:03 pm Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
edgood1 wrote: |
how are you extracting the data? manually?
I'm well versed at parsing web pages. I even have a little perl script that parses stuff from the samba classifieds... |
I am a SAS programmer and use the XML feed. But your code might be interesting for someone else...I just dont do Perl. Nice offer though! It is essentially a parsing of HTML source, mostly XML. I dont use a XML Map, but should. This is one of my source URLs:
Code: |
filename sambaxml url
'http://www.thesamba.com/vw/classifieds/rss/search.php?type=text&stype=all&keywords=§ion%5B%5D=5&country=USA&wanted=hide&sort=date&sort_order=DESC';
|
|
|
Back to top |
|
|
otherbeach Samba Member
Joined: September 15, 2016 Posts: 281 Location: Illinois
|
Posted: Tue Oct 25, 2016 11:16 am Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
Thanks to those who support this "project". This is from the XML of the Type 2's found in Classified extract 25Oct16. I am continuously cleaning up the data extraction. There is now division by additional components like "Special Order" and "Westfalia". Model was cleaned up to be consistent with TheSamba's dictionary of models.
This is "Asking Price" not "Sale Price". I have not yet extracted Condition (1 to 5) from the descriptions.
Code: |
Lower Upper
Mean Std Dev Minimum Maximum Quartile Median Quartile
------------------------------------------------------------------------------------------------------------
31472.93 27632.11 0 170000.00 13500.00 25000.00 39500.00
------------------------------------------------------------------------------------------------------------
Summary Statistics 13:04 Tuesday, October 25, 2016 1
Results
The MEANS Procedure
Analysis Variable : askprice
yearis N Obs Mean Std Dev Minimum Maximum N
------------------------------------------------------------------------------------------------------
1950 1 19500.00 . 19500.00 19500.00 1
1953 3 57166.67 64777.18 6000.00 130000.00 3
1954 1 60000.00 . 60000.00 60000.00 1
1955 5 58000.00 21660.26 28500.00 74500.00 4
1956 4 56000.00 76161.01 12500.00 170000.00 4
1957 6 31083.33 19003.73 15000.00 65000.00 6
1958 7 24579.00 13035.47 7995.00 40000.00 5
1959 15 32851.00 36801.69 1600.00 149975.00 15
1960 24 31193.22 35112.61 1500.00 165000.00 23
1961 18 25501.89 18657.69 4750.00 65000.00 18
1962 25 28166.67 27757.33 3500.00 119900.00 24
1963 31 29440.35 23817.42 5000.00 90000.00 26
1964 27 38137.04 34992.44 4800.00 139000.00 27
1965 37 23511.26 14206.12 0 65000.00 35
1966 41 33849.87 25637.98 1200.00 105000.00 39
1967 39 28312.00 23156.01 3499.00 130000.00 37
1968 1 29200.00 . 29200.00 29200.00 1
1969 2 26850.00 25667.98 8700.00 45000.00 2
------------------------------------------------------------------------------------------------------
Analysis Variable : askprice
Model N Obs Mean Std Dev Minimum Maximum N
----------------------------------------------------------------------------------------------------------
Camper 37 26880.81 23763.00 3500.00 130000.00 37
Deluxe 40 47505.00 41189.50 5000.00 149975.00 35
Double Cab 20 36712.20 20054.86 0 68000.00 20
Kombi 13 34454.08 22423.34 6750.00 78000.00 12
Other 128 33355.97 28737.40 1200.00 170000.00 121
Panel 32 21317.26 18800.52 1500.00 74500.00 31
Single Cab 32 19937.76 12562.70 4800.00 60000.00 29
Standard 14 22283.33 12676.38 6500.00 55000.00 12
----------------------------------------------------------------------------------------------------------
Analysis Variable : askprice
SubModelW N Obs Mean Std Dev Minimum Maximum N
---------------------------------------------------------------------------------------------------------
NoWesty 5 25279.00 15197.79 6400.00 42995.00 5
Westfalia 20 34994.17 17622.87 7500.00 70000.00 18
---------------------------------------------------------------------------------------------------------
Analysis Variable : askprice
SubModel1 N Obs Mean Std Dev Minimum Maximum N
-----------------------------------------------------------------------------------------------------------
Caravelle 1 34500.00 . 34500.00 34500.00 1
EZ 2 36247.50 9542.41 29500.00 42995.00 2
Road Runner 1 13000.00 . 13000.00 13000.00 1
Sundial 1 6400.00 . 6400.00 6400.00 1
Westfalia 20 34994.17 17622.87 7500.00 70000.00 18
-----------------------------------------------------------------------------------------------------------
Analysis Variable : askprice
SubModel2 N Obs Mean Std Dev Minimum Maximum N
-----------------------------------------------------------------------------------------------------------
SO23 1 65000.00 . 65000.00 65000.00 1
SO34 4 34000.00 29698.48 13000.00 55000.00 2
SO42 9 21110.56 13176.47 7500.00 50000.00 9
-----------------------------------------------------------------------------------------------------------
Windows N Obs Mean Std Dev Minimum Maximum N
---------------------------------------------------------------------------------------------------------
11 Window 11 26718.18 18814.72 11000.00 71000.00 11
13 Window 10 23433.33 14305.68 5000.00 45000.00 9
15 Window 17 34210.00 29894.24 4750.00 119900.00 15
19 Window 1 13500.00 . 13500.00 13500.00 1
21 Window 25 59583.33 37229.22 0 139000.00 24
23 Window 15 82913.38 53102.78 20000.00 170000.00 13
---------------------------------------------------------------------------------------------------------
Analysis Variable : askprice
Brazil
Flag N Obs Mean Std Dev Minimum Maximum N
------------------------------------------------------------------------------------------------------
N 303 31666.41 27984.51 0 170000.00 284
Y 13 27246.15 18566.13 7400.00 71000.00 13
------------------------------------------------------------------------------------------------------
|
|
|
Back to top |
|
|
easy e Samba Member
Joined: May 28, 2008 Posts: 3931 Location: 1 hr north of Santa Barbara
|
Posted: Tue Oct 25, 2016 11:24 am Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
Looks like you're making improvements / progress.
A few thoughts...
I don't know what a 19 window is.
For 11 window... there's Standard (Deluxe interior) & Kombi (plain or no interior) models...
I see a Caravelle (UK thing)... make sure values reflect one currency.
The "condition" ranking is very often not accurate. Sellers think their bus fits in to a ranking... but often the vehicle does not meet the stated ranking criteria. _________________ aka: Evan
Spreadsheet for Bus RPM, based on gearing & tire size (Excel format)
Searchable, click-navigable 1958 Bus Parts List |
|
Back to top |
|
|
otherbeach Samba Member
Joined: September 15, 2016 Posts: 281 Location: Illinois
|
Posted: Tue Oct 25, 2016 11:44 am Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
easy e wrote: |
Looks like you're making improvements / progress.
A few thoughts...
I don't know what a 19 window is.
For 11 window... there's Standard (Deluxe interior) & Kombi (plain or no interior) models...
I see a Caravelle (UK thing)... make sure values reflect one currency.
The "condition" ranking is very often not accurate. Sellers think their bus fits in to a ranking... but often the vehicle does not meet the stated ranking criteria. |
I found the "19-Window" in https://www.thesamba.com/vw/archives/dic/
For "Caravelle" I didnt know that, but got this from http://www.thesamba.com/vw/classifieds/detail.php?id=1933906
My extract URL is for USA so 90% + get USD, but still good point.
If you think I should separate the 11-Windows, I can do so. |
|
Back to top |
|
|
easy e Samba Member
Joined: May 28, 2008 Posts: 3931 Location: 1 hr north of Santa Barbara
|
Posted: Tue Oct 25, 2016 11:59 am Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
otherbeach wrote: |
easy e wrote: |
Looks like you're making improvements / progress.
A few thoughts...
I don't know what a 19 window is.
For 11 window... there's Standard (Deluxe interior) & Kombi (plain or no interior) models...
I see a Caravelle (UK thing)... make sure values reflect one currency.
The "condition" ranking is very often not accurate. Sellers think their bus fits in to a ranking... but often the vehicle does not meet the stated ranking criteria. |
I found the "19-Window" in https://www.thesamba.com/vw/archives/dic/
For "Caravelle" I didnt know that, but got this from http://www.thesamba.com/vw/classifieds/detail.php?id=1933906
My extract URL is for USA so 90% + get USD, but still good point.
If you think I should separate the 11-Windows, I can do so. |
After poking around for a min... I see that Caravelle isn't a UK thing. I was wrong to say that. I just never paid that much attention to them, but see that description more commonly in UK ads.
19 window is a hack... not a factory model/option. They are so uncommon anyways... just consider them an outlier & discard the data.
There's enough of a difference inherent in "11 window"... suggest making two separate line items: Standard & Kombi _________________ aka: Evan
Spreadsheet for Bus RPM, based on gearing & tire size (Excel format)
Searchable, click-navigable 1958 Bus Parts List |
|
Back to top |
|
|
EverettB Administrator
Joined: April 11, 2000 Posts: 69827 Location: Phoenix Metro
|
|
Back to top |
|
|
Clara Samba Member
Joined: June 14, 2003 Posts: 12401
|
Posted: Wed Oct 26, 2016 8:23 am Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
EverettB wrote: |
easy e wrote: |
The "condition" ranking is very often not accurate. Sellers think their bus fits in to a ranking... but often the vehicle does not meet the stated ranking criteria. |
Agree |
I've always thought the condition rankings on the samba did not reflect old buses were well.
One rust hole and it is condition 4.
This SO-42 was condition 4, though presentable, and road worthy to drive anywhere:
To be condition 5, the bus must be complete. Oops, that ^^ bus was missing the spice rack and roof rack and side tent, so was incomplete. I guess it was condition 6.
Though many buses are missing a middle seat and I don't think that makes them a parts car.
I ignore the 'condition' choices offered. Maybe I should write up a version I think applies better.
Quote: |
Vehicle condition can be specified as follows:
1 - Excellent - A close to perfect original or a very well restored vehicle. Generally a body-off restoration, but a well done body-on restoration that has been fully detailed may qualify. The vehicle is stunning to look at and any flaws are trivial and not readily apparent. Everything works as new. All equipment is original, NOS, or excellent quality reproductions.
2 - Very Good - An extremely presentable vehicle showing minimal wear, or a well restored vehicle. Runs and drives smooth and tight. Needs no mechanical or cosmetic work. All areas (chassis not required, but may be) have been fully detailed. Beautiful to look at but clearly below a #1 vehicle.
3 - Good - Presentable inside and out with some signs of wear. Not detailed but very clean. Body should be straight and solid with no apparent rust and absolutely no rust-through anywhere. Shiny, attractive paint but may have evidence of minor fading or checking or other imperfections. Runs and drives well. May need some minor mechanical or cosmetic work but is fully usable and enjoyable as is.
4 - Fair - Runs and drives OK but needs work throughout the vehicle. Body shows signs of wear or previous restoration work. Any rust should be minimal and not in any structural areas. Cosmetics, body, and mechanics all need work to some degree.
5 - Poor - In need of complete restoration, but is complete and not a rust bucket beyond repair. May or may not run and drive. Not roadworthy.
6 - Parts or Salvage - Incomplete vehicle most useful for parts. |
_________________ The Obsolete Air-Cooled Documentation Project http://oacdp.org/ |
|
Back to top |
|
|
otherbeach Samba Member
Joined: September 15, 2016 Posts: 281 Location: Illinois
|
Posted: Wed Oct 26, 2016 8:33 am Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
In my opinion this is one of the most interesting tables in that reflects the number of days since advertisement was first placed. I dont capture updates or renewal dates. I included missing values this time...my dataset was 312 USA advertisements extracted 26Oct16. My extraction is Type 2s essentially pre-bay window. The number of records does not total 312 but that is my "universe".
Code: |
Analysis Variable : elapsed
Model N Obs Mean Std Dev Minimum Maximum N Median
--------------------------------------------------------------------------------------------------------------------------
Camper 34 148.0000000 205.0064686 2.0000000 735.0000000 24 64.0000000
Deluxe 36 132.4347826 136.1639473 4.0000000 462.0000000 23 97.0000000
Double Cab 19 279.9166667 426.1652386 13.0000000 1448.00 12 116.0000000
Kombi 14 199.7500000 332.3757555 12.0000000 1011.00 8 79.5000000
Microbus 13 206.0000000 140.8910420 32.0000000 380.0000000 8 188.0000000
Other 122 142.7974684 180.3575068 2.0000000 848.0000000 79 70.0000000
Panel 32 60.0500000 85.6783919 3.0000000 382.0000000 20 39.0000000
Single Cab 32 90.6818182 85.7029123 8.0000000 299.0000000 22 66.5000000
Standard 8 157.7500000 149.3371465 36.0000000 344.0000000 4 125.5000000
--------------------------------------------------------------------------------------------------------------------------
|
Last edited by otherbeach on Thu Oct 27, 2016 7:33 am; edited 3 times in total |
|
Back to top |
|
|
otherbeach Samba Member
Joined: September 15, 2016 Posts: 281 Location: Illinois
|
Posted: Wed Oct 26, 2016 8:40 am Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
This is an analysis on "self-reported" condition. As members have noted, this is very subjective! That is Asking Price in this table. I am treating condition as continuous as opposed to discrete.
Code: |
The MEANS Procedure
Analysis Variable : condition
Model N Obs Mean Std Dev N N Miss Median
----------------------------------------------------------------------------------------------------------
Camper 34 2.9166667 1.5012072 24 10 3.0000000
Deluxe 36 2.3478261 1.2652235 23 13 2.0000000
Double Cab 19 2.3333333 1.3026779 12 7 2.0000000
Kombi 14 2.3750000 1.0606602 8 6 2.5000000
Microbus 13 2.1250000 1.1259916 8 5 2.0000000
Other 122 2.5696203 1.3270707 79 43 2.0000000
Panel 32 3.4500000 1.4680815 20 12 4.0000000
Single Cab 32 2.5909091 1.0980108 22 10 3.0000000
Standard 8 2.5000000 0.5773503 4 4 2.5000000
----------------------------------------------------------------------------------------------------------
|
By contrast here is just price by condition.
Code: |
Analysis Variable : askprice
condition N Obs Mean Std Dev Minimum Maximum N N Miss Median
------------------------------------------------------------------------------------------------------------------------------------
1 48 60633.89 36605.20 19000.00 165000.00 45 3 50000.00
2 50 38164.09 18373.10 6200.00 90000.00 45 5 35000.00
3 53 25764.47 20429.33 8000.00 130000.00 47 6 19900.00
4 31 16753.13 14171.81 1200.00 80000.00 30 1 13499.50
5 12 7824.58 7773.03 3500.00 32000.00 12 0 5400.00
6 6 3199.00 979.9408145 1500.00 4500.00 6 0 3349.50
------------------------------------------------------------------------------------------------------------------------------------
|
and here is an odd one: Condition Reported in Advertisement by Model Year.
Code: |
The MEANS Procedure
Analysis Variable : condition
yearis N Obs Mean Std Dev N N Miss Median
------------------------------------------------------------------------------------------------------
1950 1 1.0000000 . 1 0 1.0000000
1953 3 3.0000000 1.0000000 3 0 3.0000000
1954 1 1.0000000 . 1 0 1.0000000
1955 5 3.0000000 . 1 4 3.0000000
1956 5 2.5000000 2.1213203 2 3 2.5000000
1957 6 2.0000000 1.4142136 2 4 2.0000000
1958 7 3.0000000 1.0000000 5 2 3.0000000
1959 14 2.2857143 1.3801311 7 7 2.0000000
1960 25 3.2666667 1.5796323 15 10 3.0000000
1961 17 2.9000000 1.3703203 10 7 3.0000000
1962 24 2.7500000 1.1832160 16 8 3.0000000
1963 32 2.3809524 1.2031704 21 11 2.0000000
1964 27 2.6875000 1.3524669 16 11 3.0000000
1965 34 2.2500000 1.0195458 20 14 2.0000000
1966 41 2.4482759 1.1827996 29 12 2.0000000
1967 39 3.0000000 1.4935760 27 12 3.0000000
1968 1 1.0000000 . 1 0 1.0000000
1969 1 1.0000000 . 1 0 1.0000000
------------------------------------------------------------------------------------------------------ |
Last edited by otherbeach on Wed Oct 26, 2016 12:46 pm; edited 2 times in total |
|
Back to top |
|
|
otherbeach Samba Member
Joined: September 15, 2016 Posts: 281 Location: Illinois
|
Posted: Wed Oct 26, 2016 9:38 am Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
And for Westfalia fans. A period means missing or not captured.
Code: |
-------------------------------------------------------------------------------------
| | SubModelW | |
| |--------------------------------------| |
| | | NoWesty | Westfalia | Total |
| |------------+------------+------------+------------|
| | askprice | askprice | askprice | askprice |
| |------------+------------+------------+------------|
| | Average | Average | Average | Average |
|-------------------------------+------------+------------+------------+------------|
|condition | | | | |
|-------------------------------| | | | |
|. | 28850.40| 13000.00| 34375.00| 29122.96|
|-------------------------------+------------+------------+------------+------------|
|1 | 62298.21| 34500.00| 38750.00| 60633.89|
|-------------------------------+------------+------------+------------+------------|
|2 | 38174.85| 42995.00| 36848.75| 38164.09|
|-------------------------------+------------+------------+------------+------------|
|3 | 25365.11| .| 34750.00| 25764.47|
|-------------------------------+------------+------------+------------+------------|
|4 | 16882.55| .| 13000.00| 16753.13|
|-------------------------------+------------+------------+------------+------------|
|5 | 7954.09| 6400.00| .| 7824.58|
|-------------------------------+------------+------------+------------+------------|
|6 | 3199.00| .| .| 3199.00|
|-------------------------------+------------+------------+------------+------------|
|Total | 32171.72| 24223.75| 34258.53| 32184.46|
-------------------------------------------------------------------------------------
|
Last edited by otherbeach on Wed Oct 26, 2016 12:38 pm; edited 1 time in total |
|
Back to top |
|
|
KevinAlbrecht Samba Member
Joined: March 07, 2002 Posts: 970 Location: Ocean City > Boca > Pompano > Kirkland > Eugene
|
Posted: Wed Oct 26, 2016 11:02 am Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
This is an interesting project. I am seeing what I can write in powershell. _________________ Kevin Albrecht
Wait, what...?
WideFive wrote: |
Single carbs are for lawn mowers! |
Don't forget those seat-belts!
Click to view image |
|
Back to top |
|
|
otherbeach Samba Member
Joined: September 15, 2016 Posts: 281 Location: Illinois
|
Posted: Fri Oct 28, 2016 5:21 pm Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
A Samba member asks: Is there a day of week when most advertisements are placed? The answer is no and interestingly enough, those Thursday "posters" open the most expensive advertisements!
Code: |
The MEANS Procedure
Analysis Variable : askprice
weekday N Obs Mean Std Dev Minimum Maximum N
-----------------------------------------------------------------------------------------------------------
1-Sunday 26 36408.64 36904.55 1500.00 139000.00 22
2-Monday 33 35041.57 28418.94 4500.00 149975.00 28
3-Tuesday 31 30264.63 31293.63 3499.00 165000.00 30
4-Wednesday 35 29558.79 24478.42 5000.00 95000.00 34
5-Thursday 25 44664.58 27031.59 12000.00 119900.00 24
6-Friday 24 25139.13 23448.26 1200.00 80000.00 23
7-Saturday 26 38636.67 32603.68 5800.00 130000.00 24
-----------------------------------------------------------------------------------------------------------
Cumulative Cumulative
weekday Frequency Percent Frequency Percent
----------------------------------------------------------------
1-Sunday 26 13.00 26 13.00
2-Monday 33 16.50 59 29.50
3-Tuesday 31 15.50 90 45.00
4-Wednesday 35 17.50 125 62.50
5-Thursday 25 12.50 150 75.00
6-Friday 24 12.00 174 87.00
7-Saturday 26 13.00 200 100.00
|
|
|
Back to top |
|
|
otherbeach Samba Member
Joined: September 15, 2016 Posts: 281 Location: Illinois
|
Posted: Mon Oct 31, 2016 11:37 am Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
If you are new to this topic, I extract the USA Type 2 classified advertisements via the XML feed, then match that back to the details on the advert to pick up date first posted and their self-reported condition (1 - 6).
This extract was from 30Oct16's data. The "askprice" is the advertisement's asking price in dollars. It is not practical at this time to obtain actual purchase price primarily because it is not reported.
I find the "elapsed" variable to be the most interesting since it shows how many days since the advert was placed (I do not capture updates).
It isnt perfect, but always interesting. I wont be posting weekly or anything unless there is interest in me doing so. I also take requests since I do capture Brazil vs. Non-Brazil, Westfalia vs. non-Westy campers, and adverts with number of windows like 21 Windows mentioned.
Code: |
The MEANS Procedure
Model N Obs Variable Mean Std Dev Minimum Maximum N Median
-------------------------------------------------------------------------------------------------------------------------------
Camper 34 askprice 26820.91 24770.32 3500.00 130000.00 33 20000.00
elapsed 148.00 205.01 2.00 735.00 24 64.00
condition 2.92 1.50 1.00 6.00 24 3.00
Deluxe 36 askprice 45009.38 36554.23 5000.00 139000.00 32 35250.00
elapsed 132.43 136.16 4.00 462.00 23 97.00
condition 2.35 1.27 1.00 5.00 23 2.00
Double Cab 19 askprice 36541.79 20589.53 0.00 68000.00 19 33000.00
elapsed 279.92 426.17 13.00 1448.00 12 116.00
condition 2.33 1.30 1.00 5.00 12 2.00
Kombi 14 askprice 32880.69 22205.58 6750.00 78000.00 13 29200.00
elapsed 199.75 332.38 12.00 1011.00 8 79.50
condition 2.38 1.06 1.00 4.00 8 2.50
Microbus 13 askprice 60556.25 54569.65 14000.00 165000.00 12 31400.00
elapsed 206.00 140.89 32.00 380.00 8 188.00
condition 2.13 1.13 1.00 4.00 8 2.00
Other 122 askprice 33150.63 26625.85 1200.00 165000.00 114 27747.50
elapsed 142.80 180.36 2.00 848.00 79 70.00
condition 2.57 1.33 1.00 6.00 79 2.00
Panel 32 askprice 21168.87 18817.53 1500.00 74500.00 31 15000.00
elapsed 60.05 85.68 3.00 382.00 20 39.00
condition 3.45 1.47 1.00 6.00 20 4.00
Single Cab 32 askprice 19882.59 12564.22 4800.00 60000.00 29 16995.00
elapsed 90.68 85.70 8.00 299.00 22 66.50
condition 2.59 1.10 1.00 5.00 22 3.00
Standard 8 askprice 19250.00 7394.25 6500.00 26000.00 6 20750.00
elapsed 157.75 149.34 36.00 344.00 4 125.50
condition 2.50 0.58 2.00 3.00 4 2.50
------------------------------------------------------------------------------------------------------------------------------- |
By vehicle date, notice two Brazil buses at end
Code: |
The MEANS Procedure
yearis N Obs Variable Mean Std Dev Minimum Maximum N Median
-----------------------------------------------------------------------------------------------------------------------------------
1950 1 askprice 19500.00 . 19500.00 19500.00 1 19500.00
elapsed 63.00 . 63.00 63.00 1 63.00
condition 1.00 . 1.00 1.00 1 1.00
1953 3 askprice 57166.67 64777.18 6000.00 130000.00 3 35500.00
elapsed 68.00 95.31 10.00 178.00 3 16.00
condition 3.00 1.00 2.00 4.00 3 3.00
1954 1 askprice 60000.00 . 60000.00 60000.00 1 60000.00
elapsed 119.00 . 119.00 119.00 1 119.00
condition 1.00 . 1.00 1.00 1 1.00
1955 5 askprice 58000.00 21660.26 28500.00 74500.00 4 64500.00
elapsed 43.00 . 43.00 43.00 1 43.00
condition 3.00 . 3.00 3.00 1 3.00
1956 5 askprice 44780.00 67580.08 4900.00 165000.00 5 17000.00
elapsed 42.50 38.89 15.00 70.00 2 42.50
condition 2.50 2.12 1.00 4.00 2 2.50
1957 6 askprice 31083.33 19003.73 15000.00 65000.00 6 25250.00
elapsed 147.50 108.19 71.00 224.00 2 147.50
condition 2.00 1.41 1.00 3.00 2 2.00
1958 7 askprice 24579.00 13035.47 7995.00 40000.00 5 27000.00
elapsed 131.20 220.12 2.00 522.00 5 55.00
condition 3.00 1.00 2.00 4.00 5 3.00
1959 14 askprice 32343.93 38136.50 1600.00 149975.00 14 22250.00
elapsed 150.14 94.49 51.00 289.00 7 175.00
condition 2.29 1.38 1.00 4.00 7 2.00
1960 25 askprice 33347.67 36093.54 1500.00 165000.00 24 21750.00
elapsed 44.13 34.23 3.00 96.00 15 43.00
condition 3.27 1.58 1.00 6.00 15 3.00
1961 17 askprice 26207.88 18980.81 4750.00 65000.00 17 20000.00
elapsed 133.80 129.93 11.00 382.00 10 99.50
condition 2.90 1.37 1.00 5.00 10 3.00
1962 24 askprice 29000.00 28072.52 3500.00 119900.00 23 20000.00
elapsed 105.50 107.22 2.00 387.00 16 67.50
condition 2.75 1.18 1.00 5.00 16 3.00
1963 32 askprice 28844.19 24009.08 5000.00 90000.00 26 18500.00
elapsed 243.57 359.15 2.00 1448.00 21 91.00
condition 2.38 1.20 1.00 5.00 21 2.00
1964 27 askprice 38100.00 35023.33 4800.00 139000.00 27 28000.00
elapsed 173.94 252.91 14.00 1011.00 16 65.00
condition 2.69 1.35 1.00 5.00 16 3.00
1965 34 askprice 26043.56 17021.94 0.00 75000.00 32 25500.00
elapsed 113.70 111.91 11.00 404.00 20 70.00
condition 2.25 1.02 1.00 4.00 20 2.00
1966 41 askprice 33040.66 25681.57 1200.00 105000.00 38 24250.00
elapsed 177.66 199.93 4.00 651.00 29 104.00
condition 2.45 1.18 1.00 5.00 29 2.00
1967 39 askprice 29190.38 24482.51 3499.00 130000.00 37 25000.00
elapsed 109.67 157.82 7.00 848.00 27 67.00
condition 3.00 1.49 1.00 6.00 27 3.00
1968 1 askprice 29200.00 . 29200.00 29200.00 1 29200.00
elapsed 59.00 . 59.00 59.00 1 59.00
condition 1.00 . 1.00 1.00 1 1.00
1969 1 askprice 45000.00 . 45000.00 45000.00 1 45000.00
elapsed 179.00 . 179.00 179.00 1 179.00
condition 1.00 . 1.00 1.00 1 1.00
----------------------------------------------------------------------------------------------------------------------------------- |
|
|
Back to top |
|
|
otherbeach Samba Member
Joined: September 15, 2016 Posts: 281 Location: Illinois
|
Posted: Wed Nov 16, 2016 6:41 am Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
A little discussion about Brazil buses lately. I pulled an extract on 14Nov16. When you see numbers like $165000 this may be a data error on my part.
Code: |
Analysis Variable : askprice
Brazil
Flag N Obs Mean Std Dev Minimum Maximum N N Miss
----------------------------------------------------------------------------------------------------------------------
N 283 32169.08 27842.48 0 165000.00 264 19
Y 11 31145.45 17630.85 7400.00 71000.00 11 0 |
Here are the overall numbers from this extract.
Code: |
Analysis Variable : askprice
Model N Obs Mean Std Dev Minimum Maximum N N Miss Median
----------------------------------------------------------------------------------------------------------------------------------
Camper 30 23608.45 16969.60 3500.00 60000.00 29 1 20000.00
Deluxe 34 41561.67 32673.44 6000.00 139000.00 30 4 29250.00
Double Cab 20 35514.70 21255.44 0 68000.00 20 0 31250.00
Kombi 13 27445.83 19459.46 5000.00 70000.00 12 1 22500.00
Microbus 15 55175.00 55160.09 8000.00 165000.00 13 2 22500.00
Other 113 34913.26 27400.64 1600.00 165000.00 107 6 28000.00
Panel 34 24670.76 21305.73 1500.00 74500.00 33 1 15000.00
Single Cab 28 19318.76 13454.60 4500.00 58000.00 25 3 14900.00
Standard 7 19000.00 7569.68 6500.00 26000.00 6 1 20750.00
----------------------------------------------------------------------------------------------------------------------------------
|
|
|
Back to top |
|
|
otherbeach Samba Member
Joined: September 15, 2016 Posts: 281 Location: Illinois
|
Posted: Sat Nov 19, 2016 9:05 pm Post subject: Re: Has anyone collected price history or seasonal trends data |
|
|
23 Window sold tonight 19Nov16 at Mecum's live auction (I think it was live...)
1958 sold for $106,000
Here is current asking prices for TheSamba.com's 23 Windows:
Code: |
Analysis Variable : askprice
Windows N Obs Mean Std Dev Minimum Maximum N Median
-------------------------------------------------------------------------------------------------------------------------------
23 Window 10 98375.00 51549.24 20000.00 165000.00 . 85000.00
------------------------------------------------------------------------------------------------------------------------------- |
and they are all in wonderful condition apparently....
Code: |
Analysis Variable : condition
Windows N Obs Mean Std Dev Minimum Maximum N
---------------------------------------------------------------------------------------------------------------
23 Window 10 1.8750000 1.1259916 1.0000000 4.0000000 8
--------------------------------------------------------------------------------------------------------------- |
|
|
Back to top |
|
|
easy e Samba Member
Joined: May 28, 2008 Posts: 3931 Location: 1 hr north of Santa Barbara
|
|
Back to top |
|
|
otherbeach Samba Member
Joined: September 15, 2016 Posts: 281 Location: Illinois
|
Posted: Sun Nov 20, 2016 2:54 pm Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
I have not filtered clones, thanks for the suggestion. I will have to code for that |
|
Back to top |
|
|
easy e Samba Member
Joined: May 28, 2008 Posts: 3931 Location: 1 hr north of Santa Barbara
|
Posted: Sun Nov 20, 2016 3:11 pm Post subject: Re: Has anyone collected price history or seasonal trends data? |
|
|
Not sure how the coding goes... but it probably won't be as easy as searching for "clone."
Clone sellers often want to practice their wordsmithing. I've seen stuff like....
"This exemplary 21 window started it's life as a Deluxe."
"This beautiful 23 window creation..."
"The top of this genuine German Deluxe has been fully reworked, with new seals, glass, sunroof mechanism, etc..."
You'd probably have to actually read each ad. Sometimes it's not what is said or shown in the ad... but what's NOT shown / said.
These might be a little sticky... more so than seller reported condition.
But, if someone's trying to sell a clone for genuine article money... I guess it doesn't skew anything. _________________ aka: Evan
Spreadsheet for Bus RPM, based on gearing & tire size (Excel format)
Searchable, click-navigable 1958 Bus Parts List |
|
Back to top |
|
|
|