FLDS
Formulas
Overrides
Limits
Other Formulas
100
This is the setting to see only historical fields on FLDS
What is field type "static historical data"
100
This is where I can find example spreadsheets created by ADSK API reps. I can use these to assist clients and myself in ADSK Chats
What is ANLT, Excel API
100
This is the override used to specify a certain settle date for YAS formulas.
What is SETTLE_DT
100
This is the function I run to check a client's limits?
What is APIY
100
This is the formula type to get dates/periods in Excel based on a certain reference date.
What is =baddperiods()
200
This is the menu I must click on to make sure I can drag and drop from Excel
What is 99)options --> enable drag & drop
200
This is the formula to see accrued interest in Excel for a bond.
What is =bdp("Ticker","Int_Acc")
200
This is the override used to specify a certain bond price when calculating YAS_BOND_YLD
What is YAS_BOND_PX
200
This is the function I may run to check for programming codes/FAQs/ and general information on limits in Excel
What is WAPI
200
What is the formula to change 10/12/12 to 20121012.
What is =TEXT()
300
This is the function I would look at to see which fields apply to certain market sectors/security types.
What is XDM.
300
This is the formula to see cashflows as per CSHF as of a historical date in Excel
What is =bdp("ticker","DES_CASH_FLOW","SETTLE_DT=YYYYMMDD")
300
This is the override used to specify Yield to Worst rather than Yield to Maturity in a formula.
What is YAS_YLD_FLAG
300
This is the number of hits a client has to use per day
What is 500,000
300
What is the formula type to replicate DCX in Excel?
What is =bcountperiods()
400
This is the override which will allow me to get a settle date based on a custom inputed date value.
What is USER_LOCAL_TRADE_DATE
400
This is the field to pull historical G spread in Excel.
What is BLOOMBERG_MID_G_SPREAD (ask/bid as well)
400
This is the override to use when I want to see a yield curve as of a historical date
What is CURVE_DATE
400
This is the number of hits a free trial license can use per day.
What is 50,000
400
This is the parameter I must add to my BDH formula to get the price of GOOG US EQUITY everyday at 10am.
What is "recurdaily=true"
500
What is the function to mimic a client's FLDS values for troubleshooting?
What is XPRP
500
This is the formula to get DV01 from YAS into Excel
What is =bdp("Ticker","RISK_DV01_ERROR")
500
This is the override to use to make sure that cashflows are calculated properly based on the prepayment speed entered. When this field is set to 'Y', future calls to analytic fields will be based on a cashflow dynamically generated with the user specified PSA assumptions.
What is ALLOW_DYNAMIC_CASHFLOW_CALCS.
500
This is the information I must provide when sending chats to SAPI/Limits bucket
What is: client SID number or link to APIY, type of limit they have hit, any other relevant/important info you think necessary.
500
This is the parameter used to have PX_LAST output yield instead of price.
What is QtTyp=P
M
e
n
u