Author Topic: Live chat  (Read 2930300 times)

Moneypenny

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1891
  • Karma: +37/-0
    • View Profile
    • Bu Valiere
Live chat
« Reply #5895 on: July 26, 2017, 11:24:39 am »
Sigh, thought I could just download to Excel somehow, sounds hectic.

Hamster

  • Hero Member
  • *****
  • Posts: 535
  • Karma: +13/-0
    • View Profile
    • Off Topic
Re: Live chat
« Reply #5896 on: July 26, 2017, 12:07:34 pm »
@Patrick, have you figured out a way to get the whole list of all the JSE instruments from them. Last time I played with it I tried http://www.bloomberg.com/markets/api/quote-members-page/JALSH:IND because it seemed to work for INDU:IND. But, alas, that didn't work out.

Patrick

  • Administrator
  • Hero Member
  • *****
  • Posts: 2551
  • Karma: +47/-2
    • View Profile
Live chat
« Reply #5897 on: July 26, 2017, 03:05:23 pm »
Nope, I haven't tried. I do see data for JALSH:IND and INDU:IND though, are you looking for something different?

Patrick

  • Administrator
  • Hero Member
  • *****
  • Posts: 2551
  • Karma: +47/-2
    • View Profile
Live chat
« Reply #5898 on: July 26, 2017, 03:06:58 pm »
@mp, if you really want an excel download page for the jse I can build a CSV generator for you that takes the data from my database.

Hamster

  • Hero Member
  • *****
  • Posts: 535
  • Karma: +13/-0
    • View Profile
    • Off Topic
Re: Live chat
« Reply #5899 on: July 26, 2017, 06:03:01 pm »
Nope, I haven't tried. I do see data for JALSH:IND and INDU:IND though, are you looking for something different?
Meant data of all the Instruments on that exchange

Moneypenny

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1891
  • Karma: +37/-0
    • View Profile
    • Bu Valiere
Live chat
« Reply #5900 on: July 27, 2017, 09:21:58 am »
That is a much appreciated and unexpected gesture Patrick, thank you. :)

PlatinumWealth.co.za

  • Sr. Member
  • ****
  • Posts: 322
  • Karma: +10/-1
  • Weekend Investor
    • View Profile
    • Platinum Wealth Group
Live chat
« Reply #5901 on: July 27, 2017, 10:44:40 am »
what data do you need? I can probably provide what you need.
www.PlatinumWealth.co.za <- South African Investment and Finance forum.

PlatinumWealth.co.za

  • Sr. Member
  • ****
  • Posts: 322
  • Karma: +10/-1
  • Weekend Investor
    • View Profile
    • Platinum Wealth Group
Live chat
« Reply #5902 on: July 27, 2017, 10:44:48 am »
for mahala
www.PlatinumWealth.co.za <- South African Investment and Finance forum.

Hamster

  • Hero Member
  • *****
  • Posts: 535
  • Karma: +13/-0
    • View Profile
    • Off Topic
Live chat
« Reply #5903 on: July 27, 2017, 11:18:25 am »
What we need is a standard web API for retrieving delayed JSE data. Don't understand why the JSE doesn't just do this themselves (throttle it if they're scared of abuse).

Moneypenny

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1891
  • Karma: +37/-0
    • View Profile
    • Bu Valiere
Live chat
« Reply #5904 on: July 27, 2017, 11:41:05 am »
Thank you Thor187 😊  I need an alphabetical list of all JSE shares with closing prices each day downloaded to Excel.  

PlatinumWealth.co.za

  • Sr. Member
  • ****
  • Posts: 322
  • Karma: +10/-1
  • Weekend Investor
    • View Profile
    • Platinum Wealth Group
Live chat
« Reply #5905 on: July 27, 2017, 11:57:46 am »
Let me see what I can do.
www.PlatinumWealth.co.za <- South African Investment and Finance forum.

Patrick

  • Administrator
  • Hero Member
  • *****
  • Posts: 2551
  • Karma: +47/-2
    • View Profile
Live chat
« Reply #5906 on: July 27, 2017, 12:33:53 pm »
So much choice for you MP. This will give you the latest prices I have, so run it after 5:15 and it should be end of day: http://www.shareforum.co.za/competition/com_moneypenny.php

PlatinumWealth.co.za

  • Sr. Member
  • ****
  • Posts: 322
  • Karma: +10/-1
  • Weekend Investor
    • View Profile
    • Platinum Wealth Group
Live chat
« Reply #5907 on: July 27, 2017, 12:44:17 pm »
Jip I cannot beat that, sweet Patric you hero
www.PlatinumWealth.co.za <- South African Investment and Finance forum.

Moneypenny

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1891
  • Karma: +37/-0
    • View Profile
    • Bu Valiere
Live chat
« Reply #5908 on: July 27, 2017, 01:44:06 pm »
Goodie it works! Yay! Thank you so much!!!!

Hamster

  • Hero Member
  • *****
  • Posts: 535
  • Karma: +13/-0
    • View Profile
    • Off Topic
Re: Live chat
« Reply #5909 on: July 27, 2017, 02:18:48 pm »
Had a few minutes: https://docs.google.com/spreadsheets/d/1bS8SD-c9XsM-V8Nx-wtp3giEMzEk3wm1oLCZyqp4oSc/edit?usp=sharing

Draws data from Google Finance. Only problem - Google Finance will one day disappear and somebody needs to manually maintain it. Either way, you can setup a Google Spreadsheet and use the specific tickers you want to build a portfolio. Add your holding values, set up some graphs and BOOM! Better software than most banks provide :D