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

In Progress

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)

Notes:

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: Data Entry, Data Processing, Excel, Web Scraping, Web Search

See more: stocks list, daily trading volume, stock daily trading volume, average dollar volume etfs, volume, stock shares, list of online, data entry worksheet excel, list stocks, daily stock volume list, stocks data, excel 2013 macro, daily stock excel, excel stock symbol price, trading name, name trading, list stocks volume, stocks excel sector, excel industry list, average quality, stock macro, need name trading, average, historical stock prices trading volume, excel macro data list

Project ID: #4827202

Awarded to:

mmbertasi

This is a bread and butter project for me. I am an expert programmer and writing bots/web scrapers is something I do almost on a daily basis. I would discuss where I would get this information with you and then researc More

$150 USD in 3 days
(5 Reviews)
3.0

6 freelancers are bidding on average $182 for this job

Teloquence

Consider it done. Check your PM for my bid details.

$200 USD in 2 days
(86 Reviews)
5.8
MaxwellZone

Please see the private message. Thank you.

$200 USD in 3 days
(7 Reviews)
3.9
SoftwareEng8876

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!

$155 USD in 5 days
(3 Reviews)
3.0
AlGordo

5,000 US stocks / ETFs, $50 Milestone per 1,000.

$250 USD in 7 days
(1 Review)
1.6
ashleyfarley

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.

$194 USD in 3 days
(1 Review)
0.0
bmartori

I am about to get my degree in economics, and I have a vast knowledge of financial markets. sectors, and stocks. I have a deep passion for this line of work and I can assure you that I can get this done in a day or two More

$100 USD in 3 days
(0 Reviews)
0.0