Support Board
Date/Time: Wed, 27 Nov 2024 04:54:45 +0000
Post From: Fridays on Chart
| [2023-10-02 05:25:55] |
| j4ytr4der_ - Posts: 938 |
|
Oh and while I'm at it, I suppose I should answer the original question. You can display the date in text on a chart. 1. Set up a Spreadsheet Study. 2. In cell O2, put =CONCATENATE(MONTH(J41),"/",DAY(J41),"/",YEAR(J41)) (This will give you the date as text which you can also display on your chart if you wish)3. In cell P2, put =IF(O3=2,"MON",IF(O3=3,"TUE",IF(O3=4,"WED",IF(O3=5,"THU",IF(O3=6,"FRI","WEEKEND")))))
Now add a Text Display study to your chart, and select the appropriate cell from your spreadsheet (you'll have to set its subgraph to Hidden as well in the Spreadsheet Study itself). And there you have it, a text label of the current day on your chart. It'll have a colon at the end of it but, gets the job done. Date Time Of Last Edit: 2023-10-02 05:59:02
|