Sort by dateSort by votes
Colin Legg
MrExcel MVP
- Joined
- Feb 28, 2008
- Messages
- 3,507
- Office Version
- 365
- Platform
- Windows
- Jun 18, 2009
- #2
It's been a while since I used the Reuters PPP add-in and O don't have it installed anymore so I can't be sure, but my first thought was to use RtGet(). There's a user guide here:
http://findb.hkkk.fi/docs/ReutersPPPro/reuters_pppro_users_guide.pdf
You could also search google to find various FAQ on Reuters sites, such as this one:
http://library.ust.hk/info/db/reuters-faq.html
As for "How-to" for using the BDH function, you can click on the Bloomberg menu | Help | Search Tab and search for "BDH". There's a very detailed explanation of the fields. Alternatively you can click on the Insert Function button next to the formula bar, select Bloomberg from the category list, choose BDH and click on the "Help on this function" hyperlink.
Hope that helps...
Upvote0
T
theta
Well-known Member
- Joined
- Jun 9, 2009
- Messages
- 960
- Jun 18, 2009
- #3
That's great!
Now im looking to build it so that I can make data static. At present I have 2 command buttons that run 2 simple macro subs :
Make Static - copies range and pastes valued
Make Live - paste RtGet formula in top cell and copy down the range
Any thoughts on how this could be done more..elegantly
Many thanks
T
Upvote0
Colin Legg
MrExcel MVP
- Joined
- Feb 28, 2008
- Messages
- 3,507
- Office Version
- 365
- Platform
- Windows
- Jun 18, 2009
- #4
With bloomberg it is possible to toggle Realtime updates on an off. You can do this by clicking on the "lightning" icon button on the bloomberg toolbar (or you can use VBA). This will make the values for the BDH formulas static, so this would seem to be a more elegant way of achieving your goal since you can just leave the formulas in situ.
Unfortunately I don't have Reuters PPP installed, but I very much expect that there will be similar functionality available for you to use. If you can't find it then you could always give the Reuters helpdesk a call and ask them.
Hope that helps...
Upvote0
T
theta
Well-known Member
- Joined
- Jun 9, 2009
- Messages
- 960
- Jun 18, 2009
- #5
Hi Colin,
The only issue I have is that the sheet is often opened on machines that do not have BBG or RTS and so the formulas generate #NAME errors as the plugins/API are not on the local machines viewing the workbook. The cut/paste values approach overcomes this, just seeing if any other thoughts?
Regards
T
Upvote0
Colin Legg
MrExcel MVP
- Joined
- Feb 28, 2008
- Messages
- 3,507
- Office Version
- 365
- Platform
- Windows
- Jun 18, 2009
- #6
If other users don't have the add-ins then yes you would have to store the hard values for them, perhaps in a separate, dedicated database? Or, if it's just for viewing purposes, presumably they could open the workbook with calculations set to manual and not updating links?
Upvote0
T
theta
Well-known Member
- Joined
- Jun 9, 2009
- Messages
- 960
- Jun 18, 2009
- #7
Hi Colin,
Found a workaround with 2 basic macros. Thanks for your help
One more thing. Is there a Bloomberg equivalent of the =RtToday() function. Basically want to see what the Bloomberg date is. If formula generates a #NAME error then Bloomberg functionality is not available, and a message will appear stating this.
using RtToday() because it will always generate a return. Is there a function that would show simply if Bloomberg is connected (or a simpler formula to test is reuters is connected)?
Regards
T
Last edited:
Upvote0
Colin Legg
MrExcel MVP
- Joined
- Feb 28, 2008
- Messages
- 3,507
- Office Version
- 365
- Platform
- Windows
- Jun 18, 2009
- #8
Hi Theta,
If the BBG add-ins aren't installed then the BBG functions won't be recognised and the formulas will return a #NAME? error. So presumably you could just check any of your bloomberg formulas? The same would be true for Reuters - I don't see how RtToday() could return anything but a #NAME? error if the Reuters add-ins aren't installed?
If the BBG add-ins are installed but there is no connection to the bloomberg BBCOMM (where the data is pulled in from) then the Bloomberg formulas will return a #N/A Connection error.
Hope that helps...
Upvote0
T
theta
Well-known Member
- Joined
- Jun 9, 2009
- Messages
- 960
- Jun 18, 2009
- #9
Hi Colin,
Yes helps. But wanted a check formula so RtTodday works fine for Reuters. Whereas for Bloomberg want a solid formula linking to a constant variable, like Bloomberg system date, rather than running a BDH formula for a specific bond. Want it non specific to draw any variable from Bloomberg, e.g. system date, and if #NAME then obviously not connected.
All fits into a front end dashbord report...?
Any thoughts?
Regards
T
Upvote0
Colin Legg
MrExcel MVP
- Joined
- Feb 28, 2008
- Messages
- 3,507
- Office Version
- 365
- Platform
- Windows
- Jun 18, 2009
- #10
Hi Theta,
I'm not aware of a BBG function like that. You could always check with the BBG helpdesk who will know a lot more about this than me.
If I wanted to do this I would write a UDF to check if the add-in is installed. Something like:
Code:
Public Function IS_BBG_INSTALLED() As Boolean Const strBBG As String = "BloombergUI.xla" Dim xlAddIn As AddIn Application.Volatile For Each xlAddIn In AddIns If xlAddIn.Name = strBBG And xlAddIn.Installed Then IS_BBG_INSTALLED = True Exit Function End If Next End Function
And then call from the worksheet:
=IS_BBG_INSTALLED()
Upvote0
You must log in or register to reply here.