StepOne Portfolio
The StepOne Portfolio is an Excel-based spreadsheet used for portfolio management, enabling the recording of transactions and current status.
The "Trades" sheet records the transactions (buys, sells, dividends, return of capital).
The "Current" sheet shows the current status of the portfolio by displaying summary data from the "Trades" sheet and updating the current stock price from Yahoo
Early versions of the spreadsheet developed problems with the Yahoo price in March 2015, discussed here: http://boards.fool.co.uk/scrape-not-scraping-13184917.aspx?sort=whole#13184917
The problem was fixed and the spreadsheet published here as "StepOne Portfolio-v1-0.xls"
22Jun15: StepOne made some minor functional changes to assist in adding extra rows as described here: http://boards.fool.co.uk/stepone-portfolio-problem-13228330.aspx?sort=whole#13228330 and the updated spreadsheet was published as v2-0
18Jul15: StepOne made further minor format changes and published as v3-0
07Dec17 Yahoo changed the price download process so the macro was modified to accommodate this. Also detected currency to convert prices in GBP to GBp
21May23 Yahoo having problems with v7 of their stock price API, so a Parameters sheet was added to allow selection of v6 or v7 of the API. Defaults to v6 in cell B2 of the Parameters sheet
30May23 More problems with Yahoo so added v10 API
22Aug23 Yahoo problems fixed following the deactivation of the Yahoo Finance API, by extracting prices from a Yahoo web page
Screenshots
The "Trades" sheet records the transactions (buys, sells, dividends, return of capital).
The "Current" sheet shows the current status of the portfolio by displaying summary data from the "Trades" sheet and updating the current stock price from Yahoo
Early versions of the spreadsheet developed problems with the Yahoo price in March 2015, discussed here: http://boards.fool.co.uk/scrape-not-scraping-13184917.aspx?sort=whole#13184917
The problem was fixed and the spreadsheet published here as "StepOne Portfolio-v1-0.xls"
22Jun15: StepOne made some minor functional changes to assist in adding extra rows as described here: http://boards.fool.co.uk/stepone-portfolio-problem-13228330.aspx?sort=whole#13228330 and the updated spreadsheet was published as v2-0
18Jul15: StepOne made further minor format changes and published as v3-0
07Dec17 Yahoo changed the price download process so the macro was modified to accommodate this. Also detected currency to convert prices in GBP to GBp
21May23 Yahoo having problems with v7 of their stock price API, so a Parameters sheet was added to allow selection of v6 or v7 of the API. Defaults to v6 in cell B2 of the Parameters sheet
30May23 More problems with Yahoo so added v10 API
22Aug23 Yahoo problems fixed following the deactivation of the Yahoo Finance API, by extracting prices from a Yahoo web page
Screenshots
stepone_portfolio-v3-4.xls | |
File Size: | 4294 kb |
File Type: | xls |