Charts, charts and more charts
- Thread starter Artycharty
- Start date
- Watchers 36
Phylo
Senior member
- Messages
- 3,039
- Likes
- 341
Demo Account used for coding -
While coding, TSLA has gotten into trouble to the tune of $2,801.92.
A review of below technical analysis - images, One, Two & Three - indicates the uncertainty of recovery of losses and requisite for vigilance to avoid getting into trouble.
The situation is uncomplicated -
Labeling indicator columns for own use is not necessary.
Key:
column 1 - symbol
column 2 - volume (green - buy, red sell)
column 3 - points (green - profit, red - loss)
column 4 - symbol p & l (inclusive of commission & swap costs, green - profit, red - loss)
column 5 - account total p & l
column 6, 7, 8 - symbol current W1 HiLo range or past W1 HiLo range after Friday close, W2 HiLo range, HiLo range over 4 weeks.
One
Two
Three
While coding, TSLA has gotten into trouble to the tune of $2,801.92.
A review of below technical analysis - images, One, Two & Three - indicates the uncertainty of recovery of losses and requisite for vigilance to avoid getting into trouble.
The situation is uncomplicated -
- One and two could happen - losses will increase if the position is not exited prior to an immediate upward breakout.
- Three could happen - losses could be recovered, at relevant point on price descent to - (a) touch bottom range, (b) downward breakout with pullback, or (c) downward breakout without pullback (pullback is not a given certainty).
- If no positions were open, the downward breakout with pullback could offer Buy entry opportunity on the pullback upward breakout.
Labeling indicator columns for own use is not necessary.
Key:
column 1 - symbol
column 2 - volume (green - buy, red sell)
column 3 - points (green - profit, red - loss)
column 4 - symbol p & l (inclusive of commission & swap costs, green - profit, red - loss)
column 5 - account total p & l
column 6, 7, 8 - symbol current W1 HiLo range or past W1 HiLo range after Friday close, W2 HiLo range, HiLo range over 4 weeks.
One
Two
Three
Symmetrical Triangles
Symmetrical triangles are chart patterns that have prices forming between converging trendlines. Read for performance statistics, trading tactics, ID guidelines and more. Written by internationally known author and trader Thomas Bulkowski.
thepatternsite.com
Last edited:
Phylo
Senior member
- Messages
- 3,039
- Likes
- 341
UPDATE: Fri 2 Aug 2024 SelectionUPDATE: Fri 2 Aug 2024 Selection
Chart Posts: https://www.trade2win.com/threads/charts-charts-and-more-charts.240207/post-3263556
1. 2 Aug 2024 Close Prices checked against Yahoo historical data.
2. 30 Aug 2024 Close Prices pulled from Google Finance - and match Yahoo historical data (when US opens these prices will live update)
Example: Cell E3: =GOOGLEFINANCE("NYSE:TSM"), Cell E4: =GOOGLEFINANCE("NASDAQ:INTC")
3. The chart labeled SMCI (above Chart Posts link) is CRWD (see watermark) - these two meant to be separate charts, but a #up.
4. UBER was missed to be included - so, is on a separated line in the spreadsheet. Another #up.
5. Light green = profit. Light red = loss. Bright blue cyan = 100% or > profit. (whoever, is responsible for the palette at google should be shot !)
6. When a target of 100% or > hit, the cell will turn bright blue cyan (set as required in Conditional Formatting). When profits decided to be taken the GoogleFinance price updating link can be knocked-out and the price set as a final static non updating record.
Google Sheets -
View attachment 337365
7. Adding columns - the formula at Cell E16: =Sum(E3:E15)
8. The P n L % formula use - Example Cell G3: =((E3/D3)-1)*100 (this is faster - for me - on hand help calculators, so, second nature - the calculator does not require the brackets)
9. This is probably more intuitive and also will work for Pn L %: =((E3-D3)/D3)*100
Note: Formulas are copy and pasted from the imaged working spreadsheet. If formulas are not working for you - check, what you have done.
Any number of online calculators
The calculator return value will be seen match that of the spreadsheet at Cell G3.
View attachment 337359
Percentage Increase Calculator
Percentage increase calculator calculates the increase of one value to the next in terms of percent.www.omnicalculator.com
Original Chart Post: https://www.trade2win.com/threads/charts-charts-and-more-charts.240207/post-3263556
1. Update Aug 2024: https://www.trade2win.com/threads/charts-charts-and-more-charts.240207/post-3264437
2. Update Sep 2024:
Fri 27 Sep 2024 Close Price
Last edited:
Phylo
Senior member
- Messages
- 3,039
- Likes
- 341
Phylo
Senior member
- Messages
- 3,039
- Likes
- 341
Update: Fri 1 Nov 2024
1. 2 Aug 2024 Close Prices checked against Yahoo historical data.
2. 1 Nov 2024 Close Prices pulled from Google Finance - and match Yahoo historical data (when US opens these prices will live update)
Example: Cell E3: =GOOGLEFINANCE("NYSE:TSM"), Cell E4: =GOOGLEFINANCE("NASDAQ:INTC")
3. The chart labeled SMCI (above Chart Posts link) is CRWD (see watermark) - these two meant to be separate charts, but a f-up.
4. UBER was missed to be included - so, is on a separated line in the spreadsheet. Another f-up.
5. Light green = profit. Light red = loss. Bright blue cyan = 100% or > profit. (whoever, is responsible for the palette at google should be shot !)
6. When a target of 100% or > hit, the cell will turn bright blue cyan (set as required in Conditional Formatting). When profits decided to be taken the GoogleFinance price updating link can be knocked-out and the price set as a final static non updating record.
Google Sheets -
www.sharecast.com
Nasdaq - 1 year: Normal market wear & tear - nothing major
1. 2 Aug 2024 Close Prices checked against Yahoo historical data.
2. 1 Nov 2024 Close Prices pulled from Google Finance - and match Yahoo historical data (when US opens these prices will live update)
Example: Cell E3: =GOOGLEFINANCE("NYSE:TSM"), Cell E4: =GOOGLEFINANCE("NASDAQ:INTC")
3. The chart labeled SMCI (above Chart Posts link) is CRWD (see watermark) - these two meant to be separate charts, but a f-up.
4. UBER was missed to be included - so, is on a separated line in the spreadsheet. Another f-up.
5. Light green = profit. Light red = loss. Bright blue cyan = 100% or > profit. (whoever, is responsible for the palette at google should be shot !)
6. When a target of 100% or > hit, the cell will turn bright blue cyan (set as required in Conditional Formatting). When profits decided to be taken the GoogleFinance price updating link can be knocked-out and the price set as a final static non updating record.
Google Sheets -
US close: Stocks sharply lower following tech earnings, PCE reading
US close: Stocks sharply lower following tech earnings, PCE reading
Wall Street stocks closed sharply lower on Thursday as market participants were again zeroed in on Q3 earnings and a number of key data points.
www.sharecast.com
Last edited:
Phylo
Senior member
- Messages
- 3,039
- Likes
- 341
Does Warren Buffet know something we don't as he makes shocking move to sell popular stocks?
Does Warren Buffet know something we don't know?
Wall Street is pouring funds into stocks as the market surges to new highs in the wake of Donald Trump's re-election.
Phylo
Senior member
- Messages
- 3,039
- Likes
- 341
Update: Fri 6 Dec 2024
1. 2 Aug 2024 Close Prices checked against Yahoo historical data.
2. 1 Nov 2024 Close Prices pulled from Google Finance - and match Yahoo historical data (when US opens these prices will live update)
Example: Cell E3: =GOOGLEFINANCE("NYSE:TSM"), Cell E4: =GOOGLEFINANCE("NASDAQ:INTC")
3. The chart labeled SMCI (above Chart Posts link) is CRWD (see watermark) - these two meant to be separate charts, but a f-up.
4. UBER was missed to be included - so, is on a separated line in the spreadsheet. Another f-up.
5. Light green = profit. Light red = loss. Bright blue cyan = 100% or > profit. (whoever, is responsible for the palette at google should be shot !)
6. When a target of 100% or > hit, the cell will turn bright blue cyan (set as required in Conditional Formatting). When profits decided to be taken the GoogleFinance price updating link can be knocked-out and the price set as a final static non updating record.
Google Sheets -
1. 2 Aug 2024 Close Prices checked against Yahoo historical data.
2. 1 Nov 2024 Close Prices pulled from Google Finance - and match Yahoo historical data (when US opens these prices will live update)
Example: Cell E3: =GOOGLEFINANCE("NYSE:TSM"), Cell E4: =GOOGLEFINANCE("NASDAQ:INTC")
3. The chart labeled SMCI (above Chart Posts link) is CRWD (see watermark) - these two meant to be separate charts, but a f-up.
4. UBER was missed to be included - so, is on a separated line in the spreadsheet. Another f-up.
5. Light green = profit. Light red = loss. Bright blue cyan = 100% or > profit. (whoever, is responsible for the palette at google should be shot !)
6. When a target of 100% or > hit, the cell will turn bright blue cyan (set as required in Conditional Formatting). When profits decided to be taken the GoogleFinance price updating link can be knocked-out and the price set as a final static non updating record.
Google Sheets -
Phylo
Senior member
- Messages
- 3,039
- Likes
- 341
Symmetrical Triangles
Symmetrical triangles are chart patterns that have prices forming between converging trendlines. Read for performance statistics, trading tactics, ID guidelines and more. Written by internationally known author and trader Thomas Bulkowski.
thepatternsite.com
Last edited:
Phylo
Senior member
- Messages
- 3,039
- Likes
- 341
RECAP
Posted: 10 Sep 2024 : : #16.782 : https://www.trade2win.com/threads/charts-charts-and-more-charts.240207/post-3267345
Posted: 13 Dec 2024 : : #16,789 : https://www.trade2win.com/threads/charts-charts-and-more-charts.240207/post-3267345
Posted: 10 Sep 2024 : : #16.782 : https://www.trade2win.com/threads/charts-charts-and-more-charts.240207/post-3267345
Posted: 13 Dec 2024 : : #16,789 : https://www.trade2win.com/threads/charts-charts-and-more-charts.240207/post-3267345
Phylo
Senior member
- Messages
- 3,039
- Likes
- 341
Post #16,790: Error - Buy Date: 22-Aug-2024. Correction: As image - 08/15/2024 - 09.57 (15-Aug-2014)
Post #16.791: Same as above - see post
Last edited:
