Find Jobs
Hire Freelancers

Retrieve Stock Market Data fromYahoo Finance using MS Excel 2016

$30-250 USD

Concluído
Publicado há aproximadamente 5 anos

$30-250 USD

Pago na entrega
DESIGN NOTES - Retrieving stock market historical data from Yahoo Finance Compatible with Microsoft Excel 2016. Data comes from Yahoo Finance. Use a command button to initiate the program. Must run for as few as 2 trading days, maximum up to 1,000 trading days. Maintain header row A of "Date/Open/High/Low/Close/Volume", in this order. This will be a data file to be automatically imported to an Excel spreadsheet, so format matters. See attached file. Read input fields of "Ticker, Oldest Date, Newest Date". "Ticker" should not be case sensitive. Error check & message: "Ticker not found" Error check & message: "Invalid date order" (Oldest date & newest date reversed) Error check & message: "Invalid end date" (Newest Date must be today or older) Clear all previous output, potentially 1,000 days. Write new output. Oldest at the top, newest at the bottom. Format "Date": m/d/yy, Arial 8 Format "Open/High/Low/Close": commas, 2 decimal places, Arial 8 Format "Volume": commas, no decimal, Arial 8 Audible alert and "OK" button up completion. OK to turn off screen updates while running. I want to learn from the application and possibly improve. Include an explaination how I get into the code to make changes. If it is locked, then provide the passcode. In exchange for final payment I receive unconditional rights to possess, modify and use for any purpose. Propose milestones of 1/3 acceptance, 1/3 first submittal, 1/3 fully operational/close out.
ID do Projeto: 18868327

Sobre o projeto

6 propostas
Projeto remoto
Ativo há 5 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.
$100 USD em 3 dias
4,9 (115 avaliações)
6,2
6,2
6 freelancers estão ofertando em média $206 USD for esse trabalho
Avatar do Usuário
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$250 USD em 4 dias
4,9 (330 avaliações)
7,8
7,8
Avatar do Usuário
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best regards
$250 USD em 7 dias
5,0 (225 avaliações)
6,9
6,9
Avatar do Usuário
hi, I am very good in data entry having good typing speed as well and also very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.
$250 USD em 1 dia
4,7 (18 avaliações)
4,0
4,0
Avatar do Usuário
Hi Sir, I see you need to import Yahoo Finance historic data. I have a question. Do you want to import it directly and manipulate it automatically in excel or you'll import the data file like in CSV? I can use VBA to manipulate the data as per your need. Just confirming the data source. Let's talk about this in chat. I can work on your task
$234 USD em 7 dias
5,0 (3 avaliações)
3,3
3,3
Avatar do Usuário
I can do what you need. I'm expert using Excel VBA for scrapping purposes. Don't hesitate to contact me so we can discuss the details of your project.
$150 USD em 5 dias
4,2 (3 avaliações)
2,9
2,9

Sobre o cliente

Bandeira do(a) UNITED STATES
Greenwood Village, United States
5,0
4
Método de pagamento verificado
Membro desde jan. 13, 2016

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.