The other-other problem is that this got really bogged down and unstable when a dozen people used it at once. I couldn't get it to do this in the background. The other problem is that it would essentially render the Excel on that computer useless since it was constantly busy with this. It all worked kind of like a (very slow, and somewhat unstable) API. The requesting computer would retrieve the results file and populate it in the cell, overwriting the formula with a static value. If the file was present, it would populate it into a sheet, wait for the values to populate, then output the values to a results file on the network. The BBG Excel would check every minute for a file in a network folder. The requesting Excel would write a formula with a specialized function - this function would output a request file and save it to a shared network drive. Well, I mean, BBG is designed not to let you, but I've come up with a workaround once before. It's like asking if you can reach a webpage when your internet connection is shut off. It'd be so much easier if I could just run the macro and directly query the BBG API from the macro.ĪFAIK that's just literally impossible. The second Macro copy/pastesValues and blah blah blah. If it hasn't, it sets up another OnTme for 30 more seconds and ends. The OnTime kicks off a second macro which confirms that everything has been updated. Macro sets up an application.OnTime for 30 seconds from 'now' and ends.īecause no macros are running, the BBG formulas populate Macro dumps the symbols and sets up the sheets formulas I've got a job, say, that dumps a bunch of tickers and needs them updated, then paste values and sent out. Are you wanting to run a macro on the tab with live BBG data? Usually my usage of Bloomberg is: update data, copy paste values on another tab, run a macro. Not sure I understand your question here. I've got a terminal on the network and a BBGA that's (during COVID) remote.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |