Tamamlanmış

Download stock price information form web to excel

Hi, prior to the yahoo API closing down I used to download lots of equity marked data for a trading program I had developed. I can no longer do this and am looking for someone who can program some VBA code for me to download the information I need from the web on demand. The format needs to be - Date - Open - High - Low - Close - Volume - This should be the headers for each on the 6 columns with the required data underneath. The only exception being the header of the date column should be the ticker symbol of the stock. When downloading I need to specify an end date for the data and then how many days of data preceding the end date I want, i.e. 20/8/2018 and 1000 days of data preceding this date. Preferably this data would come from a site that has as many world markets as possible but if not I would prefer US data and then Australian data sources. I will upload an excel file with the required format.

My old code would loop through a list of stock tickers and download the information for each stock and place it in a worksheet in the format attached. It worked quite fast and I could generally download all 500 stocks in the S&P500 with a 1000 days data in under 2 mins. I have tried two paid sources but they were both unreliable and hung when downloading lots of data.

Beceriler: Veri Girişi, Veri İşleme, Excel, PHP, Visual Basic

Daha fazlasını gör: real time stock quotes excel, excel stock quotes 2017, excel stock quotes 2018, get stock quotes in excel from yahoo finance, excel vba stock quotes, get stock quotes in excel from google finance, stock quotes in excel 2013, how to get stock quotes in excel 2016, realtime stock price web services, excel stock price graph macro real time, stock price feeds excel, excel stock price feed, excel form web, excel stock price, feed excel sheet stock price, edit information form web flow spring, stock price details form xml, macro automatically download stock price yahoo finance, code show companys bse stock price asp net web page, excel macro yahoo finance historical stock price download

İşveren Hakkında:
( 2 değerlendirme ) Singapore, Singapore

Proje NO: #18426945

Seçilen:

macroPOL

Hello, I am Excel and VBA expert. I can do it. If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Jan

%selectedBids___i_period_sub_7% gün içinde 150%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(81 Değerlendirme)
5.9

Bu iş için 27 freelancer ortalamada $149 teklif veriyor

schoudhary1553

Hello, I have gone through your job Download stock price information form web to excel and i am sure i can deliver you the quality job. Please see my profile i have deliver almost 430 projects with 100% client satis Daha Fazla

$250 SGD in 3 gün içinde
(339 Değerlendirme)
7.8
Tanmoy236

"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor Daha Fazla

$150 SGD in 3 gün içinde
(196 Değerlendirme)
6.8
devi222

Hi Sir, I have been scraping STocks data in the world from many sources like yahoo finance, worldtradingdata and other exchanges like nasdaq, nse etc.. Im a Python Programmer. I have created many Bots to scrape the w Daha Fazla

$150 SGD in 2 gün içinde
(194 Değerlendirme)
6.8
jonyahmed105

Hello I want to do it Thanks

$255 SGD in 3 gün içinde
(133 Değerlendirme)
6.2
mateenbhatti94

Dear sir I have read the requirements and completely understand the project.I will get you data from the website with the same 1000 day and it will be quick. I have been in this industry for 1 year and such jobs ar Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% SGD
(75 Değerlendirme)
5.8
aubrey03

I am an Excel and VBA specialist. I have a lot of experience in creating automation tools, dynamic dashboards and macros in Excel. You may check some of my projects here: [login to view URL] Daha Fazla

$150 SGD in 3 gün içinde
(68 Değerlendirme)
5.3
ITPyramid85

hello,how are you. i read your bid carefully. i am web scrapping expert and have full experience for 7 years. C#, .Net is my top skill and i can build your project by using that skills. I can provide most quality an Daha Fazla

$200 SGD in 3 gün içinde
(3 Değerlendirme)
5.2
vbizsolutionss

Hi, Greetings!!! I am a Senior Web Designer & Developer, I am a part of a leading Software Company and have more than 7 years of experience in HTML5/CSS3, JavaScript, JQuery, Bootstrap, WordPress & PHP. I have gone Daha Fazla

$200 SGD in 3 gün içinde
(31 Değerlendirme)
5.0
dalsaniyasonu123

Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.

$100 SGD in 3 gün içinde
(21 Değerlendirme)
4.2
Zhenqiang

Hello client. I read your ideas and understood wholly. I have 4+ experiences in back-end development. I am very interested in your job that download stock price information form web to excel I can satisfy your all Daha Fazla

$155 SGD in 3 gün içinde
(5 Değerlendirme)
3.1
rajnish93mj

Dear Sir, I have read all your details that you have mentioned. I have more than 4 years of experience in Data entry and fast typing (60+ speed without errors). I feel fit for your project because i can complete thi Daha Fazla

$36 SGD in 7 gün içinde
(5 Değerlendirme)
2.8
danishshoaib

Hi there, Hope you are doing well. Your requirements match well with my expertise. I make very eye catchy website designs, logos, flyers, broachers, t-shirt designs, and visiting cards apart from them I am also expert Daha Fazla

$170 SGD in 3 gün içinde
(3 Değerlendirme)
2.8
HarleyJohnson

I WILL BE YOUR GHOSTWRITER, AND GHOSTWRITESB ARTICLES, BLOGS AND EBOOKS FOR YOU Writing a bооk оr blоgѕ аrе a fаntаѕtiс wау tо share thе message оf уоur buѕinеѕѕ аnd inсrеаѕе еxроѕurе fоr уоur brаnd. Yоur роtеntiаl n Daha Fazla

$250 SGD in 3 gün içinde
(4 Değerlendirme)
2.7
PiushGoutam2018

Hi, I am interested in taking up your project. I have done 10+ projects in python software development,website development,desktop automation,website automation and web scraping,.I deliver fast,clean and quality work Daha Fazla

$31 SGD in 3 gün içinde
(5 Değerlendirme)
2.3
Freelancer122144

Hello, I am familiar with stock market, Forex, and binary options trading. I will transfer the data you need very thoroughly into spreadsheets in less than 3 days. Regards

$100 SGD in 3 gün içinde
(0 Değerlendirme)
0.0
umairigocl

Hello Sir, I have read your project description and I think, I would be best for your project. I have a lot of experience in Data entry and I have also 5 years experience in digital marketing. If you can give me Daha Fazla

$150 SGD in 3 gün içinde
(0 Değerlendirme)
0.0
VEENEETA

I will do your work in three days.

$155 SGD in 3 gün içinde
(0 Değerlendirme)
0.0
Priyanji1995

I have a thorough knowledge in IT and in Office packages. I am great with completing work within given timelines. I think I would be the best candidate for your project given my background in IT. If you need any infor Daha Fazla

$111 SGD in 3 gün içinde
(0 Değerlendirme)
0.0
Faiyaz8655

i done my job very passionately........ and i typing speed is good enough of this project.... I DONE MY WORK BEFORE DEADLINE... IT'S MY WORD........

$222 SGD in 3 gün içinde
(0 Değerlendirme)
0.0
Mehrunnisa3786

Digree in commerce and knowledge of Microsoft excel and data processing

$155 SGD in 3 gün içinde
(0 Değerlendirme)
0.0