{"action":"created","issue":{"url":"https://api.github.com/repos/Rod-Persky/investoscope-easy-update/issues/13","repository_url":"https://api.github.com/repos/Rod-Persky/investoscope-easy-update","labels_url":"https://api.github.com/repos/Rod-Persky/investoscope-easy-update/issues/13/labels{/name}","comments_url":"https://api.github.com/repos/Rod-Persky/investoscope-easy-update/issues/13/comments","events_url":"https://api.github.com/repos/Rod-Persky/investoscope-easy-update/issues/13/events","html_url":"https://github.com/Rod-Persky/investoscope-easy-update/issues/13","id":356563974,"node_id":"MDU6SXNzdWUzNTY1NjM5NzQ=","number":13,"title":"Intraday Updates - Apple Script Help Needed","user":{"login":"obyone","id":26485536,"node_id":"MDQ6VXNlcjI2NDg1NTM2","avatar_url":"https://avatars3.githubusercontent.com/u/26485536?v=4","gravatar_id":"","url":"https://api.github.com/users/obyone","html_url":"https://github.com/obyone","followers_url":"https://api.github.com/users/obyone/followers","following_url":"https://api.github.com/users/obyone/following{/other_user}","gists_url":"https://api.github.com/users/obyone/gists{/gist_id}","starred_url":"https://api.github.com/users/obyone/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/obyone/subscriptions","organizations_url":"https://api.github.com/users/obyone/orgs","repos_url":"https://api.github.com/users/obyone/repos","events_url":"https://api.github.com/users/obyone/events{/privacy}","received_events_url":"https://api.github.com/users/obyone/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-09-03T16:50:02Z","updated_at":"2018-09-04T21:13:12Z","closed_at":null,"author_association":"NONE","body":"I'm looking to try and add intraday updates to share prices.  I have looked into it and have created a simple Python script using a feed from Alpha Vantage which provides free real-time stock updates.\r\n\r\nI have completed the first half of a proof of concept that fetches the required data from Alpha Vantage and I'm not looking into updating the database accordingly.   \r\n\r\nFor two reasons I'm thinking that it would be better to do this with AppleScript using the 'tell application' method but I don't know what apple scripts are available within Investoscope or which I should use.  The first reason is that I'm assuming if the backend database is updated then this won't automatically trigger an update to the GUI and secondly I cannot figure out the timestamp format for the 'ztime' field in the 'zquote' table.\r\n\r\nI therefore have three questions:\r\n\r\nDoes anyone know what AppleScript commands are available to use in Investoscope and are there any details on how to use?\r\n\r\nDoes anyone know how to decode the timestamp field that is used in the SQLite database for Investoscope?  For example I have a value of '557427600' which equates to the 31st August 2018 18:00 (UK timezone) but I don't know how to convert to this value as it doesn't seem to be the standard unix timestamp\r\n\r\nIs there a better way of achieving what I want to do?  Any pointers or guidance would be much appreciated.\r\n\r\nI'm happy to share my code, if it can be incorporated into this project great, if not then I can distribute it separately, go easy on me as I'm not the most proficient programmer :)"},"comment":{"url":"https://api.github.com/repos/Rod-Persky/investoscope-easy-update/issues/comments/418519890","html_url":"https://github.com/Rod-Persky/investoscope-easy-update/issues/13#issuecomment-418519890","issue_url":"https://api.github.com/repos/Rod-Persky/investoscope-easy-update/issues/13","id":418519890,"node_id":"MDEyOklzc3VlQ29tbWVudDQxODUxOTg5MA==","user":{"login":"obyone","id":26485536,"node_id":"MDQ6VXNlcjI2NDg1NTM2","avatar_url":"https://avatars3.githubusercontent.com/u/26485536?v=4","gravatar_id":"","url":"https://api.github.com/users/obyone","html_url":"https://github.com/obyone","followers_url":"https://api.github.com/users/obyone/followers","following_url":"https://api.github.com/users/obyone/following{/other_user}","gists_url":"https://api.github.com/users/obyone/gists{/gist_id}","starred_url":"https://api.github.com/users/obyone/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/obyone/subscriptions","organizations_url":"https://api.github.com/users/obyone/orgs","repos_url":"https://api.github.com/users/obyone/repos","events_url":"https://api.github.com/users/obyone/events{/privacy}","received_events_url":"https://api.github.com/users/obyone/received_events","type":"User","site_admin":false},"created_at":"2018-09-04T21:13:12Z","updated_at":"2018-09-04T21:13:12Z","author_association":"NONE","body":"Some progress has been made this evening :)"}}
{"actor":{"display_login":"obyone"}}