Best Lease Car Deals (Data Edition)

[JaredVannett]

Latest Data

August 2018 Dataset #3 - Best German Execs

A general overview of current deals on German Executive vehicles:

AUDI A4
AUDI A5
AUDI A6
BMW 3 SERIES
BMW 4 SERIES
BMW 5 SERIES
MERCEDES C-CLASS
MERCEDES E-CLASS

Link: https://docs.zoho.com/file/99qs78507d06f0793445b98...

(Models split onto separate worksheets)

Commentary: Overall prices remain even across all brands, quite unusual given how competitive this sector usually is.
Those expecting pre WLTP bargains may be disappointed, at least 6 of the cheapest E-class deals have already gone.
Perhaps September will yield some bargains.

---

This thread serves as a supplement to the main leasing deals thread found here:

https://www.pistonheads.com/gassing/topic.asp?h=0&... (vol 6)







Purpose
The purpose of this thread is share datasets on the various leasing deals currently in the market.
The main leasing thread above is still the best place for finding the latest 'flash' leasing deals.
Every fortnight I'll post a list of datasets (spreadsheet) that contain the most recent leasing deals on various makes in the market.
This will continue up until December 2018 where we can evaluate if it's been useful.


What's in the dataset?
The dataset will be in the form of a spreadsheet listing leasing deals for a given make/model.
However, you will only see the cheapest deal for each model/trim (unique).

For example... If there are 25 deals on the web for the 'BMW 320d M-Sport Touring', you'll will see only 1 deal in the spreadsheet and this will be the cheapest found.

Each deal includes the total cost over the term and an amortised figure.
Terms are 24 month only (This is the prefered lease term for most on PH).


Who's this for?
It's for everyone, however those who like dealing with stats are likely to find these datasets useful if not for historical pricing.
For example, you may find what you think is a great deal from the main leasing thread, and then use these spreadsheets to compare against other makes/models to determine if the value is good.


How do I view/download it
Click on the links supplied to view an online version of the sheet. I recommend downloading the Excel file and using that... sometimes the 'deal links' are not clickable through the web version!

Note: I will likely remove old datasets, so please download your own copies if you would like historical records.


Limitations

• As mentioned earlier, the main leasing thread is the go to for the latest flash deals. Every fornight new datasets will be posted, but as the days go by the leasing market will move and the deals listed may no longer be valid.

• There is a limited data source, I have plans to expand this but will wait for a review in December 2018.

• It isn't feasible at this stage to get datasets on every make and model, so instead I will alternate between different makes/models every fortnight.

Edited by JaredVannett on Thursday 2nd August 15:35

Edited by JaredVannett on Monday 13th August 12:50

Edited by JaredVannett on Monday 13th August 12:51

Edited by JaredVannett on Monday 13th August 12:51

Edited by JaredVannett on Monday 13th August 19:44

Edited by JaredVannett on Wednesday 22 August 20:33

Edited by JaredVannett on Wednesday 22 August 20:41

Edited by JaredVannett on Monday 27th August 11:54

[JaredVannett]

August 2018 Datasets #1

Audi A4:
https://docs.zoho.com/file/8icwsb53b92efbc484f55aa...

BMW 3-SERIES:
https://docs.zoho.com/file/8icws0a9aeb5a729d4da991...

MERCEDES-BENZ C-CLASS:
https://docs.zoho.com/file/8icws6d1fe24bfc394ff28d...


Enjoy

Edited by JaredVannett on Thursday 2nd August 15:36

[b19rak]

Great job, thank you.

[sdpoo]

This will be fantastic. Are you manually maintaining it, or have you written some kind of web crawler?

Thanks

[fizz47]

This is excellent - thank you

[Shiv_P]

That's amazing
Have you thought about putting filters on the excel sheets?

[nunpuncher]

You're either very clever or you have too much spare time.

[JaredVannett]

Thanks for the kind words

sdpoo said:

This will be fantastic. Are you manually maintaining it, or have you written some kind of web crawler?

Thanks

I have some tools to help automate things, but the real clever stuff is getting all the data together and performing complex queries so that we're left with the good stuff.

I interact with the data through other tools, not Excel. The data is copied to Excel so that it can be shared with everyone.
The Excel sheets are not maintained, I'll always publish new files for the 'latest' data.

If you want to download the Excel file, just click on File > Export As > Excel Workbook.

Shiv_P said:

That's amazing
Have you thought about putting filters on the excel sheets?

Indeed. I originally thought I'd leave it to users to do, but then realised perhaps not everyone will know how.

It is possible for me to apply filters to the online sheet, however you won't be able to use them because ZOHO won't allow it in read-only mode.

You'll need to download it:

FILTERING



Download the workbook:

• Load up one of the Excel worksheets from the links above.
• Download the file by clicking on File > Export As > Excel Workbook.
• Open the file in Excel on your computer.

Create Filters:

• Select column A and then drag all the way to column Q
• Once selected, from the toolbar click Data > Filters
• Done - you should now be able to filter each column as needed.

Note: I've added filters to some of the sheets above so you won't have to create them.

nunpuncher said:

You're either very clever or you have too much spare time.

Well to be honest this is a lot more 'fun' than my usual game of scrabble.

[Sc0tchland]

