Spreadsheet of daily stock closing price and volume

Concluído Postado há 6 anos Pago na entrega
Concluído Pago na entrega

Scan the web for the final closing price and stock volume every trading day after the US Stock Market closes (regular trading hours).

Populate the “Closing Price” and “Volume” columns in three existing company list .csv spreadsheets for the NASDAQ, NYSE, and AMEX. Once the data has been inserted for each company into the spreadsheet, multiply the “Closing Price” and “Volume” and place the total in to a new column called “Price Volume”. (All columns should include all decimal places. Ex.: one million = 1,000,000.)

Save all three spreadsheets for future use. (Sorting, etc.)

Automate this process so new spreadsheets are created everyday after the market closes.

Allow for the web scanning and spreadsheet creation automation to continue if the NASDAQ, NYSE, and AMEX ,csv company lists are altered in the future.

Also create a column for the "date" in the .csv file that matches the day of the stock data.

Excel Excel Macros Excel VBA Arquitetura de software Visual Basic

ID do Projeto: #15977930

Sobre o projeto

40 propostas Projeto remoto Ativo em há 6 anos

Concedido a:

jaylancer43

Hello Sir, Thank you for this opportunity. I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an M Mais

$250 USD em 3 dias
(755 Comentários)
8.5

40 freelancers estão ofertando em média $157 nesse trabalho

schoudhary1553

Greeting, I have understood your Spreadsheet of daily stock closing price and volume task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Mais

$250 USD in 3 dias
(359 Comentários)
8.0
The24CarrotsInc

A proposal has not yet been provided

$250 USD in 3 dias
(77 Comentários)
5.8
usmanhassan123

I am MSc software engineering and I will deliver you within one day I am expert

$250 USD em 1 dia
(78 Comentários)
6.2
osmemon

I have 10 years of experience in Excel, VBA and Web Scraping. I will develop toop that will fetch all the information in excel and save as csv. See my profile for client reviews.

$166 USD em 1 dia
(35 Comentários)
5.6
imanolie

Hi there, I can web scrape this, but I would need to source of data to scrap. I can create the script and give you a week of results for you to test it, to know is the right tool. Then we can accomodate the prices Mais

$1000 USD in 3 dias
(14 Comentários)
5.2
Excel4You

Hi! I've already completed a lot of similar projects by using a kind of macro developed myself, so I'm able to solve your task in several hours. You'll receive perfect "one-click" solution as the result of my work.

$100 USD in 3 dias
(22 Comentários)
4.6
sjDavidson

Hi, I have twenty years experience with MS excel and writing VBA. I am also available straight away to see if I would be a good fit for your project. Regards Stephen

$100 USD in 2 dias
(6 Comentários)
3.1
dimuthufr

Hi There, I am a software engineer with skill of PHP, Python, Software Architecture, Web Scraping, Java, Asp.net, C#... I would like to complete your project as your requrement

$120 USD in 3 dias
(6 Comentários)
2.9
bondilimahesh

I have extensive experience working on projects that require excel and VBA skills. I'm keen on quality and delivering the project well advance in time.

$166 USD in 3 dias
(2 Comentários)
2.4
asirihewage

Hi there - My name is Asiri. I’ve read your brief and I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at Mais

$30 USD in 3 dias
(1 Comentário)
0.0
rimo29

A proposal has not yet been provided

$166 USD in 2 dias
(0 Comentários)
0.0
shoaibulislam24

Dear hiring manager, Today i found this job in freelancer and i am very interested to this job, because my skill refers to the job. I have a vast knowledge about data entry, Google documents and Micro soft office. Mais

$155 USD in 2 dias
(0 Comentários)
0.0
parveshmehta447

A proposal has not yet been provided

$66 USD in 3 dias
(0 Comentários)
0.0
issacchun

A proposal has not yet been provided

$35 USD in 7 dias
(0 Comentários)
0.0
pka55982eb610d17

I am good at Data entry and typing fastly since I am a programmer. I have an interest in the financial market as well. So will complete the work easily and quickly.

$166 USD in 4 dias
(0 Comentários)
0.0
enymann

Hi there, I read your project and understand you need an automated Spreadsheet to compile Closing Price and Price Volume. One of my strong skills is Excel and this gives me an edge on your project. Please contact me Mais

$250 USD in 3 dias
(0 Comentários)
0.0
DAVEDIVIJ

A proposal has not yet been provided

$166 USD in 5 dias
(0 Comentários)
0.0
kushalkuma

Hi, I have over 7 years of experience in different industries like finance, banking, telecom. I am expert in excel with advanced formulas and functions (VBA, macro), Ms word, Ms power point. I will complete my task wit Mais

$155 USD in 3 dias
(1 Comentário)
0.0
IshtiaqAhmed577

A proposal has not yet been provided

$200 USD in 3 dias
(0 Comentários)
0.0
KGTharaka

I am tharaka from sri lanka.

$155 USD in 3 dias
(0 Comentários)
0.0