ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Change DateChange ZoneChange TypeOld Name/Affected Item NameNew NameLocation/Reason
2
08/02/2021Latest 30-Y Financials Page Change
https://docs.google.com/spreadsheets/d/1VcxpQfWDvViCGc6CQN_hRlU8NApE3KxuNMp8GyoGUTU/edit?usp=sharing
3
08/02/2021Excel GURUF/API/Customized/ScreenerNew Add1-Year OCF Growth Rate (Per Share)
Add under Growth tab in screener, customization for screener and user portfolios
4
08/03/2021Excel GURUF/API/Customized/ScreenerNew Add3-Year OCF Growth Rate (Per Share)
Add under Growth tab in screener, customization for screener and user portfolios
5
08/04/2021Excel GURUF/API/Customized/ScreenerNew Add5-Year OCF Growth Rate (Per Share)
Add under Growth tab in screener, customization for screener and user portfolios
6
08/05/2021Excel GURUF/API/Customized/ScreenerNew Add10-Year OCF Growth Rate (Per Share)
Add under Growth tab in screener, customization for screener and user portfolios
7
08/02/2021Customized User PortfoliosItem Name Change1-Year FCF Growth Rate1-Year FCF Growth Rate (Per Share)to be consistent with other places
8
08/02/2021Customized User PortfoliosItem Name Change3-Year FCF Growth Rate3-Year FCF Growth Rate (Per Share)to be consistent with other places
9
08/02/2021Customized User PortfoliosItem Name Change5-Year FCF Growth Rate5-Year FCF Growth Rate (Per Share)to be consistent with other places
10
08/02/2021Customized User PortfoliosItem Name Change10-Year FCF Growth Rate10-Year FCF Growth Rate (Per Share)to be consistent with other places
11
07/15/2021
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Result Display Change
change the display for PE ratio and PE Ratio without NRI. For companies that has negative earnings, it will display as "At Loss"; for companies that has insufficient data, it will display as "N/A" or "-"
12
06/25/2021Excel GURUF/APINew AddPB Ratio
Add Above "PB Ratio (10y High)" in current fields
13
06/25/2021Excel GURUF/APINew AddPE Ratio
Add Above "PE Ratio (10y High)" in current fields
14
06/25/2021Excel GURUF/APINew AddPE Ratio without NRI
Add Above "PE Ratio without NRI (10y High)" in current fields
15
06/25/2021Excel GURUF/APINew AddDividend Yield %
Add Above "Dividend Yield % (10y High)" in current fields
16
05/19/2021Excel GURUF/API/Customized/ScreenerNew Add12-1 Month Momentum %
Add under Price tab in screener, customization for screener and user portfolios
17
05/19/2021Excel GURUF/API/Customized/ScreenerNew Add6-1 Month Momentum %
Add under Price tab in screener, customization for screener and user portfolios
18
05/13/2021Excel GURUF/API/Customized/ScreenerNew AddQuality Rank
Add under Fundamental tab in screener, customization for screener and user portfolios
19
05/13/2021Excel GURUF/API/Customized/ScreenerItem RemovedGF Value Rankremoved due to no use
20
05/13/2021Excel GURUF/API/Customized/ScreenerItem RemovedGrowth Rankremoved due to no use
21
04/19/202130-Y Financials Page/Excel GURUF/APINew AddEarnings Release Date
Add in "Valuation and Quality" section after "Restated Filing Date" for all Templates
22
04/08/2021
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddCapex-to-Revenue
Add at the last line in "Ratio" section for all Templates
23
03/16/2021Excel GURUF/API/Customized/ScreenerNew AddTotal Revenue Growth Rate (Future 3Y To 5Y Est)
Add under Growth tab in screener, Analyst Estimate section in summary page, customization for screener and user portfolios
24
02/08/2021
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddIssuance of Debt
Add in "Cashflow Statement" section above "Payments of Debt" for all Templates
25
02/08/2021
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddPayments of Debt
Add in "Cashflow Statement" section above "Net Issuance of Debt" for all Templates
26
01/18/2021Excel GURUF/API/Customized/ScreenerItem Name ChangeBuyback YieldBuyback Yield %fix name difference bug
27
01/12/2021Excel GURUF/API/Customized/ScreenerNew AddROCE % (10y High)
28
01/12/2021Excel GURUF/API/Customized/ScreenerNew AddROCE % (10y Low)
29
01/12/2021Excel GURUF/API/Customized/ScreenerNew AddROCE % (10y Median)
30
01/12/2021Excel GURUF/API/Customized/ScreenerNew AddROCE % (5y Median)
31
11/25/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddROCE %
Add in "Ratios" section above ROIC % for non-financial Templates
32
11/04/2020Excel GURUF/CustomizedItem Name Change1-Year Share Buyback Rate1-Year Share Buyback Ratio
33
11/04/2020Excel GURUF/CustomizedItem Name Change5-Year Share Buyback Rate5-Year Share Buyback Ratio
34
11/04/2020Excel GURUF/CustomizedItem Name Change3-Year Share Buyback Rate3-Year Share Buyback Ratio
35
11/04/2020Excel GURUF/CustomizedItem Name Change3-Year Average Share Buyback Ratio (10y High)3-Year Share Buyback Ratio (10y High)
36
11/04/2020Excel GURUF/CustomizedItem Name Change3-Year Average Share Buyback Ratio (10y Low)3-Year Share Buyback Ratio (10y Low)
37
11/04/2020Excel GURUF/CustomizedItem Name Change3-Year Average Share Buyback Ratio (10y Median)3-Year Share Buyback Ratio (10y Median)
38
11/04/2020Excel GURUF/CustomizedItem Name Change10-Year Share Buyback Rate10-Year Share Buyback Ratio
39
10/19/2020Excel GURUF/API/Customized/ScreenerNew AddGF Value
40
10/19/2020Excel GURUF/API/Customized/ScreenerNew AddEstimated GF Value for Next Year
41
10/19/2020Excel GURUF/API/Customized/ScreenerNew AddPrice-to-GF-Value
42
10/19/2020Excel GURUF/API/Customized/ScreenerNew AddPrice-to-Estimated-GF-Value-for-Next-Year
43
10/19/2020Excel GURUF/API/Customized/ScreenerItem Name ChangeForward 12M DividendDividends per Share (Forward 12-Month)
44
10/19/2020Excel GURUF/API/Customized/ScreenerItem Name ChangeTrailing 12-Month DividendDividends per Share (TTM)
45
09/24/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddCash per Share
Add in "Per Share Data" section above Dividend Per share for all Templates
46
08/25/2020Excel GURUF/CustomizedItem Name ChangeMargin of Safty % (DCF Earnings Based)Margin of Safety % (DCF Earnings Based)
47
08/07/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddPiotroski F-Score
Add in "Valuation and Quality" section for Insurance Template
48
08/07/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddPiotroski F-Score
Add in "Valuation and Quality" section for Bank Template
49
07/15/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddPE Ratio without NRI
Add in "Valuation Ratios" section, between "PE Ratio" and "Price-to-Owner-Earnings" for non-financial companies
50
07/15/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddPE Ratio without NRI
Add in "Valuation Ratios" section, between "PE Ratio" and "Price-to-Owner-Earnings" for insurance companies
51
07/15/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddPE Ratio without NRI
Add in "Valuation Ratios" section, between "PE Ratio" and "Price-to-Owner-Earnings" for banks
52
07/10/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedAltman Z-Score
Removed from "Valuation and Quality" section for Bank Template; Does not apply to bank and insurance companies
53
07/10/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedPiotroski F-Score
Removed from "Valuation and Quality" section for Bank Template; Does not apply to bank and insurance companies
54
07/10/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedCurrent Ratio
Removed from "Valuation and Quality" section for Bank Template; Does not apply to bank and insurance companies
55
07/10/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedQuick Ratio
Removed from "Valuation and Quality" section for Bank Template; Does not apply to bank and insurance companies
56
07/10/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedInterest Coverage
Removed from "Valuation and Quality" section for Bank Template; Does not apply to banks
57
07/10/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedAltman Z-Score
Removed from "Valuation and Quality" section for Insurance Template; Does not apply to bank and insurance companies
58
07/10/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedPiotroski F-Score
Removed from "Valuation and Quality" section for Insurance Template; Does not apply to bank and insurance companies
59
07/10/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedCurrent Ratio
Removed from "Valuation and Quality" section for Insurance Template; Does not apply to bank and insurance companies
60
07/10/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedQuick Ratio
Removed from "Valuation and Quality" section for Insurance Template; Does not apply to bank and insurance companies
61
06/02/202030-Y Financials Page/Excel GURUF/APINew AddEBIT
add in income statement, before "Depreciation, Depletion and Amortization" for non-bank companies
62
06/02/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddPrice-to-FFO
Add in "Valuation Ratios" section, after Dividend Yield %, Only for REITs
63
05/12/2020Summary APIItem Removedrank_historyremoved due to no use
64
05/12/2020Summary APIItem Removedrank_industryremoved due to no use
65
05/12/2020Summary APIItem Removedrank_absoluteremoved due to no use
66
05/12/2020Summary APIItem Removedrank_value_globalremoved due to no use
67
05/12/2020Summary APIItem Removedrank_quality_globalremoved due to no use
68
05/07/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Change Calculation
https://www.gurufocus.com/term/ROIC/AAPL/ROIC/Apple%2BInc
69
04/30/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddGross Loan
Add in balance sheet for bank template, after "Money Market Investments"
70
04/30/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddAllowance For Loans And Lease Losses
Add in balance sheet for bank template, after "Gross Loan"
71
04/30/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddUnearned Income
Add in balance sheet for bank template, after "Allowance For Loans And Lease Losses"
72
04/16/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddChange In Other Working Capital
Add between "Change In Payables And Accrued Expense" and "Change In Working Capital"
73
04/16/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item Name ChangeChange In DeferredTaxDeferred TaxCash flow statement
74
04/15/2020Excel GURUF/Customized/ScreenerNew AddLatest Quarter End
75
04/15/2020Excel GURUF/Customized/ScreenerNew AddPrice (All-Time High)
76
04/15/2020Excel GURUF/Customized/ScreenerNew AddPrice (All-Time Low)
77
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedYoY EBITDA Growth
Removed from "Valuation and Quality" section for Banks; EBITDA does not apply to Banks
78
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item Removed5-Year EBITDA Growth Rate
Removed from "Valuation and Quality" section for Banks; EBITDA does not apply to Banks
79
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedEV-to-EBITDA
Removed from "Valuation Ratios" section for Banks; EBITDA does not apply to Banks
80
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedEV-to-EBIT
Removed from "Valuation Ratios" section for Banks; EBIT does not apply to Banks
81
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedEBIT per Share
Removed from "Per Share Data" section for Banks; EBIT does not apply to Banks
82
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedEBITDA per Share
Removed from "Per Share Data" section for Banks; EBITDA does not apply to Banks
83
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddTotal Long-Term Liabilities
Add between "Other Long-Term Liabilities" and "Total Liabilities" for non-financial companies
84
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddTotal Long-Term Assets
Add between "Other Long Term Aessts" and "Total Assets" for non-financial companies
85
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddTotal Operating Expense
Add between "Other Operating Expense" and "Operating Income" for non-financial companies
86
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddTotal Expenses
Add between "Other Expense" and "Pre-Tax Income" for Insurance companies
87
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddInterest Income
Add between "Net investment Income" and "Fees and Other Income" for Insurance companies
88
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedOther Income (Expense)
Removed from Insurance Income Statement Template
89
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedOperating Income
Removed from Insurance Income Statement Template; Does not apply to bank and insurance companies
90
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedOperating Margin %
Removed from Insurance Income Statement and common size ratios Template; Does not apply to bank and insurance companies
91
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedEBITDA
Removed from Bank Income Statement Template; Does not apply to banks
92
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedOperating Income
Removed from Bank Income Statement Template; Does not apply to bank and insurance companies
93
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
Item RemovedOperating Margin %
Removed from Bank Income Statement and common size ratios Template; Does not apply to bank and insurance companies
94
04/13/2020
30-Y Financials Page/Excel GURUF/API/Customized/Screener
New AddTotal Noninterest Expense
Add between "Other Noninterst Expense" and "SpecailCharges" for banks
95
04/02/2020Excel GURUF/CustomizedNew AddROCE %
96
04/02/2020Excel GURUF/CustomizedNew AddCapital Employed
97
03/19/2020Excel GURUF
98
03/19/2020Excel GURUFItem Name ChangevolumnDay's Volume
99
02/13/2020User financial APIItem Name ChangeROC (ROIC) %ROIC %Consistent with 30y financials page
100
02/07/2020Excel GURUF/API/Customized/ScreenerItem Name ChangeOprt. Cash Flow per share(12m) ($)Operating Cash Flow per Share (TTM)