Can get the Sttocks, ID, Price and levels by importing the csv into the WebERP software as per the softwares template required.
- Can make sure the Database constraints are taken care before making the entries or importing into software.
- Have expertise in automation in Excel and good exposure to Stocks including Futures and Options, EOD,, Candle stick moving average.
- Have done few projects related to Stock including Portfolio consolidation for client based on indicator RSI, Capex, 14Day Moving Avg, Technical flags etc (Can showcasse).
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data consolidation, data comparison, pivot, lookups, summaries
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data camparision using formulas, lookups and summaries.,
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells
- Data camparision using formulas, lookups and bringing up summaries.,
- Data extraction using API.
- Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them.
- With summary data plotting graphs, bringing pivot tables
- Pl. review my portfolio on recent projects.