.Net & Bloomberg API
.Net & Bloomberg API
.Net & Bloomberg API
.Net & Bloomberg API
.Net & Bloomberg API
.Net & Bloomberg API .Net & Bloomberg API .Net & Bloomberg API .Net & Bloomberg API .Net & Bloomberg API .Net & Bloomberg API .Net & Bloomberg API .Net & Bloomberg API
.Net & Bloomberg API .Net & Bloomberg API
.Net & Bloomberg API
Go Back  Xtreme Visual Basic Talk > > > .Net & Bloomberg API


Reply
 
Thread Tools Display Modes
  #1  
Old 09-16-2007, 07:56 PM
nickel84sg nickel84sg is offline
Newcomer
 
Join Date: Aug 2007
Location: Singapore
Posts: 24
Smile .Net & Bloomberg API


I have a excel VBA program that extract data from bloomberg (when run on bloomberg enabled workstation). Currently thinking about converting the application from VBA to c#.net application that i can have a better control of the application.

Anyone has experiences on .Net and Bloomberg API (WAPI if i am not wrong)?
I need some advice on the license issue of creating a intranet web service that draw data from Bloomberg (web service setup on bloomberg enable station).

Another problem i face is it very hard to find example or articles regarding this issue. Any one have good link where i could have a good grab on dealing with bloomberg API?

Thank in advance
Reply With Quote
  #2  
Old 09-17-2007, 07:40 AM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

Hey Nickel,

I think that you should speak with your Bloomberg representative about this. For starters, Bloomberg is superb with in-person technical support.

Further, it really does sound like you could be crossing the line when it comes to licensing issues? If all the workstations that will be accessing your web server have a valid Bloomberg license for the data then it sounds like this could be ok -- but you should definitely contact your Bloomberg sales contact to be certain. However, if you are looking to set up a web server to provide Bloomberg data to terminals that are *not* Bloomberg licensed, then this sounds like a big no-no.

So I think that contacting Bloomberg is the right move here.
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
  #3  
Old 09-17-2007, 06:51 PM
nickel84sg nickel84sg is offline
Newcomer
 
Join Date: Aug 2007
Location: Singapore
Posts: 24
Default

Thank Mikie,

I guess i have no choice but to go to bloomberg representative regarding this issue. But i believe that the legal part you mention is quite true. Heard of the licensing problem of extracting data from bloomberg before
Reply With Quote
  #4  
Old 09-17-2007, 08:55 PM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

He Nickel,

I think that they have lower-end pricing to license the data only. At least they used to. Your Bloomberg contact would know.
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
  #5  
Old 09-27-2007, 07:01 AM
topry topry is offline
Newcomer
 
Join Date: May 2007
Posts: 23
Default

We have a .Net application that uses their API to download data once a day for reporting purposes. As Mike mentioned, they are very strict on their licensing and getting a 30 day dev license took some time and persistence (but we are a very small shop and have but a single terminal license).

The major issue we had was their cancel method...doesn't. Our original intent was to make an async multi-threaded app that would work like a data-pump. In order to do that we needed to be able to cancel any pending requests and pickup at the last known, good datapoint. Unfortunately, we found out that they do not honor their own cancel method. This resulted in our exceeding our 'data quota' for a day and triggering an onsite audit. Understandably, they wanted to know why our average usage had spiked and once we explained, there was no issue - but, we had to change to a single threaded methodology and make block requests.

On the API documentation, Bloomberg can provide that with the dev license. It was a bit sparse, but enough to do what we needed.
Reply With Quote
  #6  
Old 09-30-2007, 06:41 PM
nickel84sg nickel84sg is offline
Newcomer
 
Join Date: Aug 2007
Location: Singapore
Posts: 24
Talking

Quote:
Originally Posted by topry View Post
This resulted in our exceeding our 'data quota' for a day and triggering an onsite audit. Understandably, they wanted to know why our average usage had spiked and once we explained, there was no issue - but, we had to change to a single threaded methodology and make block requests.
Hi topry,

I don't really get what you mean by that. it is ok to exceed the data quota limit? Bloomberg is ok with the "data-pump" concept? Sorry i still reading up on this bloomberg stuff. Have found sufficient sample to allow me to draw data from bloomberg, hopefully thing go on smoothly for me.

Thanks for the reply
Reply With Quote
  #7  
Old 10-02-2007, 11:17 AM
topry topry is offline
Newcomer
 
Join Date: May 2007
Posts: 23
Default

No, they are definitely NOT ok with going over the limit. When this happened, all data from BB stopped. We had to call them and explain what happened and ask them to increase our limit - for that day. They track your average daily usage very closely, and even though we only went over one day, the testing of our app increased our average and that is what triggered the audit.

They apparently were concerned that we may be reselling/distributing their data outside our organization. Once we showed that we simply download certain numbers for reporting - something that can be done with their Excel plugin, they were ok with our usage.

Automating our reports was much easier by inserting the records into a database and running Crystal against the data, than launching Excel, running a macro, saving the XLS, running a DTS to import the XLS - yuck.
Reply With Quote
  #8  
Old 10-02-2007, 06:51 PM
nickel84sg nickel84sg is offline
Newcomer
 
Join Date: Aug 2007
Location: Singapore
Posts: 24
Default

oic.. Is there any additional operation cost involve when you increase your daily limit?

pumping the data into a database is definitely good for operation usage and report generating. Is this an against their license?
Reply With Quote
  #9  
Old 06-03-2009, 01:53 AM
Sham07 Sham07 is offline
Newcomer
 
Join Date: Jun 2009
Posts: 1
Default Bloomberg Web Service?

Hi Guys
I want to know if anyone know's whether there is a web service exposed by Bloomberg. I know about the dotnet API and we do have it but have heard whispers that there could be a Bloomberg web service somewhere out there.
Please advise.

Thank you
Sham
Reply With Quote
  #10  
Old 06-03-2009, 08:08 AM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

Hi Sham,

You should contact your Bloomberg representative about this. Their help service desk really is fantastic about helping you out with this sort of thing.

- Mike
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
.Net & Bloomberg API
.Net & Bloomberg API
.Net & Bloomberg API .Net & Bloomberg API
.Net & Bloomberg API
.Net & Bloomberg API
.Net & Bloomberg API .Net & Bloomberg API .Net & Bloomberg API .Net & Bloomberg API .Net & Bloomberg API .Net & Bloomberg API .Net & Bloomberg API
.Net & Bloomberg API
.Net & Bloomberg API
 
.Net & Bloomberg API
.Net & Bloomberg API
 
-->