"Q" 2Be
New member
Since ToS has a predefined list have few symbols/ tickers are covering the 11 sectors of $SPX and introduced column for % change of current day as per the following snapshot.
My intention here is: make the user is able to fill the value of sector weighting and re-order them according from heaviest to lightest according to the quarterly update, then plot (% change of current day beside description) at the right upper corner of chart as boxes with the multiple Red, Green lightens to darkens.
mod note:
To follow along with this discussion
create the above table:
1. click on MarketWatch
2. click on Quotes
3. in the drop down table names, click on Public (S-W)
4. scroll down and click on S&P 500 Sector Indices
To add the % change of current day column:
1. click on the gear icon at the end of the column headings
2. click on customize
3. in the drop down box, type in: pct chg open
4. click on pct_Chg_Open
5. click on Add
6. click on OK
My intention here is: make the user is able to fill the value of sector weighting and re-order them according from heaviest to lightest according to the quarterly update, then plot (% change of current day beside description) at the right upper corner of chart as boxes with the multiple Red, Green lightens to darkens.
mod note:
To follow along with this discussion
create the above table:
1. click on MarketWatch
2. click on Quotes
3. in the drop down table names, click on Public (S-W)
4. scroll down and click on S&P 500 Sector Indices
To add the % change of current day column:
1. click on the gear icon at the end of the column headings
2. click on customize
3. in the drop down box, type in: pct chg open
4. click on pct_Chg_Open
5. click on Add
6. click on OK
Last edited by a moderator:
