Scribd Logo
Upload

Welcome to Scribd!

  • 83 views

    Template For Uploading Equity Holding and Transactions: Available For Download For Perfios Users

    Uploaded by

    divey_gupta7424
    template

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    Template For Uploading Equity Holding and Transactions: Available For Download For Perfios Users

    Uploaded by

    divey_gupta7424
    83 views3 pages
    template

    Original Title

    Equity Upload Template

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    template

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    83 views3 pages

    Template For Uploading Equity Holding and Transactions: Available For Download For Perfios Users

    Uploaded by

    divey_gupta7424
    template

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 3

    Equity Excel Upload Template - Instructions

    Template for uploading Equity Holding and Transactions


    Version 2.0
    2008-2014, Perfios Software Solutions Pvt. Ltd.
    Available for download for Perfios Users
    Contact Support for comments / request for enhancements.

    PURPOSE
    If you have been maintaining your equity transactions and / or equity holdings in Excel files and want to upload
    the same to your equity account created in Perfios, use this template.
    Please read the instructions, fill up the subsequent sheets with data, save the file. Login to Perfios, click on
    Upload Data to Perfios under Tools section. Choose the second option and upload this file.

    INSTRUCTIONS
    1 Do not delete or rename any worksheet. Do not add any new worksheet or change the order of the worksheets.
    2 Fill up holdings worksheet only if you want to update your current holdings.
    3 Fill up transactions worksheet only if you want to upload your transactions.
    4 Other than inserting holding or transaction data rows, do not add any new row or delete any existing row of the worksheets.
    5 Updating the template is best done by copy-pasting columns from your existing worksheet(s). In case of discrepancies, the cell(s)
    will be flagged red. Click such cells to fix and continue. You can upload the file only when there are no more red flags.

    (C) Copyright 2008, 2009. Perfios Software Solutions Pvt. Ltd.


    Equity - Current Holdings

    INSTRUCTIONS
    1 Fill up this worksheet only if you want to upload your current holdings.
    2 Other than inserting holdings, do not add any new row or delete any existing row.
    3 Read the comments on the table header before proceeding.
    After updating the sheet with your data, Click on the button below to check for errors.
    4 In case of discrepancies, the cell(s) will be flagged red. Click on such cells to fix.
    You can upload the file only when there are no more red flags.
    5 Do not leave any blank row between your data rows. All rows after the first blank row will be ignored.

    Click here to verify your data

    Stock Qty

    Created: 09/02/2009 15:58:48 Perfios Software Solutions Pvt. Ltd. Page 2 of 3


    Equity Transactions

    INSTRUCTIONS
    1 Fill up this worksheet with your equity holdings and transactions.
    2 Other than inserting transactions, do not add any new row or delete any existing row.
    3 Read the comments on the table header before proceeding.
    4 Transactions must be in ascending order of date.
    5 Updating the template is best done by copy-pasting columns from your existing worksheet(s).
    6 After updating the sheet with your data, Click on the button below to check for errors.
    In case of discrepancies, the cell(s) will be flagged red. Click on such cells to fix.
    You can upload the file only when there are no more red flags.

    7 Do not leave any blank row between your data rows. All rows after the first blank row will be ignored.

    Click here to verify your data

    Date Stock Type Description Qty Price Brokerage STT Amount Remarks
    15-Jun-17 LLOYDELENG Sell 1200000002262597 400.00 214.70 85880 50990943
    15-Jun-17 PITTILAM Sell 1200000002265186 690.00 56.25 38812.5 51186521
    15-Jun-17 PITTILAM Sell 1200000002265186 210.00 56.25 11812.5 51186519
    15-Jun-17 PITTILAM Sell 1200000002265186 135.00 56.25 7593.75 51197036
    15-Jun-17 PITTILAM Sell 1200000002265186 20.00 56.25 1125 51200868
    15-Jun-17 PITTILAM Sell 1200000002265186 290.00 56.25 16312.5 51214925
    15-Jun-17 PITTILAM Sell 1200000002265186 55.00 56.25 3093.75 51214923
    15-Jun-17 PITTILAM Sell 1200000002265186 500.00 56.25 28125 51228524
    15-Jun-17 PITTILAM Sell 1200000002265186 100.00 56.25 5625 51348616

    Created: 09/02/2009 15:58:48 Perfios Software Solutions Pvt. Ltd. Page 3 of 3

    You might also like