General Betting
There is currently 1 person viewing this thread.
11 Feb 11
10:23
Joined:
Date Joined:
08 Aug 08
Ok, I am self taught so if this seems simple to you, please go easy on me.
How do I get my Betfair balance directly into "cell G2.
how do I formulate 2% of "Cell G2" in "Cell G3"
tia
How do I get my Betfair balance directly into "cell G2.
how do I formulate 2% of "Cell G2" in "Cell G3"
tia
sort by:
Show
per page
Replies: 13
|
By:
DO you have a row of cells with your return from each market, If you do lets assume they are in column A.
In G2 type the following: =SUM(A:A) In G3 type the following: =G2*2% I hope this explains it , as its hard to on the forum... let me know and I will see if I can explain better if that doesn't help |
|
By:
Thanks for your reply, but what I am trying to say is:
How do I set up my spread sheet to update my balance in G2 automatically so as I trade I can see what my balance is and use 2% of available bank on the next trade. I am trialling in-running trades and don´t watch or listen to the races as I find this gets in the way of my thinking. GGR |
|
By:
Update in automatically from where or are you asking how to build the spreadsheet from scratch? Are you putting you p & l from your
your trading into a spreadsheet? |
|
By:
Update in automatically from where
I knew this would get complicated, basically I want my available balance to update directly from Betfair. I have the spread sheet up and running, but I don´t want to take up time updating my balance manually. I want to use 2% of my available balance for the next trade. thanks again. |
|
By:
Sorry I can't help you so if you want it to update automatically from Betfair. Compound Magic is excellent at excel or there will be others I am sure that may give you a hand
|
|
By:
Many thanks for your help.
I am in my 50´s now and I can remember my Gran asking me to tune her new video in, I thought at the time, surely she can do something as simple as that, it´s only a video recorder. Looks like my time has come to ask the youth of to day to help me with my phone, computer, excel etc. There was a record released in the 60´s I think, called "Born To Late" Obrigado Tchau GGR |
|
By:
 no problem, and I always say if you don't ask you will never know... good luck |
|
By:
Hi GGGR,
you ask how to update via Betfair. What do you have as a connection to Betfair? Are you using one of the API's eg Gruss (IMO the best)? |
|
By:
Thanks Gitmo
I am using The Geeks Toy at the moment. |
|
By:
GGGR,
I have heard of the Geek's Toy but am not familiar with it. I think that they have a good forum. Might be worthwhile posing your question there, though you probably have thought of that already. |
|
By:
Thanks again, will give it a go.
|
|
By:
Geeks Toy doesn't offer Excel integration [yet].
|
|
By:
Thanks Rocket
Will keep learning until they do. That´s has got to be the reason The Toy is free,when they start charging I may not be able to live without it. But if it was not free, I probably not have paid for it and never realised what I was missing. |