FQL: Date Math, Functions, & Formatting

Question 1

What is Date Math?

Answer 1

• Date math allows you to return a date relative to another.

Question 2

True or false? You can embed other FactSet codes inside other codes?

Answer 2

• True.

Question 3

Where can you change your calendar settings globally?

Answer 3

• Preferences > System Wide Preferences > Localization.

Question 4

What are the codes for changing calendar and currency setting in templates only?

Answer 4

• PSETCAL(X).
• PSETCURR.

Question 5

What are the AND/OR conditions in FQL?

Answer 5

• && and ||.

Question 6

What are the EQUAL and NOT EQUAL conditions in FQL?

Answer 6

• == and !=.

Question 7

How can FactSet read templates down a column?

Answer 7

• Use the code ^COL at the top of the template?

Question 8

How do you replace #N/As with zero or blank cells?

Answer 8

• 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.