The reason its hard to come by is the fact that the JSE charges crazy amounts for the data. So why would these guys make it easily available when the JSE charges them for it.
Historical Data
Started by
CoenraadJ
, May 27 2016 07:55 AM
6 replies to this topic
#2
CoenraadJ
-
- Members
-
- 2 posts
Newbie
Posted 27 May 2016 - 11:40 AM
As said, the IG Excel API doesn't allow you to withdraw data from equities.
I will check the Bloomberg API, but think it will be quite costly.
#3
cypher
-
- Members
-
- 40 posts
Newbie
- LocationCape Town
Posted 27 May 2016 - 09:48 AM
Never got a response as to why. Also the local IG facility doesn't have the API. You have to have a UK account for that.
Eat like an elephant, **** like a bird
#4
vlam
-
- Members
-
- 120 posts
Member
Posted 27 May 2016 - 09:38 AM
API only works for indices and forex, not shares
Good to know, thanks cypher.
(sucks though..., wonder why that would be the case)
#5
cypher
-
- Members
-
- 40 posts
Newbie
- LocationCape Town
Posted 27 May 2016 - 08:45 AM
API only works for indices and forex, not shares
Eat like an elephant, **** like a bird
#6
vlam
-
- Members
-
- 120 posts
Member
Posted 27 May 2016 - 08:39 AM
IG does offer "webservices" that a programmer can use to perhaps set something like that up.
Our web API offers you an easy way to get market data, historical prices and execute trades against any of your IG accounts. It can be used with Excel (VBA), .NET, Java and any programming language that supports HTTP.
https://labs.ig.com/...ading-api-guide
Good luck Coenraad! Hope someone else can help you with the rest of your questions.
Programmers are expensive though - I'm not sure what the standard rate is for VBA programmers though, maybe they will be more affordable than asking someone to program a solution in Java or .NET (more object-orientated languages). Personally I would pay more for a Java or .NET solution though - hoping that this will imply good and maintainable code that can easily be passed to other programmers for future changes and maintenance.
Good luck!
Edited by vlam, 27 May 2016 - 08:39 AM.
#7
CoenraadJ
-
- Members
-
- 2 posts
Newbie
Posted 27 May 2016 - 07:55 AM
Hi.
I have some difficulty getting historical data for shares. I require the data in Excel, so the graphs on the IG platform is not sufficient.
The data from Google Finance seems to differ from the data on IG Platforms, and I also require some intraday data.
Does anyone know of a alternative solution? I'm willing to pay if the amounts are not unreasonable.
Furthermore, can anyone shed any light on the difference between Google Finance and IG? And is the data on Google Finance the buy or the sell price?
Thanks.
