TRADER
- Have expertise in Excel automation using scripting.
- Knowledge on Stocks, Futures and Options, have done analysis on calculations based on EOD pricing, OHLC, Candlesticks, based on set parameters can define the stop loss price and the limit price.
- Have done projects related to stock including Moving Average calculation, RSI, Portfolio listing of stocks per the technical indicators.
- Can get this integrated into your existing spreadsheet
- 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.,
- Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them.
- Pl. review my portfolio on recent projects.
Sample HighComplex Projects using Macros:(via Freelancer)
- Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations.
- System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report.
- Stocks Portfolio - Showing client portfolio stocks with various indicators, Momentum indicators based on portfolio