tx count summarize

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
rain91
Posts: 112
Joined: Tue Feb 07, 2017 7:11 pm

i need to running 4 (same: excel1=excel2=excel3=excel4) excel in 4 betangel (i need to dispart/disjoin/disunite/unstick (i dont know which is the best word for this) the markets). I cant solved yet the multiple exel, because of the difficult vba codes.
The problem: I want to summarize tx count on this exels.
I tried to solve it, but after i connect to the angel it dosnt work (until i dont connect with exel and i change the tx count number cells with my hand it works :) ). How can i solve it?
rain91
Posts: 112
Joined: Tue Feb 07, 2017 7:11 pm

Nobody know the solution?:S
I made something wrong?:S
User avatar
Euler
Posts: 24700
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

If you are running multiple copies you can't easily do this. The TX count is global on one running version of Bet Angel but will be independent if you run multiple copies.
rain91
Posts: 112
Joined: Tue Feb 07, 2017 7:11 pm

Euler wrote:
Fri Aug 17, 2018 8:30 pm
If you are running multiple copies you can't easily do this. The TX count is global on one running version of Bet Angel but will be independent if you run multiple copies.
I running just "single" copies. I just want to solve it on one multiple excel, but i cant do it (which works, like i want) yet.... :(
rain91
Posts: 112
Joined: Tue Feb 07, 2017 7:11 pm

nigelk wrote:
Fri Aug 17, 2018 10:04 pm
Does this help?

https://www.youtube.com/watch?v=_YgCJb2FF-4
NO :( I know this, and tried this before, but with this way it doest work :S
Until i changed the tx count cell with hand it ok everything change and works well, but after i connect and the angel changed automtically the "tx count cell" it dosnt do nothing on the other exel...:S
rain91
Posts: 112
Joined: Tue Feb 07, 2017 7:11 pm

rain91 wrote:
Sat Aug 18, 2018 8:43 am
nigelk wrote:
Fri Aug 17, 2018 10:04 pm
Does this help?

https://www.youtube.com/watch?v=_YgCJb2FF-4
NO :( I know this, and tried this before, but with this way it doest work :S
Until i changed the tx count cell with hand it ok everything change and works well, but after i connect and the angel changed automtically the "tx count cell" it dosnt do nothing on the other exel...:S
So yeah its work, but after i opened the excel from Angel then it dosnt work :S
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

Do you have calculation options set to manual or automatic in excel?
rain91
Posts: 112
Joined: Tue Feb 07, 2017 7:11 pm

spreadbetting wrote:
Sat Aug 18, 2018 1:08 pm
Do you have calculation options set to manual or automatic in excel?
I dont know what you think exactly. i attached 2pictures i think one of these should be what you wrote.
Please check the pictures to me.
1.JPG
You can see that the "connection properties" option is inactive (grey), i cant click on it :S
2.JPG
You do not have the required permissions to view the files attached to this post.
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

I wouldn't have a clue as I can't understand whatever language it's in.

You should go onto an excel forum in your own language as it's nnot a hard thing to sum data from different worksheets and they should be able to sort it out very quickly for you.
CallumPerry
Posts: 575
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

Surely you just want something simple like this:

https://www.youtube.com/watch?v=PszntzN3x1c

Just sum the tx count on each of your active tabs on your first tab or a dashboard tab.
rain91
Posts: 112
Joined: Tue Feb 07, 2017 7:11 pm

CallumPerry wrote:
Sat Aug 18, 2018 9:41 pm
Surely you just want something simple like this:

https://www.youtube.com/watch?v=PszntzN3x1c

Just sum the tx count on each of your active tabs on your first tab or a dashboard tab.
I made video.

https://www.youtube.com/watch?v=86til-M ... e=youtu.be

0-20sec it didnt work when i opened excels from angel...
about ~1min i just opened excels witout angel and then everything work...... so i cant understand what happend....
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

TX count is zero on both excels because you haven't created any transactions ?

In cell I5 on BetAngel__1.xls enter

='[BetAngel__1.xls]BetAngel'!$c$4 + '[BetAngel__2.xls]BetAngel'!$c$4

Then connect
Then create transacions
rain91
Posts: 112
Joined: Tue Feb 07, 2017 7:11 pm

ShaunWhite wrote:
Mon Aug 20, 2018 2:32 pm
TX count is zero on both excels because you haven't created any transactions ?

In cell I5 on BetAngel__1.xls enter

='[BetAngel__1.xls]BetAngel'!$c$4 + '[BetAngel__2.xls]BetAngel'!$c$4

Then connect
Then create transacions
It was just because the video. When there are numbers then i was problem too :s but maybe now someone can help me :) and it solved i hope. I open the excel in wrong way. I hope just this was the problem.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”