List of US Stocks and ETFs and their Average Daily Trading Volume
This project was successfully completed by mmbertasi for $150 USD in 3 days.Get free quotes for a project like this
Project Budget$30 - $250 USD
Completed In3 days
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
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online