List of US Stocks and ETFs and their Average Daily Trading Volume - repost

This project received 7 bids from talented freelancers with an average bid price of $210 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

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

Skills Required

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online