fbpx
Your 'Go To' for Custom Excel Solutions

Scott Lindsay

Forum Replies Created

Viewing 14 posts - 1 through 14 (of 14 total)
  • Author
    Posts
  • in reply to: Portfolio amalgamation/Deletion #3038

    Scott Lindsay
    Keymaster

    Geoff,

    If you are looking for the ability to “rename” a Portfolio in STT this does exist.
    Go to the Configuration button on the ribbon and select Portfolio
    Then select the Portfolio you want to “rename”…..finally change the name in the fields below the list of Portolio’s to the name that is desired
    Click ‘Update’ the Portfolio name will be renamed throughout the workbook to the new name.

    The new feature is going to be included to the next version of STT will allow for the deletion of all trades when deleting a Portfolio. It will remove the need to delete each trade manually before deleting the Portfolio.

    Thanks
    Scott

    in reply to: Adding to Open Postion #3036

    Scott Lindsay
    Keymaster

    Trav,

    I can see the issue and the only solution currently is to create a unique reference for the Contract Note within STT. For example add a “-1” and “-2” and create 2 separate SELL transactions to close out the BUY transactions.

    We do have a feature request that should address this in the future when included to STT. To spread a SELL transaction across multiple BUY transactions
    At the moment STT only allows for matched SELLs to a BUY transaction.

    Thanks
    Scott

    in reply to: Dividend Reinvestment #3035

    Scott Lindsay
    Keymaster

    Trav,

    Apologies for the late reply on this question….there is not Dividend Reinvestment option for STT at the moment. You have to enter Buy Trades to match any shares returned in dividends. A future feature request is in our list to include a Dividend Reinvestment option that will create a holding via a Dividend.

    Thanks
    Scott

    in reply to: Sell shares equally between parcels #3021

    Scott Lindsay
    Keymaster

    Geoff,

    Thanks for your detailed response and analysis in the Sell process for STT and how the reporting is designed.

    We are in the process of building the next version of STT for release in the 1st Quarter, 2019 and will potentially include one or more of these options for creating a Sell within STT.

    FIFO, (ATO preferred)
    LIFO, (Minimises capital gains tax)
    Equalise over all parcels (for performance reporting)

    Thanks
    Scott

    in reply to: Sell shares equally between parcels #3005

    Scott Lindsay
    Keymaster

    Hi POR930,

    The Sell process for STT does not allow you to select parts of an open position. It will take only from a single sell is less than the total for the open position.

    I can see the problem that this presents in that you have a total holding in A2M and want the sale you are about to process to be equally divided across both open positions and not specifically allocated to one of them. So the sale in essence is not related to a particular buy rather it is to be taken fro the whole position for A2M.

    Would this then take an average “buy cost” for the sale from a combination of the 2 parcels of A2M stock to use as the basis for the calculation of profit ?

    Is this a typical challenge for your portfolio ? If it is I can see the need for the development of a function that allows for a trader to allocate a sell across all current open positions in equal portions or at some determined allocation to the open positions if that was required.

    Thanks
    Scott

    in reply to: Buy Form #2977

    Scott Lindsay
    Keymaster

    Geoff,

    Thanks for suggestion for a calculation on the Buy/Sell form to indicate the Total Costs or Proceeds for a Buy or Sale. This is something that can be easily done as part of the next release of Share Trade Tracker which is due in QTR 1, 2019. I have included it to the list of updates for the next version.

    Scott

    in reply to: Company Name and Security Details not Updating #2365

    Scott Lindsay
    Keymaster

    A fix has been implemented to the latest version of Share Trade Tracker v3.2.3 to address this issue.
    Please download the new version of Share Trade Tracker by clicking on the “Upgrade” button in the ribbon


    Scott Lindsay
    Keymaster

    Skate,

    No new integrations are available for Share Trade Tracker at the moment.
    But we have just received advice from Norgate that their API integration will be ready for testing in the next few weeks.

    In light of this recent issue with the Google feed we are going to review again the options available for other data sources. That will include Just Data which does provide for direct access to CSV files of price data.

    Once new integrations are available we will advise all users of the options

    Regards
    Scott

    in reply to: Google Data Source not working #2229

    Scott Lindsay
    Keymaster

    Resolved.

    We have now updated Share Trade Tracker to resolve this issue. All existing users can download the new version of Share Trade Tracker v3.1.8 or later to receive the fix.

    in reply to: Chart improvements and New Metrics #2211

    Scott Lindsay
    Keymaster

    Thanks for explaining that further. I now understand what you mean by the Average metric. I will look to include this to a future version of STT and get you involved in the testing while it is in development.


    Scott Lindsay
    Keymaster

    Jon,

    Yes we have protected the worksheets in STT to ensure that the key formulas are protected. We have also made changes to the worksheets so that the “protected” warning does not appear for users as we were receiving a large number of support requests asking for the password to unlock the worksheet as many users were attempting to enter data directly into the worksheet not realising that the entry of trade data was via the buy and sell trade forms.

    I can understand the frustration though and could include in a future release an “advanced” option where the worksheet protection is changed so that expert users are able to select cells on the worksheet to enable the SUM, AVERAGE and COUNT features that are standard with Excel. This would then be available for users to change in the configuration and enable those features to work again.

    Regarding the Interest entry I can see now that could now be a time consuming process to record interest for multiple accounts. We will include to the future feature list an “upload” option for interest that would allow you to import interest records from your bank without the entry screen

    Lastly your suggestion for an external data source is one that others have suggested. It could be implemented as you have proposed and would only be available to those users that have access to their own data source of EOD price and Dividend data. I will include this to a future release and advise users how it can be enabled once it is developed into the product.

    Thanks for your suggestions…

    in reply to: Chart improvements and New Metrics #2206

    Scott Lindsay
    Keymaster

    Luke,

    Thanks for your suggestion I will respond on each of your suggestions and comments
    For the Charts we plot the Average of all trades for a security. That Average can be a good or poor perform and is shown for the Open and Closed trades

    For your suggested new feature to display Avg % gain on winners and Avg % loss on losers is this not already showing that ?
    Or are you asking for it to show the % gain or loss for each trade and not average that for a security ?

    Your other request for date range is a good one…..we are going to investigate the implementation of “Date Range Slicer” in the next version that can be applied to the Dashboard and the Charts worksheet. This would allow the user to set the date range across any period and then update the values on the worksheets to reflect that.

    Regarding you other suggested metrics we have had others make the suggestion for the R-Multiple and will look to include that in a future version
    We will also look into Expectancy as another metric to add into the Dashboard..

    Thanks for your suggestions we will factor these into future work on Share Trade Tracker..


    Scott Lindsay
    Keymaster

    In the Dashboard screen shot below for your trading activity in the Growth Portfolio we can see
    – Start Cash Balance ($100) this is taken from the Cash Account worksheet and is the first entry for the selected Portfolio
    – End Cash Balance ($39,130) this is again taken directly from the Cash Account worksheet and shows the accumulation of transactions for the Portfolio. This calculated field does not take into account any trading activity
    – End Cash Balance & Trading this uses the End Cash Balance and then applies any Profit or Loss from your Gross Trading to provide a result. This takes into account Open and Closed positions

    So I think you are looking for a calculation that gives you a Cash Balance that reflects the payments made to BUY positions and the payments received when positions are SOLD along with the COMMISSIONS, DIVIDENDS, INTEREST and OTHER INCOME applied to give you a Portfolio Balance. This balance would not take into account any Unrealised P&L on Open Trades just the costs for those trades. The expectation is that this would then match your actual Cash position in the IB Trading Account is that right ?

    I don’t think we have a calculation on the Dashboard like that at the moment but it could be developed…
    Please add any comments on this new feature and also if you support it’s inclusion to Share Trade Tracker

    STT Dashboard Example

    in reply to: Does Share Trade Tracker have support on Office 365 ? #2162

    Scott Lindsay
    Keymaster

    Share Trade Tracker requires the desktop version of Excel.

    As part of an Office 365 Subscription you receive access to a copy of Excel for the desktop. Once installed Share Trade Tracker can be opened on that machine.

    Share Trade Tracker cannot be used in any Online version of Excel.

    Let me know if you have any other questions…

Viewing 14 posts - 1 through 14 (of 14 total)