How to hyperlink (attach) a chart to a symbol in the TJS Trading-log
First, you'll need a screen-capture utility.
Some popular choices are
For Screen-captures:
For 'sharable' videos, images and documents
Windows users can use the basic built-in in utility already included in Windows 7 or Vista, called "Snipping Tool".
With your trading platform open, use the Capture Utility to capture the image you'd like to attach to your trade. Then, follow one of the two methods of linking your chart (or document) to the desired cell of your spreadsheet.
Preferred way...
If you want to make sure you don’t lose your hyperlinks, try the following… which will tell Excel to always look in the same location that your Excel spreadsheet is in. This involves using an actual formula command in the cell that you wish to hyperlink from... say, the symbol column!
=HYPERLINK(“Link_location”,"File_name")
Link_location refers to the file to link to
File_name is the text you’d like to display in the Excel cell
Example:
=HYPERLINK(“Trade1.doc”,”Trade1”)
Doing it this way, you’ll never lose your hyperlinks again, as long as the file names don’t change and you always keep your Excel file and your linked files in the same folder.
Conventional way...
1. In the TJS Trading-log, Right-click the symbol (or any other cell or graphic you want to represent the hyperlink). Then, click Hyperlink on the shortcut menu.
2. An Insert Hyperlink box will pop-up. Use a combination of the drop-down arrow and file folder to browse to the location you saved your file under.
3. Click on the file name of your image. - - To assign a tip to be displayed when you rest the pointer on the hyperlink, click ScreenTip and then type the text you want in the ScreenTip text box. -- Click OK.
4. The text you hyperlinked is now clickable. Clicking it will instantly open up your picture viewer and the image you associated the link with.
* The only drawback from this method is that if you ever make a change to your folders, you stand the chance of invalidating your hyperlinks.
Your done! Now use the chart hyperlinks periodically to help you review your trades and compare the charts with the notes you recorded in the Entry/Exit journal section (at the end of each trading-log row).
back to Support Page