This pivot table displays, for the last 30 days, the number of stocks whose RSI value is below 50, above 50 and above 70. Steps: - Open a dashboard or create a new one by selecting "Tools" in the menu then "Open Dashboard" or "New Dashboard". - Right click on the dashboard and click on "Create Pivot Table". - Right click on the pivot table then select "Update Rows/Columns/Values". - Add a new row, select the "Dates" tab then add three "Values". - In the first value item, enter the following data: Name: RSI < 50 Formula: rsi(14) < 50 Summarize: Sum Select Dates: Last 30 days For the second value item, enter: Name: RSI > 50 Formula: rsi(14) > 50 Summarize: Sum Select Dates: Last 30 days For the third value item, enter: Name: RSI > 70 Formula: rsi(14) > 70 Summarize: Sum Select Dates: Last 30 days - Click on "OK". - Right click on the pivot table and select "Perform Calculation". 
|
|
|
|
|
