Market Data Access

This article provides a comprehensive guide on the various data sets available through Piclo, including where to find them and how to effectively use them.

What data is available?

Live competition data

A live competition is  any competition in an active state, such as when qualification or bidding is open. Piclo makes these competitions easily accessible and visible via the Max dashboard and the map.

• View live competitions: Check the current live competitions on your Max dashboard or the map. To learn more about competitions, please visit Piclo Academy.
• Download live competition data: Registered FSPs can download live competition data in XLSX format from the link available at the top right of the map> UK, US, Australia

If you don't see any live competitions at the moment, don't worry; new competitions are added at any time. Stay updated by registering on Piclo > UK, US, Australia.  Registered FSPs will receive email notifications when new opportunities are available.  You can also keep up to date with new opportunities by regularly visiting the system operator profile pages.

Historic competition data

Historic competition data refers to any competition on Piclo that has closed for participation. These competitions may also include historic bidding data, although not all historic competitions have bids if no FSPs participated. Currently, these datasets are only available for UK competitions. Once competitions in the US and Australia are completed, their datasets will be added.

• Download data: Access and download the Piclo Flex UK Competition data report from the Piclo Data Hub in XLSX format. 
• Competition boundary data: Download competition boundary data per System Operator in GeoPackage format. The file format is GeoJSON.

Historic bidding data

Once the bidding period ends, every competition on Piclo becomes historic. However, not every historic competition will have bidding data if there were no FSP participants. If a historic competition lacks bidding data, it indicates that there were no participants. 

• Download bidding data: Visit the Piclo Data Hub to download the Piclo confirmed bids report.

Insights available from this bidding data include:

• The range of values for accepted bids
• The range of values for rejected bids
• The reasons for rejected bids
• Competitions without any participation (requires cross-referencing with historic competition data file)

Support with data files

Piclo has provided all the relevant data in XLSX formats that are easily viewed and manipulated via Excel or other spreadsheet tools. 

If you need any support or have any specific questions, please email us at support@piclo.energy. We’re always happy to help. Additionally, check out these helpful resources:

• Microsoft support
• The ultimate guide to using excel