Some of them are not even formulas - they just "=" the number from the other tab. I've found that if you click in the formula bar when in the source cell, and hit enter, it refreshes the cell which is linked to it.
To do this on a grand scale, I do a Find "=" & Replace with "=" for the whole workbook.
This post is a collection of frequently and infrequently asked questions about the Bloomberg Professional API, most specifically the Bloomberg Excel Add-in.
For the most part, it should be considered for experts, so please don’t be disheartened if it is too advanced for you; it’s effectively everything I know about the topic. fin = open('noblanks.txt') fout = open('withblanks.txt', 'w') for line in fin: id = line.rstrip() fout.write(id "\t=BDS(\"" id "Corp\",\"AMENDMENT_HISTORY\",\"cols=3;rows=100\")") fout.write('\t\n' * 100) fin.close() fout.close() The generated file is tab-delimited and can be opened in Excel for Bloomberg to action.
Bloomberg will automatically disconnect after 60 minutes of inactivity.
When I change the input of a formula, the output is not automatically updated. How do I get Excel to update formulas automatically again?
While this is slightly against the idea of how Excel is supposed to work, it’s very useful in practice and usually one of the first things you start missing when you change jobs and loose access to a Bloomberg terminal.
If it is, this sounds like one of the most annoying viruses in the world!
No, most likely you simply have calculations set to Manual, or something else similar such as an add-in, macro or extension e.t.c.
You can also bring this menu up by hitting the Alt D keys. This is best option and is suitable for both desktop and notebook Macs.
In Mac OS X 10.5 (Leopard), and 10.6 (Snow Leopard) please go to the Apple icon drop down menu on the top left corner of your Mac and select the option for “System Preferences”. Ensure there is no key selected within the Expose section.