Serving the Quantitative Finance Community

 
User avatar
hube
Posts: 0
Joined: October 8th, 2003, 1:15 am

Access & Bloomberg API

October 8th, 2003, 1:20 am

This topic is SUPER!! I have been creating spreadsheets in Excel that grabs data from bloom using blp formula. Now I think I wasted so much time. Would you guys know any forum that's dedicated to the these topics??? I want to see some examples of ppl develope using the bloom API. Hubert
 
User avatar
Gamanti
Posts: 0
Joined: February 25th, 2003, 7:30 pm

Access & Bloomberg API

October 9th, 2003, 10:07 am

Hube,Just type wapi on your bloomberg and you'll get to the ActiveX website. then download the help and have a look around. there are a few coding examples available that I found pretty complete and neat for most uses. Then you just have to build up from there.Hope this helps,G
 
User avatar
WannaBeDude
Posts: 0
Joined: April 1st, 2003, 12:36 pm

Access & Bloomberg API

October 9th, 2003, 12:14 pm

Hi all, Since there are so many people here doiing blp automation stuff i thought i would ask this question: i primarly used to do the blp api stuff from excel vba, which was ok, and works pretty fine. a few months back we decided ( for good reasons ) to port a lot of stuff over into .NET. i read on the wapi somewhere( i guess in the faq) that blp doesnt support the .NET stuff yet. so i started using the interoperability to call the functions in vb, which get the data from blp.. but surprise of surprises, one day i was messing around with the references in the .NET environment, and i saw the familiar blp dll. i added this reference and beleive it or not i can do all the stuff that i used to do in vba in c#. and for some reason it works faster. i think i am messing up something somewhere, and dont have the expertise to know if what i am doing is right.. can someone help me out here.. Thanks
 
User avatar
FDAXHunter
Posts: 14
Joined: November 5th, 2002, 4:08 pm

Access & Bloomberg API

October 9th, 2003, 2:26 pm

Wannabedude,You simply created a .NET wrapper for the COM API. Simple as that.http://www.csharphelp.com/archives3/arc ... 8/Interop/
 
User avatar
WannaBeDude
Posts: 0
Joined: April 1st, 2003, 12:36 pm

Access & Bloomberg API

October 9th, 2003, 2:31 pm

hi FDAXHunter,, thanks dude. good links .
 
User avatar
Silvershark
Posts: 0
Joined: November 10th, 2002, 2:27 pm

Access & Bloomberg API

October 10th, 2003, 6:47 am

QuoteOriginally posted by: FDAXHunterWannabedude,You simply created a .NET wrapper for the COM API. Simple as that.http://www.csharphelp.com/archives3/arc ... nterop/And enter the wonderful world of .Net ;-)"Once spunt into the net I never got out"
 
User avatar
WannaBeDude
Posts: 0
Joined: April 1st, 2003, 12:36 pm

Access & Bloomberg API

October 10th, 2003, 11:30 am

i got into .net a few months back, and beleive me theres no looking back. i like the stuff. ijust wish it were a littlt easier to find information about some stuff that i have abouts nowand then....
 
User avatar
fiberangel
Posts: 0
Joined: October 27th, 2003, 8:25 pm

Access & Bloomberg API

October 27th, 2003, 8:44 pm

I'm trying to get Beta for a specific stock out of bloomberg terminal and store/display it in the DB/GUI that I'm writing. I have nothing so far (started this a day ago).Any hints would be greatly appreciated.Thanks
 
User avatar
WannaBeDude
Posts: 0
Joined: April 1st, 2003, 12:36 pm

Access & Bloomberg API

October 27th, 2003, 9:04 pm

hi, you can get started by tying wapi on the bloomberg terminal...... it has plenty of examples. Good Luck.
 
User avatar
rgablejr
Posts: 0
Joined: October 27th, 2003, 8:50 pm

Access & Bloomberg API

October 27th, 2003, 11:46 pm

WAPIIf you're looking for fully commented, open-source VBA examples, search WAPI VBA Examples or use keyword DDEVBA01 as your search criteria. Really easy to navigate if you know how to use a mouse The next best solution is to use <HELP><HELP> and have your question escalated to APEXS - API Escalation Support and Solutions. You'll get a phone call. You'll get a real answer. You'll realize the answer was on WAPI if you didn't RTFM.~Peace
Last edited by rgablejr on October 27th, 2003, 11:00 pm, edited 1 time in total.
 
