Record data quicker than every second on Excel.

[HRacing]

Iv managed a bit of simple VBA coding and have it running currently and it is doing the job but I agree with you, iv always wanted to have a look into Python and will need to one of these days, a very powerful tool to have.

[welshboy06]

It is indeed. Now I just need to master this trading malarkey and I'll be set!

[HRacing]

I know you specifically asked for an Excel way to do this, but if you have any sort of programming experience (You mention VBA) then I'd suggest learning a little bit of python.
With little knowledge you can use LinusP's API (BetfairLightweight) and manually fetch the JSON results and save to a file. You can save these as csv, json or (with a bit more knowledge) directly to a database. One major advantage of this is you can decide how and what to store and there's a lot less CPU/Mem overhead than having excel to it. Plus you can get data in 200ms chunks if you wish.

Python is one of the more simpler languages to learn (That I've come across) and I'm sure if you give it a little time you can make something to get the data you need.

Dont fancy my chances much with Python, took me an hour to actually get the command propmt to recognise what it was

[welshboy06]

Haha yeah that can he a pain sometimes. If you did want to try it out, I'd suggest IntelliJ pyCharm. The best ide I've used, I use their java ide too.

[HRacing]

Haha yeah that can he a pain sometimes. If you did want to try it out, I'd suggest IntelliJ pyCharm. The best ide I've used, I use their java ide too.

Its like iv stepped into another world iv lived a sheltered life

[welshboy06]

Haha yeah that can he a pain sometimes. If you did want to try it out, I'd suggest IntelliJ pyCharm. The best ide I've used, I use their java ide too.

Its like iv stepped into another world iv lived a sheltered life

Funny thing is, I have the skills to make a bit or to get a lot of data collected and stored. But don't have the skills in trading to actually. Make use of it
Just keep at learning python, as I will keep at learning to trade

[HRacing]

Haha yeah that can he a pain sometimes. If you did want to try it out, I'd suggest IntelliJ pyCharm. The best ide I've used, I use their java ide too.

Its like iv stepped into another world iv lived a sheltered life

Funny thing is, I have the skills to make a bit or to get a lot of data collected and stored. But don't have the skills in trading to actually. Make use of it
Just keep at learning python, as I will keep at learning to trade

what the f**k is my .bashprofile if nothing else its great fun.