Peruttu

Real-Time Quote Feed from Yahoo! MarketTracker to Excel

I use Yahoo! Finance MarketTracker for real-time quotes. This appears to be a java application. I have multiple portfolios of 200 symbols each that I track using MarketTracker.

With MarketTracker running in the background, I need to be able to feed real-time quotes from MarketTracker into Excel.

The basic real-time data I need are: Last trade price, last trade time, previous day's close, open price, high price, low price, and volume. (These fields are all available in MarketTracker.)

I do not want an HTML screen scrape from YAHOO! or a CSV download file from YAHOO! --- I need the real-time data to come directly from the Yahoo! Finance MarketTracker java application only. (I have previously tried to log into my premium YAHOO! account and scrape real-time quotes or use Excel Add-ins to get real-time quotes, but in most cases am getting the 15 min. delayed quotes rather than real-time quotes. I suspect YAHOO! is not permitting bulk real-time feeds, even for paying subscribers.)

Ideally, I would like to be able to enter 3000+ symbols into an excel spreadsheet (i.e. the same symbols that are populated in my YAHOO! Finance MarketTracker portfolios) and have the real-time data populate into Excel. (Last trade price, last trade time, previous day's close, open price, high price, low price, and volume.) It is not a requirement that the data in excel be streaming, but it is a requirement that I am able to refresh the data at intervals that I specify.

I have a little bit of programing background (VB, Excel Macros, etc.), but I believe I need a java expert to enable a link from the Yahoo! Finance MarketTracker java application to Excel.

Taidot: Excel, Java

Näytä lisää: real time quote feed, yahoo markettracker, java yahoo real time, real time quote java, yahoo quote, yahoo quotes feed, real time quotes feed, quote feed excel, real time feeds excel, quote feeds excel, quote feed yahoo, yahoo 7, track quotes, time trade, time track application, programing java, my portfolios, macros expert, from quotes, file excel expert, e trade, 7 yahoo, delayed quotes feed excel, excel feed quotes, real time feed quote

About the Employer:
( 0 reviews ) West Des Moines, United States

Projektin tunnus: #502882

10 freelanceria on tarjonnut keskimäärin 469 $ tähän työhön

umernaseer

Hello I have placed all details in PMB. please read it Regards Umer

750 $ USD 5 päivässä
(11 arvostelua)
5.4
aruhat

Hello, Please have a look in PMB. Regards, Bhavik

550 $ USD 8 päivässä
(2 arvostelua)
3.9
artandcode

I can do the job for you as I have lot of experience in Java and Excel/VB/Macros as well

250 $ USD 7 päivässä
(0 arvostelua)
0.0
bsharm8

I would be able to complete this in 6 days.

250 $ USD 6 päivässä
(0 arvostelua)
0.0
Hemantbadal2103

You will get your work done within time.

600 $ USD 45 päivässä
(0 arvostelua)
0.0
moskiongo

We are a Business Process Outsourcing Company. With a customer-focused attitude, desire to understand customer business & identify the right partner for executing the job, we act as a one-stop shop for business process Lisää

440 $ USD 30 päivässä
(0 arvostelua)
0.0
peculiarinfotech

It can be done by two way. 1. Export to Excel and 2. DDE. For more detail please see PM

600 $ USD 16 päivässä
(0 arvostelua)
0.0
suresh55

Hi! I have gone through your requirement and i am glad that i can accomplish this task, i would be more interested to speak to you on IM. Pls give us an opportunity to work with you.

250 $ USD 2 päivässä
(0 arvostelua)
0.0
midus

Our Bid amount : USD 750 Time limit: 5 days Payment terms: 100% advance against work order Our Company Name: Midus Network Communications Private Limited No. of Programmer: 15 No. of Project manager: 3

750 $ USD 5 päivässä
(0 arvostelua)
0.0
suresho

Hi! I have gone through your requirement and i am glad that i can accomplish this task, i would be more interested to speak to you on IM. Pls give us an opportunity to work with you.

250 $ USD 2 päivässä
(0 arvostelua)
0.0