The essentialMicrosoft Exceladd-in, providing a suite of tools, functions & templates for finance and investment professionals.


About Prescient Securities

Prescient Securities (PSec) is a leading independent stockbroking firm providing multi-asset South African market access to fund managers and selected retail investors. We also offer professional investors global equity market access, rated fundamental share research and access to the PSec GEARS analytical function suite. PSec is also one of the few full-service stockbrokers who are black-owned and controlled.

Please find our BBBEE certificate here.

About PSec GEARS

Born out of a desire to provide practical, efficient solutions to industry problems, PSec GEARS (General Excel And Research Software) is a locally built and supported MS Excel add-in that has been in continuous development since 2011. It comprises two components: an Analytical Function Suite and our Research Portal .

Solving real-market problems is our main focus and our loyal client base continually engage with us in this regard. Furthermore, thanks to the rated research emanating from the PSec business units, we are able to provide asset class specific and time saving tools.

We also provide in-person training, platform demonstrations, on-going support and extensive help documentation. Feel free to contact us for any queries, support or training.

PSec GEARS MS Excel Menu
PSec GEARS ribbon in MS-Excel after installation.

Our Stats


MS Excel Functions


Demo Sheets &




using GEARS


Interactive Tools &



Part of our value-add offering to supporting clients is permissioned access to our PSec GEARS platform. If you are not currently a Prescient Securities client, completion of the registration process will entitle you to a 6-month free trial of our Analytical Function Suite. Thereafter, continued access will be on a per user license basis. Please contact us for pricing.


Click the 'Install PSec GEARS' button and wait for the installation file to complete downloading. Run the installation file to install PSec GEARS. You can also follow the step-by-step installation and registration instructions in the Installation & Registration tutorial.

For details on the current, and past PSec GEARS versions, please visit the Version History page.

To view a list of all the additional functions provided in PSec GEARS, please visit the Functions page.

All legal information, agreements and notices can be viewed on our Terms & Conditions page.

Download PSec GEARS

Latest Tutorials

Fixed Income Series

1. Introduction

Posted: 2024/06/04

An introduction to PSec GEARS and the Fixed Income Series of tutorials.

Fixed Income Series

2. The Ribbon

Posted: 2024/06/04

An overview of the PSec GEARS Add-In ribbon in Excel.

Fixed Income Series

3. Data - Dates

Posted: 2024/06/04

Working with dates using PSec GEARS.

View All Tutorials


Thank you, your message has been sent.
Sorry, something went wrong.
Please check the Captcha form.