| Both sides previous revision Previous revision | |
| gl_excel:fedrptavgbal [2014/03/13 21:26 UTC] – [FedRptAvgBal] mwolfe | gl_excel:fedrptavgbal [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1 |
|---|
| **WARNING**: This function ignores the day parts of AvgBalDate and StartDate. The function always calculates daily averages beginning with the first day of the starting month and running through the last day of the ending month. | **WARNING**: This function ignores the day parts of AvgBalDate and StartDate. The function always calculates daily averages beginning with the first day of the starting month and running through the last day of the ending month. |
| |
| %InlineCode{FedRptAvgBal(RptName, LineNum, AvgBalDate, //Company//, //PosNeg//, //StartDate//)}% | **FedRptAvgBal(RptName, LineNum, AvgBalDate, //Company//, //PosNeg//, //StartDate//)** |
| ==== Example Usage ==== | ==== Example Usage ==== |
| * %InlineCode{=FedRptAvgBal("TFR", "SC11", "7/31/2009")}% Returns the daily average balance for TFR line SC11 (Total Cash, Deposits, and Investment Securities) during the month of July, 2009. | * **=FedRptAvgBal("TFR", "SC11", "7/31/2009")** Returns the daily average balance for TFR line SC11 (Total Cash, Deposits, and Investment Securities) during the month of July, 2009. |
| * %InlineCode{=FedRptAvgBal("TFR", "SC26", "6/30/2009", , ,"1/1/2009")}% Returns the daily average balance for TFR line SC26 (Total Mortgage Loans) during the first two quarters of 2009. | * **=FedRptAvgBal("TFR", "SC26", "6/30/2009", , ,"1/1/2009")** Returns the daily average balance for TFR line SC26 (Total Mortgage Loans) during the first two quarters of 2009. |
| * Note the two extra commas between the AvgBalDate and the StartDate. Those must be included because the Company and PosNeg parameters are not specified. | * Note the two extra commas between the AvgBalDate and the StartDate. Those must be included because the Company and PosNeg parameters are not specified. |
| * %InlineCode{=FedRptAvgBal("Call", "RI-4518", "3/17/2009", , "D", "10/22/2008")}% Returns 'Credit Balance' because the daily average balance for line RI-4518 of Federal Report "Call" for the last quarter of 2008 and first quarter of 2009 is a debit balance. The "D" in our formula told Excel to only display the balance if it was a debit. See below for more information about the PosNeg parameter. | * **=FedRptAvgBal("Call", "RI-4518", "3/17/2009", , "D", "10/22/2008")** Returns 'Credit Balance' because the daily average balance for line RI-4518 of Federal Report "Call" for the last quarter of 2008 and first quarter of 2009 is a debit balance. The "D" in our formula told Excel to only display the balance if it was a debit. See below for more information about the PosNeg parameter. |
| | |
| ==== Required Paramaters ==== | ==== Required Paramaters ==== |