search

quintel / etmodel

Professional interface of the Energy Transition model.
https://energytransitionmodel.com/
MIT License
26 stars 12 forks source link

Add chart with CWE Day Ahead prices #1667

Closed fvancamp closed 5 years ago

fvancamp commented 10 years ago

Within Supply>Import/Export, we want to replicate the following chart as available on http://www.apxgroup.com/market-results/cwe/

screen shot 2013-11-15 at 15 55 08

Part of the data required to recreate this chart can be obtained from the JSON object that is available from http://www.apxgroup.com/rest-api/quotes/ . This is a huge array, including 5 CWE Day Ahead objects, which each contain 4 values, related to respectively:

The first such object in the array relates to the day of tomorrow, the second to today and so on until three days ago.

In order to create a chart with 2 weeks worth of prices, a script/CRON job should run daily to add another datapoint to the database. Upon loading a scenario, a dataset should be loaded and made available to the associated D3 chart.

fvancamp commented 10 years ago

Including @ChaelKruip

dennisquintel commented 10 years ago

Could we perhaps also use the same API call that the chart on the forementioned page uses?

http://www.apxgroup.com/rest-api/quotes/CWE%20Day%20Ahead?type=latest&limit=14

ChaelKruip commented 10 years ago

Could we perhaps also use the same API call that the chart on the forementioned page uses?

Good catch! :smile:

ChaelKruip commented 10 years ago

Assigned to @fvancamp

ChaelKruip commented 10 years ago

Added milestone January Deploy 2014

ChaelKruip commented 10 years ago

See https://github.com/quintel/etmodel/issues/1689

ChaelKruip commented 10 years ago

@fvancamp what is the status of this ticket?

fvancamp commented 10 years ago

Need to work on this. Hope to be able to report better news tomorrow...

On Mon, Jan 20, 2014 at 9:37 AM, Chael Kruip notifications@github.comwrote:

@fvancamp https://github.com/fvancamp what is the status of this ticket?

— Reply to this email directly or view it on GitHubhttps://github.com/quintel/etmodel/issues/1667#issuecomment-32741946 .

Frans van Camp, Code Monkey

_Quintel Intelligence_Atrium - Strawinskylaan 3051 1077 ZX Amsterdam The Netherlands

T : +31 (0)20 301 22 69 F : +31 (0)20 301 22 02 M : +31 (0)6 53 96 05 04

E : frans.vancamp@quintel.com I : www.quintel.com and www.energytransitionmodel.com

This message (including any attachments) is confidential and may be privileged. Any review, retransmission, dissemination or other use of, or taking any action with reference to this information by persons other than the intended recipient is strictly prohibited. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Please note that e-mails are susceptible to change. The sender will not accept liability for the improper or incomplete transmission of the information contained in this message.

ChaelKruip commented 10 years ago

Moving to next deploy. The static version is ready and deployed. The dynamic is dependent on the response of APX.

ChaelKruip commented 10 years ago

Moving to next deploy. The static version is ready and deployed. The dynamic is dependent on the response of APX.

ChaelKruip commented 9 years ago

Putting this on-hold. APX has not replied after several attempts.

marliekeverweij commented 5 years ago

See https://github.com/quintel/documentation/blob/master/general/import_export.md