Bloomberg excel add in not updating
update when something else (calculation relevant) is changed on the sheet, and a recalculation is triggered that way.
I marked the UDF I am using as volatile [Excel Function(Is Volatile = true)] and now the timer callback via RTD automatically updates the worksheet without any manual user intervention.
The workbook that contains the links is called the destination workbook, and the workbook that is linked to it is called the source workbook.
If the workbook that you have opened (called a destination file) contains links to other workbooks or files (called source files), and the source files have changed, the links in the workbook that you are opening may display information that is out of date. The destination workbook contains the external reference. The external reference (or link) is a reference to a cell range in the source workbook. The source workbook contains the cell and the actual value that is retrieved and placed in the destination workbook.
Note: A sheet which contains Bloomberg formulas creating live data may not load on a PC without Bloomberg unless you save as CSV or copy/paste-as-values.When you create external references (also called links), you can control whether the external references stay up to date, and when they are updated.If another user has changed a value in a cell, Microsoft Excel does not look for the new value unless you tell it to.The tool will suggest auto-completion if you don’t happen to know the exact security or field code. You can add optional extra parameters such as which puts all the output data into one cell instead many rows/columns (requires array formulas afterwards).Note that row and column counts will be added as extra parameters automatically after the formula has called.