Support Board
Date/Time: Fri, 29 Nov 2024 18:29:52 +0000
Post From: TEXT(Value, Format)
| [2023-01-26 14:09:24] |
| User719206 - Posts: 93 |
|
ah ok sorry, if it was not clear, and thanks a lot to take care! In fact when a trade is trigered , i catch some data and I Send it text tag. the big number represent all the data, a kind of ID card of the trade. by exemple if the number is 526345, the 52 represent the bid and ask percentage , the 63 represent the retracement and the 45 represent the expansion . it's usefull to analyse backtest , at the end of the day you just have to copy past the trade activity log in excell by exemple to make pivot table ,and you have all the information about the trade and if it's a wining or a loosing trade. the text tag cell j102 only accpet text data this is why i need to a text format for this big number. I just found the solution , we can add text cell ! if c5 = 85 and c6=31 in text format with the formula that you gave me, c5+c6 = 8531 and there is no limitation for large number. thanks for your help ! Date Time Of Last Edit: 2023-01-26 14:31:07
|
Attachment Deleted.  DefaultSpreadsheetSystemForTradingStudy.scss - Attached On 2023-01-26 14:16:10 UTC - Size: 30.52 MB - 140 views |