Author Topic: JSE End Of Day Data Download  (Read 42167 times)

Aragorn

  • Global Moderator
  • Full Member
  • *****
  • Posts: 162
  • Karma: +10/-0
    • View Profile
JSE End Of Day Data Download
« on: November 06, 2013, 08:01:45 pm »
Hi folks

Does anyone have an idea where I can get software that will download JSE EOD data (O,H,L,C,V) for free - preferably with the ability to get historic prices as well? Metastock format would be a bonus, but I can work with .txt or .csv as well.

I have been managing my portfolio using a fund manager application that allows you up to 60 times to open it before it stops and insists that you purchase a licence. I started using version 9, and when that exipired, I used v 10 (another 60 times), then v 11, and finally v 12, each giving me 60 times access. But now - over a year later - there's no later version. The management portion is not too bad (pretty good actually), but the main reason I use it is because it has a download functionality that allows for the importing of JSE EOD prices from Bloombergs, as well as historical prices. I use this to download specific share prices and then use the export facility to export such into a Metastock format file. I then use this file to import data into my charting software - which I need to plan my trading activities. The charting software does not have any download capabilities.

So why not purchase a licence you ask? Well it's a lot cheaper to buy Windows 8 - and you still have to pay additional fees for version upgrades. So in my opinion the cost of the app just for the downloading portion is not worth it. Hence my request. I am aware that you can subscribe to various data providers who are able to provide the required data, but hey!! - we all need to save as much moola as we can where we can.

So if anyone is prepared to share info and provide assistance in this regard I will be most appreciative.
« Last Edit: November 06, 2013, 08:17:16 pm by Aragorn »
Not idly do the leaves of Lorien fall.

Nios

  • Full Member
  • ***
  • Posts: 124
  • Karma: +3/-1
    • View Profile
Re: JSE End Of Day Data Download
« Reply #1 on: November 06, 2013, 10:35:22 pm »
Www.investordata.co.za, not free I believe, waiting for pricing myself.

Aragorn

  • Global Moderator
  • Full Member
  • *****
  • Posts: 162
  • Karma: +10/-0
    • View Profile
Re: JSE End Of Day Data Download
« Reply #2 on: November 07, 2013, 07:52:06 am »
Www.investordata.co.za, not free I believe, waiting for pricing myself.
Thanks Nios
They are one of the cheaper providers in SA - If I recall correctly it's R189.00 per month, but you get a discount if paid annually in advance.
But it's not free.
Not idly do the leaves of Lorien fall.

yossarian

  • Jr. Member
  • **
  • Posts: 55
  • Karma: +2/-0
    • View Profile
Re: JSE End Of Day Data Download
« Reply #3 on: November 07, 2013, 08:37:25 am »
Sharenet provide end of day data downloads.  About R60pm.  Also FNB if you subscibe to their trading setup.

Aragorn

  • Global Moderator
  • Full Member
  • *****
  • Posts: 162
  • Karma: +10/-0
    • View Profile
Re: JSE End Of Day Data Download
« Reply #4 on: November 07, 2013, 11:22:12 am »
Sharenet provide end of day data downloads.  About R60pm.  Also FNB if you subscibe to their trading setup.
Thanks Yissarian
Unfortunatly I'm not with FNB - Sharenet is R164.00 per month for the Download module.
Not idly do the leaves of Lorien fall.

yossarian

  • Jr. Member
  • **
  • Posts: 55
  • Karma: +2/-0
    • View Profile
Re: JSE End Of Day Data Download
« Reply #5 on: November 07, 2013, 02:57:17 pm »
Sharenet is R164.00 per month for the Download module.
mySharenet is about R60 pm.  You can download csv (it's actually tab separated but you get the idea).  It's possible to use something like curl if you need to.  PM me for a simple script.

yossarian

  • Jr. Member
  • **
  • Posts: 55
  • Karma: +2/-0
    • View Profile
Re: JSE End Of Day Data Download
« Reply #6 on: November 07, 2013, 03:02:27 pm »
Sharenet end of day data get finalized a bit late (I work on 0:00UTC+02 for the J200)

PlatinumWealth.co.za

  • Sr. Member
  • ****
  • Posts: 322
  • Karma: +10/-1
  • Weekend Investor
    • View Profile
    • Platinum Wealth Group
Re: JSE End Of Day Data Download
« Reply #7 on: January 23, 2017, 07:48:21 pm »
I see sharenet's prices as increased five fold.

Anywhere else where I can get the following:

Stock Exchange News Service feed
World Markets (Spot Prices)
Major Moves Up
Major Moves Down

Essentially I want to create this (With a few news sections and the likes):

www.PlatinumWealth.co.za <- South African Investment and Finance forum.

hackquin

  • I've just arrived
  • *
  • Posts: 6
  • Karma: +1/-0
    • View Profile
Re: JSE End Of Day Data Download
« Reply #8 on: March 28, 2017, 12:10:11 am »
Hi guys,

Google finance has JSE stocks these days :)

Someone made a nifty excel macro for it too.

http://investexcel.net/google-finance-stock-quotes-in-excel/

Just use the prefix "JSE:", for e.g. "JSE:NPN".

vapaie

  • I've just arrived
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: JSE End Of Day Data Download
« Reply #9 on: February 27, 2020, 01:28:44 pm »
Hi, guys.

Does anyone use AmiBroker for tech. analysis? I see Aragorn is using Metastock.
If I buy JSE EOD historical data from e.g. Sharenet, could anybody perhaps help me set-up Amibroker to update it properly?
Any help would be much appreciated.

joeman

  • I've just arrived
  • *
  • Posts: 14
  • Karma: +0/-0
    • View Profile
Re: JSE End Of Day Data Download
« Reply #10 on: March 02, 2020, 12:26:31 am »
Hi guys,

Google finance has JSE stocks these days :)

Someone made a nifty excel macro for it too.

http://investexcel.net/google-finance-stock-quotes-in-excel/

Just use the prefix "JSE:", for e.g. "JSE:NPN".

Have you had any luck using this option? My macro-enabled workbook doesn't seem to work.
Keep calm