SP.STR

SP.STR allows you to pull data from the singlepane STR database.

SP.STR has the following arguments, which can either be entered directly into the formulas surrounded by quotation marks, or entered by cell reference (A1).

Property Code - a unique singlepane property code, usually three letters. All property codes that are authorized under your account can be found in the "My Properties" excel tab that is automatically created in the workbook when you log-in to the add-in.

Date - A date formatted either as a string in the "YYYY-MM-DD" format, or a regular excel serial date (M/D/YYYY). See aggregate type argument below for more details on the date to use for various time aggregations.

Aggregate Type - SP.STR offers the following aggregate types (CASE SENSITIVE) :

• month - Use the last date of the month in the date argument. If the monthly STR has been received, the function will return the monthly STR data. If no monthly STR has been received, the function will return MTD if available.

• monthToDate - Use the date of the Saturday that the STR week ended.

• day - Use any date

• currentWeek - Use the date of the Saturday that the STR week ended.

• running28Days - Use the date of the Saturday that the STR week ended.

• yearToDate - Use the last date of the month in the date argument.

• running3Month - Use the last date of the month in the date argument.

• running12Month - Use the last date of the month in the date argument.

Metric - SP. STR offers the following metrics:

• Occ

• ADR

• RevPAR

• Occ % Chg

• ADR % Chg

• RevPAR % Chg

• MPI

• ARI

• RGI

• MPI % Chg

• ARI % Chg

• RGI % Chg

• Occ Rank

• ADR Rank

• RevPAR Rank

• Occ % Chg Rank

• ADR % Chg Rank

• RevPAR % Chg Rank

Subject/Comp/Market - The subject/comp/market argument tells the function whether to return the subject hotel, a compset or the Market Scale.

• Subject

• CS1, CS2, CS3..etc

• Market Scale

Note when pulling Index, Index % Chg, Rank or Rank % Chg metrics you can use either Subject to return the Primary CS, or a CSX or Market Scale argument to specific which index or rank comparison to use.

Market Segment - The following market segments are available in the function:

• Total

• Group

• Contract

• Transient

Example:

=SP.STR("ACD","2023-06-30","month","RGI","CS2","Total")

Will return the June 2023 total hotel RGI for the month against Comp Set 2.

Using cell references: