Term
| What are the three data limits? |
|
Definition
- Amount per day (500,000 hits per day)
- Amount per month (based on a proprietary algorithm)
- Amount of real time data pulled at one time
|
|
|
Term
| How far back does Intraday Data go? |
|
Definition
|
|
Term
| Ways to download the Bloomberg Add-In |
|
Definition
- Start-> Programs->Bloomberg->Install Excel Add-in
- http://www.bloomberg.com/professional/software_support/
|
|
|
Term
|
Definition
- Bloomberg tab->Utilities Menu->Live Help->Diagnostics
- Start->Programs->Bloomberg->API Environment Diagnostics
|
|
|
Term
| Requirement for shouting to SAPI for Limits |
|
Definition
APIY S<Go> (paste the SID # from the ticket) and what type of limit they hit |
|
|
Term
|
Definition
| Located under the help button, used for when a client has an old formula in his spreadsheet such as =BLP |
|
|
Term
| What do you do when someone asks about cells showing "N/A Requesting" |
|
Definition
| Formulas tab, change Calculation Options |
|
|
Term
|
Definition
Is there data available?
Check pricing source |
|
|
Term
|
Definition
|
|
Term
| what do you need to do to run diagnostics |
|
Definition
have admin rights on your computer
close all excel/word documents |
|
|
Term
| "N/A Field Not Applicable" |
|
Definition
XDM<Go> check if a field is supported, and how it is supported, you have to type in the “ID” (calcrt) not the mnemonic in order for XDM to check the field |
|
|
Term
|
Definition
Application Programming Interface
enables your program or platform to connect with the market |
|
|
Term
| Syntax for Historical Intraday Bars |
|
Definition
| =BDH(”Ticker”,”Field”,”start date and time”,”end date and time”,”Bartp=?”,”barsz=?”) |
|
|
Term
| Syntax for Historcial Intraday Ticks |
|
Definition
| =BDH(“Ticker”,”Field”,”start date and time”,”end date and time”,”IntrRW=TRUE”) |
|
|
Term
| Syntax for Historic Formula |
|
Definition
| =BDH(“Ticker”,”Field”,”Start Date”,”End Date”,[Optional parameters]) |
|
|
Term
|
Definition
| =BDP(“ticker”,”field”, [overrides]) |
|
|
Term
|
Definition
Bid, Ask, Trade
BARTP=(B,A,T) |
|
|
Term
|
Definition
the price based in minutes
BARSZ=1,2,3, etc. |
|
|
Term
|
Definition
=BDS(“Ticker”,”field”,”optional parameters”)
When you search in FLDS the correct mnemonic will say “Show Bulk Data” in the Value column
|
|
|
Term
|
Definition
|
|
