PBfrontier - README


The PBfrontier script (Excel 2007 VBA) can create an Efficient Frontier curve from the historical return data of different financial assets.


PBfrontier - Settings

PBfrontier - Calculation

PBfrontier - Efficient Frontier

PBfrontier - Solutions


  • Open the file PBfrontier.xlsm in the Microsoft Excel 2007 application.
  • Enable the execution of Excel macros in the settings of Microsoft Excel.
  • Edit the settings on the first tab called Settings.
  • Add historical return data on the tab called Return Data.
  • Open the Excel calculation tab called Calculations.
  • Start the calculation with the button Create Efficient Frontier.
  • Check the result on the tabs Efficient Frontier and Solutions.


This is a free tool and support is not included and guaranteed. Nevertheless I will try to answer all your questions if possible. So write to my email address biegel[at] if you have a question :-)


The PBfrontier script is licensed under the MIT License (Expat) which is published on the official site of the Open Source Initiative.