Excel to Guardian SV's

[goldfinch77]

I have looked in here but cannot find the specific answer
Lets say i am working on the BA template Sheet2, I have value in Sheet 2 B20
Is there anyway I can get that value back into Guardian as a stored value ?

Thanks.

[ODPaul82]

SET_SV FOR:SELECTION NAME:Test1 VALUE:42 NAME:Test2 Value:99 NAME:Test3 Value:200
https://www.betangel.com/user-guide/syn ... mands.html

[goldfinch77]

Yes, I have seen all that, however I am working in Sheet2 of the BA template to do some number crunchig, the result ( a single value) I would like to get back into Guardian as Stored value so I can use it in my wonder strategy.

[ODPaul82]

Yes, I have seen all that, however I am working in Sheet2 of the BA template to do some number crunchig, the result ( a single value) I would like to get back into Guardian as Stored value so I can use it in my wonder strategy.

Then reference Sheet2 in the formula on the BA sheet
="SET_SV FOR:WHATEVER NAME:MySV VALUE:" & Sheet2!$B$20

[goldfinch77]

ODPaul82,

Thanks for the idea but I am really struggling with this, I dont understand how that works, i tried asking GPT-5 but they dont know and are telling me it can only be done in later versions.

So I am asking for some help (human I hope) from the forum.

The reason I am asking is that I am trying to create a rolling bank (in practice mode) and all i can think of is is sending the currnt bank to excel to re import back to my strategy in Guardian ( after a new new profit is made)

Any help would gratefully recieved ]

Goldfinch