[12 July 2024] CSV of Every Home Loan Mortgage Rate + Cashback in Australia

autonomate on 27/09/2021 - 14:51
Last edited 12/07/2024 - 19:15

I wrote a script to yank rates and lending product details from a few sources, de-duped them and tracked it over time. The tabs are ordered by date.

There's more than 6000 home loan lending products, this is all you'll ever need for making a decision without a broker. However keep in mind terms and conditions may differ from spreadsheet, so be sure to dot your i's and cross your t's. This is not financial advice. See @geek001's reply re: Tic:Toc. In some cases "Members Only" or package deals aren't included, this is because the data source does not list them. See Me Bank example below.

Update: I've started just uploading a daily CSV as the XSLX was getting too big. Historical CSV's available upon request.

https://mega.nz/file/vZ8WCaLC#NmY-z2On4yGVcozTrS1uE12JzCte0L… (July 12 2024)

There's a new worksheet added to the XSLX for every new day, the first sheet is just a formatted page of stale data. There's a copy of the daily data going back a few months, scroll all the way to the end for the last one.

https://mega.nz/file/jZVRjaqZ#HU5LBTp23D2XtSic5d7zkEgVA4e3XVNL3zsznbcWLsk (last updated Jan 27 2022)

I assume over time this information will become less available as different sources make scraping harder.

Financial Home Loan Loan

