Author Topic: Live chat  (Read 2974864 times)

Moneypenny

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1891
  • Karma: +37/-0
    • View Profile
    • Bu Valiere
Live chat
« Reply #5895 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 #5896 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 #5897 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 #5898 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 #5899 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 #5900 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: 2552
  • Karma: +47/-2
    • View Profile
Live chat
« Reply #5901 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 #5902 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 #5903 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 #5904 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

Patrick

  • Administrator
  • Hero Member
  • *****
  • Posts: 2552
  • Karma: +47/-2
    • View Profile
Live chat
« Reply #5905 on: July 27, 2017, 02:59:05 pm »
Very nice, I could have saved my server a tons of processing power with this if you showed me earlier! What makes you say it'll disappear one day?

Patrick

  • Administrator
  • Hero Member
  • *****
  • Posts: 2552
  • Karma: +47/-2
    • View Profile
Live chat
« Reply #5906 on: July 27, 2017, 04:01:59 pm »
Okay that link is very cool hamster. I wanted to see if I could pull all the data via CSV and I can! https://docs.google.com/spreadsheets/d/1L_jWixByuwHZeFLKrWFYjIVrfyuAsEMXSlUDDonhgqM/pub?output=csv

Hamster

  • Hero Member
  • *****
  • Posts: 535
  • Karma: +13/-0
    • View Profile
    • Off Topic
Re: Live chat
« Reply #5907 on: July 28, 2017, 06:43:39 am »
Google Finance is not officially supported by Google anymore and given their history with products they can simply pull the plug one day without notice (suppose Bloomberg can kill their API as well). Not that I think they would. Google Finance also hasn't updated with the latest Satrix ETFs... :(

Moneypenny

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1891
  • Karma: +37/-0
    • View Profile
    • Bu Valiere
Live chat
« Reply #5908 on: July 28, 2017, 09:30:49 am »
:) Thank you H
« Last Edit: July 28, 2017, 09:33:50 am by Moneypenny »

Bread

  • Full Member
  • ***
  • Posts: 218
  • Karma: +6/-0
    • View Profile
Re: Live chat
« Reply #5909 on: July 30, 2017, 03:01:33 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
Patrick, what do you mean 'run it'? When I click on the link it only opens a spreadsheet.