Devam Ediyor

20-minute delayed stock and option quote downloader for Excel - repost

Project Background:

Some years ago Microsoft offered an add-in for Excel that allowed near-real time (20 minute delayed) stock and option quotes to be downloaded into an Excel spreadsheet. Microsoft subsequently stopped supporting the application, but it continued to work for me in later versions of both Excel and the Windows operating system. Recently, however, I upgraded my operating system (Windows 8) and find that the add-in no longer works with my version of Excel (2007).

Project Description:

I require a simple add-in or VBA module in which I can:

a) enter a ticker symbol (either stock or option) into cell A1.

b) retrieve (from a website such as Yahoo! Finance, CBOE, or other) the 20-minute delayed bid and ask price and insert these values into cells B1 and C1, respectively.

c) retrieve these bid and ask values any time that the ticker symbol changes, and/or I choose to retrieve more recent updates by invoking the macro / add-in.

The add-in should be able to accommodate multiple tickers that might be added as additional rows in column A.

Beceriler: Excel

Daha fazlasını görün: stock option quotes excel, option quote excel, windows price, simple stock ticker, microsoft excel spreadsheet, microsoft excel windows, excel windows, cboe, bid quote, ask excel, microsoft excel vba, microsoft excel price, excel 2013 vba, vba excel macro, spreadsheet microsoft excel, minute, finance excel, excel macro vba, excel finance, excel vba, excel add, c1, vba excel stock, insert macro excel, yahoo finance excel add

İşveren Hakkında:
( 2 değerlendirme ) Morristown, United States

Proje NO: #4456959

Seçilen:

Baxter2008

Hello JHLLC I have just recently completed a similar project for another client. My proposal is to build an on-demand VBA macro that will scrape the details you specified using a web query. This is quick to buil Daha fazlası

1 gün içinde 50$ USD
(7 Değerlendirme)
2.7

10 freelancer bu iş için ortalamada 124$ teklif veriyor

mrbrave

Excel expert with great experience here..

in 2 gün içinde59$ USD
(71 Değerlendirme)
5.3
Teloquence

Consider it done,Check you PM for my bid details.

in 2 gün içinde330$ USD
(50 Değerlendirme)
5.2
Nhcuong

Hi, I can do it. I'm a programmer for year and very familiar with VBA for excel. It would be fully automatic. I will send the demo soon. The require component is MSXML2.XMLHTTP. This should be available in normal Wind Daha fazlası

in 5 gün içinde55$ USD
(20 Değerlendirme)
4.8
vgrichards

Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement. Please do not hesitate to contact me if you have any questions. I look forward to worki Daha fazlası

in 5 gün içinde55$ USD
(16 Değerlendirme)
3.5
vickkey7

I am ready to start this project.... thanks

in 5 gün içinde231$ USD
(9 Değerlendirme)
3.4
sharly001

Ready to provide the appropriate add-in in excel. Details in PM.

in 3 gün içinde160$ USD
(1 Değerlendirme)
1.8
exopad

I completed a similar project last year on USD stock prices. Can be fully automated if you like as well (updating data in preset time intervals). Thanks, Exopad

in 3 gün içinde110$ USD
(2 Değerlendirme)
1.7
waseemmumtaz

i want this project

in 4 gün içinde40$ USD
(0 Değerlendirme)
0.0
partharoylalpur

I can do the job. Please send me the detail.

in 3 gün içinde154$ USD
(0 Değerlendirme)
0.0