User avatar
skimania
Posts: 0
Joined: October 28th, 2003, 7:49 pm

Access & Bloomberg API

October 28th, 2003, 8:06 pm

Hey All,I have a question that can't be answered by WAPI or the API Dev Group because the respond that they do not support .net.So, I have been working with writing a .net bloomberg data server which uses remoting to distribute blp data to our office (yes we have the data distribution license).the deal here is that I want my VB.NET app to do a BlpData.Subscribe and have Blp Hit back to a function everytime data gets updated.The problem, is that although everything *seems* to be coded correctly, my Blp_Data function (Or the status one) never get called.NE Suggestions?Here's The Code:<pre type="man I wish you guys had a [PRE] fake html tag so that my code would remain indented and easy to view.... well, thats just too bad>Public Class BpsConsole Private Shared WithEvents Blp As New BLP_DATA_CTRLLib.BlpData <STAThread()> _ Shared Sub Main() Try ' RemotingConfiguration.Configure("BPService.config") ' Console.WriteLine("BPService is initialized and running. Hit enter to stop and exit.") Console.WriteLine("Subscribing") Blp.ActivateRealtime = True Blp.Subscribe("IBM Equity", 1, "PX_LAST") Blp.Flush() Console.WriteLine("Did subscribe") Console.ReadLine() Catch ex As Exception Console.WriteLine("Exception while starting BPS. Error Message: " + ex.Message) Console.WriteLine("Stack Trace: " + ex.StackTrace) Console.WriteLine("BPService initialization failed. Hit enter to exit.") Console.ReadLine() End Try End Sub Shared Sub Blp_Data(ByRef Security As Object, ByRef cookie As Integer, ByRef Fields As Object, ByRef Data As Object, ByRef status As Integer) Handles Blp.Data Console.WriteLine("[Blp_Data]") End Sub Private Shared Sub Blp_Status(ByRef Status As Integer, ByRef SubStatus As Integer, ByRef StatusDescription As Object) Handles Blp.Status Console.WriteLine("[Blp_Status]") End SubEnd Class[/PRE]
 
User avatar
rgablejr
Posts: 0
Joined: October 27th, 2003, 8:50 pm

Access & Bloomberg API

October 28th, 2003, 11:10 pm

Good evening skimania, .NET is not supported yet. Only support for Sun Solaris, Delphi, MFC, VB60, and VBA. I've talked with a few developers who were able to get their Data and Status events fired. If I can get some snippets from them, I'll post it here.In the interim, you may want to consider joining the .NET Beta group. Simply use <Help><Help> and ask to be put on the .NET Beta list.~Peace
Last edited by rgablejr on October 28th, 2003, 11:00 pm, edited 1 time in total.
 
User avatar
Silvershark
Posts: 0
Joined: November 10th, 2002, 2:27 pm

Access & Bloomberg API

October 29th, 2003, 6:33 am

skimania, I don't thint u can use New keyword together with With Events. You must first declare your object and instanciate it afterwords.Have a look at the office application event sample at:http://msdn.microsoft.com/library/en-us ... s.asp?Hope this helps.cheers
 
User avatar
skimania
Posts: 0
Joined: October 28th, 2003, 7:49 pm

Access & Bloomberg API

October 29th, 2003, 2:49 pm

rgablejr >> did I not say that blbg doesn't support .net! it sucks tho, because they should support whatever they're clients are using. it's coming soon tho I guess. thanks for the heads up about the .net beta group, I hope they send me some good stuff. And yes, if you find some code that fires the data event, PLEASE post it for the world to see. Apparently, someone else I have spoken with managed to do it with c# about a year ago, but I'm still waiting on her code - we'll see....Silvershark >> i appreciate the idea, but I tried it and it made no difference. the sample you sent me reffered to vb6 and not vb.net tho, and they are very different. If this werent a finance forum I would go into the technical details of lazy instantiation, but I doubt any of you really give a $@!#.Thanks for all your help guys, but it's not over yet!
 
User avatar
rgablejr
Posts: 0
Joined: October 27th, 2003, 8:50 pm

Access & Bloomberg API

October 29th, 2003, 2:52 pm

Good day skimania, You did say so, but so did I I will do a bit of 'sniffing around' today to see if I can find a snippet. Once I find it, I will post it.~Peace
Last edited by rgablejr on November 12th, 2003, 11:00 pm, edited 1 time in total.