Closed

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

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

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

About the Employer:
( 0 reviews ) Cairo, Egypt

Project ID: #4827224

7 freelancers are bidding on average $210 for this job

Rajmohan007

Hi, I have done tons of similar jobs. Please message me, so i can start working for you. Thanks & Regards, Raj

$155 USD in 3 days
(2 Reviews)
2.1
mastercris

Let's start !

$277 USD in 3 days
(1 Review)
0.0
sanamkhan95

i can do this

$155 USD in 3 days
(0 Reviews)
0.0
datasolu

We have a team of equity analyst who can do this job for you on part time or daily basis if required.

$200 USD in 3 days
(0 Reviews)
0.0
AlGordo

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

$250 USD in 7 days
(0 Reviews)
0.0
exegetic

hi! this sounds like a cool project. just to give a little background on my experience, i run a small consulting company ([url removed, login to view]) specialising in data analytics, visualisation and predictive modelling. i a More

$200 USD in 5 days
(0 Reviews)
0.0
rohit1984sachan

I have done this earlier for personal use to track volatility, we can discuss more if you want.

$277 USD in 3 days
(0 Reviews)
0.0
rizwan4057854

ready for the project

$155 USD in 3 days
(0 Reviews)
0.0