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

[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.

[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)

[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.

[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.

[JaredVannett]

TomScrut said:

Cheers, really good work you're doing!

I agree, absolutely no bargains to be had are there? I think the thing is that VAG are the prime suspect for good deals on factory orders but their lead times are crazy at the moment so there isnt anything to be had. Might be worth adding the Arteon to that sheet as it could be deemed comparable to the others on there and is the one that seems best value at present?

Thanks Tom.

Good call on the Arteon, I was thinking the other day where it's supposed to sit - seems obvious now.



Given the stale deals at the moment... for the next dataset I'm happy to do a 'request round' for all. (I'll include the Arteon).

So if you have any models you'd like data for reply below or pm me.

Cheers all

[JaredVannett]

One mini dataset for the weekend - a random assortment based on requests:

ALFA-ROMEO (All Models)
BMW X5
NISSAN X-TRAIL
VOLKSWAGEN - ARTEON


https://docs.zoho.com/file/9fjkv0c39a240ebf74cc5a5...

[JaredVannett]

Update

I took a short break a few months ago due to the WLTP slowdown.

Since then I've been working on a project to create a community hub (portal) for PH readers to share the big data more easily as a supplement to the main lease deals thread.

Expect this in 2019

Sc0tchland said:

What's the latest sir?

Here's the latest I have on BMW leases for November:

Link Removed

Edited by JaredVannett on Thursday 22 November 12:25

[JaredVannett]

Rob2005uk said:

Great info thanks.

Would it be possible to list more 1 month in advance deals?

Hi

I can't get you data for one month advance, the data I publish is for what's currently out there. Do note however, when I publish a worksheet the data is at most 1-2 days old, so the deals are fresh


I now have the latest deals for Audi below: (Includes BMW worksheet)

Link Removed


Tomorrow I'll have the Mercedes deals ready to share - Cheers all!

Edited by JaredVannett on Thursday 22 November 12:25

[JaredVannett]

Mercedes Deals for this week:

https://docs.zoho.com/file/45mxzc93578343b0a4030b3...

^Includes previous Audi and BMW worksheets.

As a reminder, the web app allows you to download as an Excel document, then filters will work.



That's it for now, will have another look around mid December - see what santa brings

[JaredVannett]

Hello all.

Here's a belated update on deals:

All 24mth deals under £10k
https://docs.zoho.com/file/68doob248ebed52864fdebf...

To download:
Go to File > Export > Excel

(Be patient for the download to commence, there's a lot of data).


As always, for latest updates subscribe to this thread.


Cheers

[JaredVannett]

A2MYH said:

Any updates available ?

Hi

Recently, Leasing.com has been redesigned - their website now displays the total deal cost next to each deal.

In addition the initial rental and fee's are also displayed, since this is price data is now transparent I have not published a new spreadsheet.

If there is enough demand/preference to continue with spreadsheets I'll look into providing an update, otherwise use http://www.leasing.com