We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
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. |