[AccessD] Bloomberg data

Thanks, everyone, for the input so far.

They currently use Excel, but the spreadsheet is just out of control (and
slow).

We did find a demo to import the data to Access from Bloomberg.  I guess
it's just time to start playing.

Reuben Cummings
GFC, LLC
phone: 812.523.1017
email: reuben at gfconsultants.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of MartyConnelly
Sent: Monday, February 21, 2005 1:25 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Bloomberg data


Bloomberg/Reuters provides a web service sort of through FIX protocol
You may need  access to the Bloomberg Tradebook, F/X, Energy or
products, or you will be unable to use the API  software.
which you may need to upload Bloomberg Trading Data into Microsoft Excel
via the FIX Protocol.
http://about.bloomberg.com/software/info_api.html

Easiest to connect in VB.Net or via excel

If they have an open webservice via SOAP then Access XP or 2003
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnxpwst2/ht
ml/odc_CmplxTypes.asp
or difficult in Access97 need something like Pocket Soap
Yahoo used to provide a downloadable xls or similar csv file with market
figues, haven't look at in a couple of years.

Or if you aren't paying for a subscription service and expect 15 minute
delay

You could pass this sort of  info through xmlhttp request and parse the
returned html
Sort of flakey cause the html could change monthly unless they return
xml which would make parsing easy
http://quote.bloomberg.com/apps/quote?ticker=rhat&x=0&y=0


Reuben Cummings wrote:

>Anyone ever dealt with data from Bloomberg (the data service providing live
>market numbers to brokers).  I have a potential client that is wanting an
>app to retreive this live data and provide constant, live analysis of that
>data based on formulas they will build and tweak.
>
>Thanks.
>
>Reuben Cummings
>GFC, LLC
>phone: 812.523.1017
>email: reuben at gfconsultants.com
>
>
>
>
>

--
Marty Connelly
Victoria, B.C.
Canada



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com