Need a developer to make an excel macro.
The excel macro when run should do the following:
1. Download closing prices of a family of stocks (NSE/BSE India) from the internet
2. Update them in excel automatically
3. For each stock, perform exponential regression, calculate ATR, 100 day EMA, and if there is more than a 15% gap in prices in the past 90 days.
4. Rank the top 100 stocks based on a formula and check if any of the stocks violate a sell condition. Also indicate if the stock has left the index.
5. Calculate position sizes based on the ranking based on a formula
6. Calculate index 200 DMA based on latest price data
11 freelancere byder i gennemsnit ₹5313 på dette job
Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.
I can do the work and deliver exceptional results.. I am about as meek and mild a person as you could [login to view URL] above traits qualify me as the right candidate for this opportunity ...
I have the skill to accomplish what you have described. I develop program that is robust and flexible. Will thoroughly test the program and provide warranty period of 6 months.