PROPERTY INVESTMENT

From reviewing auctions one by one to having them all filtered and scored

Automated extraction of the public auctions that match their filters, loaded into their Excel with the profitability formulas and stages to track each property.

Property investor · Portugal

BEFORE

Hours a day to review a handful of properties

AFTER

Every property that matches their filters, in one step

The problem: hours a day to review a handful of properties

Auctions are published on a public government website. To find out whether a property was worth it, the client opened each listing's detail page, one by one, and copied its data by hand into an Excel file where they then ran the profitability numbers and filtered by city and other features.

That work ate up hours every day and still only covered a handful of properties. The investment criteria already existed and were sound: what failed was the time it took to apply them.

A phased project, to validate before growing

The project was quoted and split into phases. We laid out several options, each with what it delivered and the risks it carried, and the phases were defined together with the client, so they felt comfortable from the first minute and got something of value in a very short time.

The idea was to prove first that automation solved the problem and, with that validated, decide whether to evolve the product.

The first phase is not a full application, and was never meant to be. Even so, from day one it drastically cut the time the client spent reviewing auctions.

What we built in the first phase

Extraction with their filters. The system works through the public website and pulls only the properties that match the features the client asks for, such as the city, without opening a single listing by hand.

Loaded into Excel, without duplicates. The data is downloaded and added to their Excel file: properties that already existed are updated and new ones are added.

The profitability formulas, applied to every property. The spreadsheet works out whether each property is profitable using the same criteria the client already used.

Stages to track each property. Every property can be moved through different stages, so the spreadsheet stops being a list and becomes the tracker for each deal.

First phase: the public government auction website, extraction with the client's filters, loading into their Excel by updating existing properties and adding new ones, profitability formulas and stages per property and, at the end, the investor's decision whether to bid.Public auction websitegovernment listings, one by oneExtraction with their filterscity and features, no listings openedLoaded into their Excelupdates existing ones, adds new onesFormulas and stagesprofitability of each property and its stageDecision: bid or not, and how highthe only step that stays human
Everything before the decision is done by the system.

Why the first phase lives in Excel

The client already worked in Excel: that is where their numbers and their way of comparing deals lived. Bringing the automation into that same file meant it could be used from day one, without learning a new tool, and the project's value could be validated with the smallest possible investment.

With phase one working, the next step has a real foundation to build on.

The result

What used to take hours a day and only reached a handful of properties is now done in one step, and covers every property that matches their filters.

The real effect is not only speed, it is coverage. Once reviewing a property stops costing time, every property gets reviewed, not just the ones there was time to look at.

The first phase is delivered and the client uses it every day.

SCOPE

What v1 covered

This is the first phase, and its scope was deliberate: extraction, Excel and formulas, with no application of its own. The next phase replaces the spreadsheet with a web application that can be used from anywhere, with new modules on the same foundation.

Services involved

Shall we build something that scales, together?

Tell us about your project. We'll get back to you with a concrete plan and a senior team — not a generic quote.

Let's talk about your projectholalmnhub.com