Yahoo Market Tracker to Excel

I use Yahoo! Finance MarketTracker for real-time quotes. This appears to be a java application. I have multiple portfolios up to 3000 symbols each that I want to 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 automatically like every 1 or 5 minutes.

The excel file attached links the free delayed quotes from MSN into the excel spreadsheet as an example. Each tab is limited to 100 symbols due to MSN restrictions, so I would preferably want all symbols for this project to be in one tab.

Skills: Java

See more: yahoo market tracker, yahoo market tracker download, yahoo markettracker, excel market tracker, market tracker excel, yahoo markettracker excel, yahoo market tracker excel, market tracker yahoo, java yahoo market tracker, yahoo finance market tracker excel, yahoo finance market tracker real time quotes log, yahoo finance excel tracker, yahoo streaming real time quotes excel spreadsheet, download yahoo market data java, download previous day close excel, yahoo market tracker refresh data, yahoo market tracker application, yahoo markettracker download, java market tracker yahoo, excel add yahoo finance streaming quotes, yahoo finance markettracker download, yahoo-finance, yahoo 7, track quotes, tracker download

About the Employer:
( 0 reviews ) Saline, United States

Project ID: #595012

13 freelancers are bidding on average $540 for this job


Professional solutions

$1400 USD in 8 days
(38 Reviews)

Hello Sir, Lets finish it . Thanks Please check PMB.

$520 USD in 10 days
(1 Review)

Please note that we can read data from the Yahoo web Service and populate the excel sheet as asked by you, delays cannot be guaranteed as it is as Yahoo is giving). Thanks

$600 USD in 10 days
(58 Reviews)

Using program instead of VBA will speed up the operation

$500 USD in 3 days
(17 Reviews)

Hi, please, check your pmb

$250 USD in 15 days
(4 Reviews)

ready to [url removed, login to view] we discuss??

$450 USD in 12 days
(3 Reviews)

I cant run it in my PC to see what is it. I am nice java specialist. I had cracked and success decompile java applications. Work with xls from java.

$400 USD in 6 days
(2 Reviews)

Hi, I can help you with this.

$450 USD in 7 days
(0 Reviews)

Ready to do this work.

$300 USD in 20 days
(0 Reviews)

Hi, i'm developer in the java, so i'm interested in this project

$700 USD in 12 days
(0 Reviews)

Hi, I did research in yahoo stock quotes. I can do this.

$500 USD in 20 days
(1 Review)

Please See my Pm

$500 USD in 7 days
(0 Reviews)

please check PMB.

$600 USD in 6 days
(0 Reviews)

Directly from Excel also the URL details can be given.I have earlier did this from Indian stock market site and refreshed excel at specific time interval.I would take this up. Thanks

$300 USD in 20 days
(0 Reviews)