Support Board
Date/Time: Sun, 19 Jan 2025 06:28:24 +0000
[Programming Help] - text strings
View Count: 1204
| [2018-03-12 00:33:18] |
| User606491 - Posts: 164 |
|
I would like to use values calculated within a spreadsheet as part of a text string. Two questions: 1) How do I get the following written in Excel to work in Sierra Chart? ="Return/Risk of "&TEXT(F8,"#.##")&"x and max loss of "&TEXT(G8,"$###") \\\\ Return/Risk of 5.53x and max loss of $1253 2) Is it possible to use the returned text string as a label on chart? thank you, |
| [2018-03-12 19:19:34] |
| User606491 - Posts: 164 |
|
Good afternoon, Any update here? thank you. |
| [2018-03-24 21:23:09] |
| User606491 - Posts: 164 |
|
I still have not received a response here. I would appreciate follow up. thank you |
| [2018-03-25 14:20:43] |
| Sawtooth - Posts: 4155 |
|
Try this: =CONCATENATE("Return/Risk of ",TEXT(F8,"0.00"),"x and max loss of $",TEXT(G8,"0000.")) https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#TEXT_Function |
| [2018-03-25 20:37:35] |
| User606491 - Posts: 164 |
|
YES! This works. Thank you, Tom.
|
To post a message in this thread, you need to log in with your Sierra Chart account: