SEGRO Share Price History Dataset
The data is sourced from the Share Price History of the SEGRO website.
It contains a time series going back about five years of daily values of open, high, low, and close prices and volume traded.
You can also download a copy of the dataset as of 10th September 2025.
Data Description and Links
The datasets have the daily share price and volume (number of shares) traded for a company. There are several versions of the price: Open (the price at the start of the day), High, Low, Close and Adjusted Close. These are in CSV format in a public web location.
The dataset is for SEGRO, a European real estate logistics firm. The URL is SEGRO Data.
The original source data is from Yahoo Finance UK
Power BI Lab Exercise
In Power BI Desktop build dual line (for the price) and column (for the volume) chart. Jere are some suggested steps to follow:
- Launch Power BI Desktop and import the data.
- Build a visual to show the close price of the company over the last few years. What can we say about the company’s fortunes?
- The data has two versions of the closing price; Close and Adjusted Close. Add the Adjusted Close to the chart. Does this give any clue as to the difference?
- Add the volume column to your chart. This is of secondary importance to the viewer so tailor your colours and axes to take that into account
- Change the title to state the range of selected dates. (Hint: create a DAX measure)
Power BI Lab Exercise - Advanced DAX challenges
- Calculate the Intraday Price Change, the close price less the open price on a day. Use that to colour the columns green or red depending on whether the Intraday Price Change is positive or negative
- Calculate the Daily Price Change – the Close Price on one day less the Close Price on the previous day
- Investors often like to look at 3 month or 1 year moving average of a share price. Can you calculate this and show these lines?