Comments

  • Kelpei on 27/02/2024 - 23:27

    Thanks for your work OP. How soon is too soon to refinance? Most recent was was April 2022 to HSBC. It is a competitive rate (5.94%) but no offset account.

    • soan papdi on 28/02/2024 - 10:59

      Never too soon, just a question of your willingness to go through the papework. I have 5.89% with offset ($10/mo) with Timely (formerly Tic:Toc)

      • autonomate on 28/02/2024 - 13:02

        When did you sign up? How long has your loan been with them? I'm wondering if they'll give me the introductory rate long enough to make it worthwhile, or if they'll immediately put it up to their underwriter's rates (6.09).

        • soan papdi on 28/02/2024 - 13:04

          Since Feb 2022 when they offered $2,022 cashback. They've gone up with each rate rise but no more than the RBA raise. Sign up and have a chat, no loss.

    • autonomate on 28/02/2024 - 13:03

      5.94% is pretty good, I'd check to see if the amount you could put in your offset would make changing to another provider (eg Tiimely @ 5.94% with $10/mo offset) worthwhile.

      Keep in mind, that's their introductory rate. I'm an existing Tiimely customer who just rolled in to variable and they put me on 6.09%, 0.15% higher than the advertised priced.

  • FattyHadadi on 28/02/2024 - 11:13

    Any got any advice on upbank. Thinking about going with their 5.85% fixed for 2 years on our first home

    • autonomate on 28/02/2024 - 13:09
      +3

      If I had a crystal ball, I'd tell you - but rates go up, rates go down. Who knows!

      The Australian interest rates and AUD is quite sensitive to partner markets. Even the RBA doesn't have a good idea what the interest rate should do in the next 2 months, let alone 2 years. Fixing when we were at historic lows made sense, because the most you'd pay is <3% of your interest payments. But if we go back down to 1/2%, suddenly you're paying 3x what you could be.

      If you're doing it because you can't service payments above 6/7%, I'd say it's a good move. It'd mean you won't have to worry about losing your house in the next 2 years, and if you're struggling to make ends meet as-is, maybe that's a good idea.

      But I'm not a financial advisor, nor a specialist in this field. I just really like CSV's and updating forum threads for 2 years.

  • Duckie2hh on 01/03/2024 - 10:21

    Thanks OP!!

  • autonomate on 04/03/2024 - 16:06
    +3

    [Mar 4] Updated!

  • autonomate on 06/03/2024 - 17:02
    +3

    [Mar 6] Updated!

    • RQNinja on 17/03/2024 - 19:24

      can't find the cashback column as of 17th march

      • autonomate on 18/03/2024 - 09:11
        +2

        Hey, sorry my upload wasn't working yesterday - I'll rerun it after RBA meeting. In the meantime this is the list of cashbacks I detected:

        ANZ Banking Group Limited|3000
        Bank of China|2000
        Bank of Queensland|2000
        BankSA|2000
        G&C Mutual Bank Limited|1000
        Greater Bank|3000
        IMB Limited|2000
        loans.com.au Pty Ltd|4000
        ME Bank|3000
        Newcastle Permanent|3000
        St.George Bank|2000

  • autonomate on 20/03/2024 - 10:52
    +6

    [Mar 20] Updated for post-RBA meeting! Contains the cashbacks.

  • lucisvivae on 30/03/2024 - 09:08
    +10

    Sharing an excel sheet that uses this data to compare the loans by calculating an IRR based on your circumstances (loan amount, expected life of loan before you refinance, etc…)

    The data used is the same as the csv autonomate posts albeit I have cleaned up for use by the spreadsheet by converting all ongoing payments to a monthly amount, moving once off fees from "ongoing fees" to "other fees". I also combine product and financier names (to ensure the pivot tables in excel) display all unique products.

    https://github.com/LucisVivae/LoanComparator

    Hope it is useful to someone.

    EDIT: Obviously not financial advice and provided subject to the disclaimer in the excel sheet.

  • autonomate on 10/04/2024 - 07:39
    +4

    [Apr 09] Updated

  • R1ngSt1nger on 11/04/2024 - 19:37

    Just discovered this, what an amazing tool , thank you.

    Does anyone know how to access the loans.com.au $4k cashback? I can’t find it mentioned anywhere on their website.

  • hamwhisperer on 14/04/2024 - 18:33

    Hey mate,

    Silly question, if I like one of these loans as a FHB, would we still want to use a mortgage broker? Can we steer them towards this stuff?

    I feel like we should use a broker due to our skills but I don't want to be lumped with some bad recommendation.

    Good work with the scraping, no idea how you did that so well.

    • mac2403 on 14/04/2024 - 20:23

      Use this as your benchmark. I had a broker once that couldn't even get close to offers I got direct from banks so in the end I just went solo. I think you just have to test the market and see how you go. They may be able to help you with some of these offers too but I guess see what they can do first.

      • hamwhisperer on 14/04/2024 - 20:36

        We're kinda clueless, so it's quite daunting to consider going in without one.

  • lucisvivae on 16/04/2024 - 23:24
    +2

    updated https://github.com/LucisVivae/LoanComparator to add 9 April 2024 data and a few other things.

    • Duckie2hh on 17/04/2024 - 09:20
      +1

      This is really neat. Would be great if there was a button to separate investment and owner occupier

      • lucisvivae on 17/04/2024 - 21:05
        +1

        Amended to include. Uploading shortly.

  • autonomate on 09/05/2024 - 13:07
    +3

    [May 09] Updated, post RBA meeting

  • Nost-dc on 10/05/2024 - 09:22

    waiting for the calculator to update. would be awesome if we could also track the possible discounts you can get over the top of their advertised rate but no idea how

    • lucisvivae on 10/05/2024 - 21:18
      +4

      updated (https://github.com/LucisVivae/LoanComparator) to add 9 May 2024 data

      • keeperofthegood on 22/08/2024 - 11:33
        +1

        Any chance you can do another update? Really appreciate it!

    • lucisvivae on 21/05/2024 - 12:12
      +1

      When you say track discounts are you referring to what people are negotiating direct with banks or the introductory rates. The former is reliant on people truthfully disclosing their offered rate (and its doubtful enough people will disclose such information with sufficient specificity to determine why they may have been offered that discount) whereas the later could be easily done as it is already documented in the spreadsheets shared by @autonomate.

  • nagiseuk on 12/07/2024 - 09:57
    +1

    Any chance of an update please? Thank you

    • autonomate on 12/07/2024 - 19:19
      +2

      Updated!

      • nagiseuk on 16/07/2024 - 09:15

        Thanks for the update - the cashback column appears to have been deleted, was this intentional..?

  • autonomate on 12/07/2024 - 19:19
    +3

    [Jul 12] Updated!

    • kobeduck on 16/07/2024 - 13:26

      How do I download it so it shows the same layout as the previous version?

  • The Wololo Wombat on 01/08/2024 - 21:53
    +1

    Thanks so much for this!

  • XabiFernando on 09/08/2024 - 10:59
    +1

    Hey @autonomate, thanks for this, have relied on this each time I do a refinance!

    Just checking, have you taken out the cashback column? Can't see it in the latest download.

  • Savesome on 31/08/2024 - 07:59
    +2

    Hey, can you plz share the latest excel?

  • ssfps on 12/09/2024 - 12:46
    +2

    Thanks for keeping this updated OP - great resource.

  • oreopizza on 16/11/2024 - 09:54
    +5

    Hey OP, love your work! Are we able to get another update as we get to EOY?

  • Eulogy on 06/12/2024 - 22:57

    Did you get anything on the bank of China's rates? They were 4.99% with a variable rate and it's 5.04% as a comparative. I don't know too much about loans just yet so here's the link:
    https://www.bankofchina.com/au/en/bocinfo/bi5/201812/t201812…

  • Duckie2hh on 12/12/2024 - 16:02
    +1

    Can't wait for next update :D

  • Mr BoMBAStiG on 04/02/2025 - 10:21
    +3

    New year, new scrape?

    • Duckie2hh on 04/02/2025 - 10:46
      +1

      waiting patiently….

Login or Join to leave a comment
Login Join