Modify Trade

Any buy or sell trade entered into Share Trade Tracker or upload via Upload Trades can be modified. You can't modify the trade details directly on the worksheet, you must use the "Modify" function on the Share Trade Tracker menu.

Firstly select any cell in the row of the trade that you wish to modify, if you select more than one row an error will be reported and if you select a buy trade that is already sold you will receive an error advising that a sold trade cannot be modified.

If you attempt to update any trade or open position on the worksheet directly you will receive the following warning message. All trade detail worksheets within Share Trade Tracker are locked to protect the formulas and formats. Updates to records are made via a form accessed from the ribbon. To modify a trade select the row and then select 'Modify Trade', to delete a trade select a row or rows and then select 'Delete Trade'

The warning message indicates that you should supply a password to unlock the worksheet to update the values. You do not need this password as you are not able to update the worksheet with trade details directly. For more help see Worksheet Protection.