FQL: Date Math, Functions, & Formatting Flashcards
Write FQL formulas using date math Create dynamic FactSet functions within FQL formulas Understand how FactSet reads a template and format data using optional arguments
1
Q
What is Date Math?
A
- Date math allows you to return a date relative to another.
2
Q
True or false? You can embed other FactSet codes inside other codes?
A
- True.
3
Q
Where can you change your calendar settings globally?
A
- Preferences > System Wide Preferences > Localization.
4
Q
What are the codes for changing calendar and currency setting in templates only?
A
- PSETCAL(X).
- PSETCURR.
5
Q
What are the AND/OR conditions in FQL?
A
- && and ||.
6
Q
What are the EQUAL and NOT EQUAL conditions in FQL?
A
- == and !=.
7
Q
How can FactSet read templates down a column?
A
- Use the code ^COL at the top of the template?
8
Q
How do you replace #N/As with zero or blank cells?
A
- For zero, add the argument Z at the end of the code.
- For a blank cell, add the argument B at the end of the code.
