User Guide - itsddpanda/CASscanner GitHub Wiki

Pre-requisites:

  1. Get and save CAS statement from Karvy (URL: https://mfs.kfintech.com/investor/General/ConsolidatedAccountStatement). Save it any folder you like, this folder will be your working directory
  2. Create an Excel Workbook, enable developer options.
  • Click on the File tab at the top-left corner of the Excel window.
  • Select Options from the bottom of the menu. This will open the "Excel Options" dialog box.``
  • In the "Excel Options" dialog, click on Customize Ribbon from the list on the left side.``
  • On the right side, under Main Tabs, you'll see a list of all available tabs. Look for Developer in this list.``
  • Check the box next to Developer to enable it.``
  • Click OK to confirm``
  • After following these steps, the Developer tab should now appear on your Excel ribbon next to the other main tabs like Home, Insert, etc.``