What I need:
1) An excel file, with Sector Names as worksheets, and list of Stocks and ETFs of each sector in their individual worksheet
2) Each Stock or ETF must have the following data: (a) Trading Symbol, (b) Sector, (c) Industry, (d) Average Daily Dollar Volume (in US$)
3) (optional) An Excel Macro which allows the user to eliminate stocks or ETFs below certain levels of Average Daily Dollar Volume (e.g. below $1m)
i) The Average Daily Dollar Volume can be obtained from online sources or calculated by using Average Daily Trading Volume (in no. of shares) multiply by Average Price over the same period (e.g. 30 days)
ii) Ideally, the average figures should have the same number of periods (e.g. 30 days) but as long as they are relatively close (e.g. 30 days vs. 50 days) and not ridiculously far apart (e.g. 30days vs. 5 years average), it is acceptable.
iii) Stock and ETF Name is optional
iv) Milestones will go by the number of stocks/ETF. The more you can provide, the more I will pay. So please bid in number of stocks/$.
v) The Excel Macro is optional but if included, it is a bonus. Please indicate if you are able or not able to provide this Macro, and bid accordingly. Thanks
Quality Checks will be made by sampling the list randomly
6 freelancers are bidding on average $182 for this job
Hello sir...i am very much interested in this project.i have to do my best to get good positive feedback from you.you can believe to get good results from me.just give me one chance to prove. Thank u!
I am an experienced administrative specialist and detail oriented veteran. I can complete this task to your satisfaction both in quality and financially. Looking forward to working with you.