Yes this is exactly what I need!

[loofer]

JaredVannett said:

August 2018 Datasets #1

Audi A4:
https://docs.zoho.com/file/8icwsb53b92efbc484f55aa...

BMW 3-SERIES:
https://docs.zoho.com/file/8icws0a9aeb5a729d4da991...

MERCEDES-BENZ C-CLASS:
https://docs.zoho.com/file/8icws6d1fe24bfc394ff28d...


Enjoy

Edited by JaredVannett on Thursday 2nd August 15:36

Great work. Only suggestion I would make is perhaps combine into one file.
If you’re in market for any of above three examples then you’re likely to consider at least one of the other two.
People can always filters, as discussed already.

Moving forward, maybe even have the historical ones on separate tabs in same file or all archived into one separate file.

[JaredVannett]

August 2018 Dataset #2 - Best Large SUVs

A general overview of current deals on large SUVs:

• Audi Q5
• Audi Q7
• BMW X3
• Jaguar F-Pace
• Land Rover Discovery
• Range Rover
• Skoda Kodiaq
• Volkswagen Touareg
• Volvo XC90
• Volvo XC60

Link: https://docs.zoho.com/sheet/open/60cie3477322cab1e...

(Models split onto separate worksheets)

[morfmedia]

If you could add on the Nissan X-Trail as well that would be awesome.

Great scripting skills and a real time saver for the rest of us

[Dyslexicwinker]

Appears leasing.com don't have the Santander deals anymore? pretty sure I was quoted £543 on an XC90 T5 8k which is about £600 cheaper than your spreadsheet but fantastic resource. Kodiaq is dirt cheap.

[theoriginalpaul]

This is fantastic - really useful and way beyond my primitive IT skills, so thanks for taking the time to share.

If it's not too cheeky, any chance you could add BMW X5, RR Sport and Velar?

Thanks again

[Merp]

JaredVannett said:

August 2018 Dataset #2 - Best Large SUVs

A general overview of current deals on large SUVs:

• Audi Q5
• Audi Q7
• BMW X3
• Jaguar F-Pace
• Land Rover Discovery
• Range Rover
• Skoda Kodiaq
• Volkswagen Touareg
• Volvo XC90
• Volvo XC60

Link: https://docs.zoho.com/sheet/open/60cie3477322cab1e...

(Models split onto separate worksheets)

This is great! I’d also add the F-Pace deal at Jaguar Heritage..:

£399 initial
47 x 399
No fee

Edited by Merp on Monday 13th August 18:52

[JaredVannett]

Appreciate the feedback, thanks

I'll be rotating car categories/classes on each release.

Will look at adding the requested models upon the next large suv release, by then the market should get more interesting post WLTP etc.

Expect the next dataset to land around bank holiday, feel free to subscribe/bookmark.

[loofer]

JaredVannett said:

Appreciate the feedback, thanks

I'll be rotating car categories/classes on each release.

Will look at adding the requested models upon the next large suv release, by then the market should get more interesting post WLTP etc.

Expect the next dataset to land around bank holiday, feel free to subscribe/bookmark.

Great work, really appreciate it, both the time and the skill.
Another suggestion, if not too much work, is if you can output the full list of deals on CH&L into one file (yes it'd be a big one). Yes. Every.Single.Car!

The reason is, many of us in the search for a good deal are a bit agnostic as to what make/model it is as long as it meets some basic criteria.
The main one being cost.

So if I could filter on my monthly budget then filter on some of the brands models I would consider then I'm able to see a lot more of what potential deals there are within my budget. Anybody who wants a specific brand or an SUV for e.g can still filter on them.

It would also save you having to write a new post each week targeting a specific Make/car segment. Just upload the latest file.

Would appreciate your thoughts on this

[XLYC]

Great idea, sometimes when u click a car it comes with an error (using safari ios)

[JaredVannett]

loofer said:

Great work, really appreciate it, both the time and the skill.
Another suggestion, if not too much work, is if you can output the full list of deals on CH&L into one file (yes it'd be a big one). Yes. Every.Single.Car!

...

Would appreciate your thoughts on this

I have tried that but unfortunately the server imposes a temporary ban if too many requests are made in a short period of time.

To do so manually would take even longer, which is time I do not have.

This is why going forward I will publish datasets based on a particular theme.

XLYC said:

Great idea, sometimes when u click a car it comes with an error (using safari ios)

Hi

That is unfortunate. It must be a bug with the ZOHO sheets, you could try download the excel file and open it through a spreadsheet app on iOS?

Edited by JaredVannett on Tuesday 14th August 13:07

[JaredVannett]

August 2018 Dataset #3 - Best German Execs

A general overview of current deals on German Executive vehicles:

AUDI A4
AUDI A5
AUDI A6
BMW 3 SERIES
BMW 4 SERIES
BMW 5 SERIES
MERCEDES C-CLASS
MERCEDES E-CLASS

Link: https://docs.zoho.com/file/99qs78507d06f0793445b98...

(Models split onto separate worksheets)

Commentary: Overall prices remain even across all brands, quite unusual given how competitive this sector usually is.
Those expecting pre WLTP bargains may be disappointed, at least 6 of the cheapest E-class deals have already gone.
Perhaps September will yield some bargains.