Add the Spreadsheet Study study to your chart, set the Chart Region to 1, and give it a name in the Spreadsheet Name field.
On the Subgraphs tab, set the Draw Style of SG1 and SG2 to Point, set the Width to 0, check Show in Name Label, set Horizontal Align to Far Right.
Click OK and OK
On the spreadsheet, put these in the following cells:
Cell K2: =K3
Cell K3: =C4
Cell L2: =L3
Cell L3: =D4
Also, you'll need to lock some fillspace to make room for the numbers. Scroll the chart so that the last bar is some distance from the right edge. Then click on Chart >> Chart Settings >> Advanced tab >> check Lock Fill Space.
Last edited by tomgilb; December 6th, 2011 at 11:14 PM.
Your instructions were great. A lot better than sierra. However I am now perplexed. As you can see from the attached pic, the numbers need to be set to 2 decimal places, however I cannot see where to change this. Any ideas? I tried number format on the cells, but alas to no avail.
Last edited by Mickey Caine; December 7th, 2011 at 06:36 AM.
Try changing the formulas in these cells to the following:
Cell K2: =ROUND(K3,2)
Cell L2: =ROUND(L3,2)
Unfortunately, the display will not hold two decimal places (two zeros) if the result equals the integer, or 1/10 of the integer (one zero), even when the value in the cell does hold those places. I hope this is not an issue because I do not know a workaround.
@Mickey Caine, looking at the title of this thread "looking to put price on the chart", I can see where you went wrong.
Why, oh why, would you need price on a chart?? With so many beautiful indicators, surely price is just a distraction, a relic of the past.
Due to time constraints, please do not PM me if your question can be resolved or answered on the forum.
Need help? 1) Stop changing things. No new indicators, charts, or methods. Be consistent with what is in front of you first. 2) Start a journal and post to it daily with the trades you made to show your strengths and weaknesses. 3) Set goals for yourself to reach daily. Make them about how you trade, not how much money you make. 4) Accept responsibility for your actions. Stop looking elsewhere to explain away poor performance. 5) Where to start as a trader? Watch this webinar and read this thread for hundreds of questions and answers. 6) Help using the forum? Watch this video to learn general tips on using the site.
If you want to support our community, become an Elite Member.