Friday, May 24, 2013
Lunch Adventure: 5-24-13
Spinelli's Spicy Beef. It's hard to be unhappy about beef, bacon, cheese and mayo. Z added Zappos chips just to complete the picture. I drank 1/2 a Pepsi. Nice to be out from under the tyranny of the Goldman-owned cafeteria. Traded office gossip and read about wacky shit in the Short North Gazette.
Friday, December 11, 2009
More Learnings (sic) from the Offsite
1) If I knew I was going to get nuzzled I would have wiped my nose.
2) Jim can't see normally, let alone with smeary glasses.
3) "That's why I always carry a gun - in case you need to put a deer out of its misery."
4) VIP passes are only good till Jan-01.
2) Jim can't see normally, let alone with smeary glasses.
3) "That's why I always carry a gun - in case you need to put a deer out of its misery."
4) VIP passes are only good till Jan-01.
Tuesday, April 28, 2009
Monday, April 02, 2007
Things I Have Learned...
- Don't do card tricks while driving
- "Keep the whores in the bathroom"
- "I'm too old to fight - I just stab"
- "Everyone outside the city carries a knife"
- Sometimes just filling up your tank can lead to surprises
- It is not easy to live in the triangle of death
- Old folks seem to feel compelled to plug themselves into the slots
- Even 2 minute showers can be deemed "suspicious"
- Mo's has good food (and the Moasis)
- Heavy rocks leaning on twigs don't always catch squirrels
- Bet big when Carl does - and when Colin Powell is rollin'
- 2 Star Wars slots are not enough
- "Keep the whores in the bathroom"
- "I'm too old to fight - I just stab"
- "Everyone outside the city carries a knife"
- Sometimes just filling up your tank can lead to surprises
- It is not easy to live in the triangle of death
- Old folks seem to feel compelled to plug themselves into the slots
- Even 2 minute showers can be deemed "suspicious"
- Mo's has good food (and the Moasis)
- Heavy rocks leaning on twigs don't always catch squirrels
- Bet big when Carl does - and when Colin Powell is rollin'
- 2 Star Wars slots are not enough
Friday, May 19, 2006
BB notes from Greg
Problem:
Excel BLP functionality was not working. Additionally, Bloomberg DDE Server popped up a message saying "Unable to initialize the Time Zone Adjustment feature: request timed out"
Steps to Resolve the Problem:
Turn off TaskMaster service (if appropriate)
End process on bbcomm.exe and blp.exe. Make sure that bbcomm does not relaunch, and it will if something on the machine is still trying to access BBG data (i.e. Excel, wl_Rates, DataExtracter, etc)
Delete file: c:\blp\api\monitor.rte
Run program: c:\blp\api\mkmonrte.exe with the following inputs: 2, [default], 208.134.161.30, [default], 208.134.161.62, [default]
Run program: c:\blp\api\bbcomm.exe; click Defaults; point Route file to the just created .rte file above (c:\blp\api\monitor.rte); point Log file to c:\blp\api\bbcomm.log; verify that both IP addresses when SOCKS5 is clicked are 0.0.0.0 (the port numbers may be immaterial, I don't know); click OK
At this point, its easiest to test by opening up an Excel spreadsheet that contains BLP functionality. You can also run c:\blp\api\apidemo.exe, choose Bloomberg > Monitor, enter a security and yellow key (i.e. "IBM eqty") and click Subscribe. Click through all the status boxes that pop up until the data fields populate. If they don't after about 20 clicks or so, then call the help desk.
If everything is running, be sure to restart TaskMaster service if appropriate.
Excel BLP functionality was not working. Additionally, Bloomberg DDE Server popped up a message saying "Unable to initialize the Time Zone Adjustment feature: request timed out"
Steps to Resolve the Problem:
Turn off TaskMaster service (if appropriate)
End process on bbcomm.exe and blp.exe. Make sure that bbcomm does not relaunch, and it will if something on the machine is still trying to access BBG data (i.e. Excel, wl_Rates, DataExtracter, etc)
Delete file: c:\blp\api\monitor.rte
Run program: c:\blp\api\mkmonrte.exe with the following inputs: 2, [default], 208.134.161.30, [default], 208.134.161.62, [default]
Run program: c:\blp\api\bbcomm.exe; click Defaults; point Route file to the just created .rte file above (c:\blp\api\monitor.rte); point Log file to c:\blp\api\bbcomm.log; verify that both IP addresses when SOCKS5 is clicked are 0.0.0.0 (the port numbers may be immaterial, I don't know); click OK
At this point, its easiest to test by opening up an Excel spreadsheet that contains BLP functionality. You can also run c:\blp\api\apidemo.exe, choose Bloomberg > Monitor, enter a security and yellow key (i.e. "IBM eqty") and click Subscribe. Click through all the status boxes that pop up until the data fields populate. If they don't after about 20 clicks or so, then call the help desk.
If everything is running, be sure to restart TaskMaster service if appropriate.
Friday, January 13, 2006
Thursday, January 12, 2006
Sub Routine from Pucci
Sub RetrieveData()
Dim fname As String
fname = GetFileName
If fname = "" Then Exit Sub
Workbooks.OpenText FileName:= _
fname, Origin:=437, _
StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False _
, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1), _
Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1)), TrailingMinusNumbers:=True
Dim DataSheet As Worksheet
Dim MasterSheet As Worksheet
Set DataSheet = Workbooks("HANOSEKMTN.risk.consol.tab").Sheets("HANOSEKMTN.risk.consol")
Set MasterSheet = Workbooks("MTN_Key_Rate_DV01.xls").Sheets("DV01")
Application.DisplayAlerts = False 'Turn off before saving
DataSheet.Range("A1:F150").Copy
MasterSheet.Range("A1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Workbooks("HANOSEKMTN.risk.consol.tab").Close
Application.DisplayAlerts = True ' Turn back on
End Sub
Dim fname As String
fname = GetFileName
If fname = "" Then Exit Sub
Workbooks.OpenText FileName:= _
fname, Origin:=437, _
StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False _
, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1), _
Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1)), TrailingMinusNumbers:=True
Dim DataSheet As Worksheet
Dim MasterSheet As Worksheet
Set DataSheet = Workbooks("HANOSEKMTN.risk.consol.tab").Sheets("HANOSEKMTN.risk.consol")
Set MasterSheet = Workbooks("MTN_Key_Rate_DV01.xls").Sheets("DV01")
Application.DisplayAlerts = False 'Turn off before saving
DataSheet.Range("A1:F150").Copy
MasterSheet.Range("A1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Workbooks("HANOSEKMTN.risk.consol.tab").Close
Application.DisplayAlerts = True ' Turn back on
End Sub
Subscribe to:
Posts (Atom)