How to display the number of stocks per day for different RSI groups
Updated on 2011-03-22 06:06:14
|
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".
|
