Skip to main content

Power block price creation and conversion

Project description

PyPI version

Elektra

Elektra is Molecule's core framework for block logic (i.e., how to compute mwh from 5x16, 2x16, etc. blocks). It's derived from a set of logic internal to the Molecule application, and we're happy to share it with the world -- because nobody should ever have to fight with North American power blocks ever again.

Elektra is in pre-release, which means that signatures may change over time as we evolve the project to 1.0. Submissions are welcome; just submit a pull request with your change.

Installing Elektra

Either clone this repo, or use pip:

pip3 install elektra

Using Elektra

In your python project, import elektra and use away. Usage examples are in examples/examples.py. A sample input CSV is there too. For the examples below, we will use that CSV. You can also use the table of data at the end of this file.

Parameters

Internally, Elektra uses enums for ISO, Block, and Frequency. String inputs for these fields are converted to the enum when Elektra runs, and so must be provided in the exact format the Enum expects.

  1. iso: permitted values are miso, isone, ercot, pjm, spp, aeso, nyiso, caiso
  2. block: permitted values are 7x8, 5x16, 2x16, 7x24, 7x16, 1x1, wrap, 6x16
  3. frequency: permitted values are daily, monthly, hourly

Methods

These are the primary methods available in Elektra. Other methods are available, but are undocumented.

create_prices

This method creates block prices, given hourly prices for a period of time and a handful of other parameters. A key function of this method is that it validates whether enough prices have been submitted to do the calculation. So, if the block is 5x16, but a price is missing for a Wednesday at 11 AM, an exception will be thrown. Daylight Savings Time is also contemplated.

The create_prices method takes the following parameters:

  • flow_date - date | The as of date for the power prices (i.e., the settlement/reporting date needed)
  • ticker - string | The ticker symbol for the power product (Molecule ticker; used for identification, not calculation)
  • node - string | The node on the power grid (used for identification, not calculation)
  • iso - string | The name of the Independent System Operator (ISO). CAISO is not currently supported.
  • block - string | The desired power block for the output prices
  • frequency string | The desired frequency for the output prices (either daily or monthly)
  • prices DataFrame | A Pandas dataframe of prices consisting of flow_date, hour_ending, and price

The response from the method is a single floating-point price.

Example

import elektra
import pandas as pd
import filecmp
import datetime as dt

flow_date = dt.datetime(2020, 10, 17)
prices = pd.read_csv('lmps.csv')

result = elektra.create_prices(flow_date, 'M.XXXX', 'INDIANA.HUB', 'miso', '2x16', 'daily', prices)
print(result)

scrub_hourly_prices

This method validates that a submitted dataframe contains all the necessary hourly prices for a flow date, and returns a DataFrame with these prices. Daylight Savings Time (long-day and short-day) is contemplated.

The scrub_hourly_prices method takes the following parameters:

  • flow_date - date | The as of date for the power prices (i.e., the settlement/reporting date needed)
  • ticker - string | The ticker symbol for the power product (Molecule ticker; used for identification, not calculation)
  • node - string | The node on the power grid (used for identification, not calculation)
  • iso - string | The name of the Independent System Operator (ISO). CAISO is not currently supported.
  • prices DataFrame | A Pandas dataframe of prices consisting of flow_date, hour_ending, and price

The response from the method is a Pandas dataframe with the following columns of data:

  • Hour Beginning
  • Hour Ending
  • Required
  • Special
  • Value

Example

import elektra
import pandas as pd
import filecmp
import datetime as dt

flow_date = dt.datetime(2020, 10, 17)
prices = pd.read_csv('lmps.csv')

result = elektra.scrub_hourly_prices(flow_date, 'M.XXXX', '116013753', 'pjm', prices)
print(result)

convert

Given a flow date and an input block (i.e., 5x16), this method returns the number of hours in another block.

For example, if today is Wednesday, November 4, 2020, and I have a 7x24 block (24 hours), but I want to see how many 5x16 hours that implies -- I'll get 16. On the other hand, if today is Saturday, October 31, 2020, and I have a Wrap block (24 hours that day), that only implies 8 hours of 7x8. This is useful when trying to convert a position purchased in one block, to a volume of another block. It works in tandem with the TranslateBlocks method.

The convert method takes the following parameters:

  • flow_date - date | The as of date for the power prices (i.e., the settlement/reporting date needed)
  • input_block -- (text: Wrap, 5x16, 2x16, 7x8, 7x16, 1x1) | The input block.
  • output_block -- (text: Wrap, 5x16, 2x16, 7x8, 7x16, 1x1) | The block for which we want to see hours.

The response from this method is an integer, representing the number of hours in the output block.

Example

import elektra
import datetime as dt

flow_date = dt.datetime(2020, 10, 17)

result = elektra.convert(flow_date, '7x24', '2x16') # 16: (October 17 2020 is a Saturday, and has 16 peak hours)
result = elektra.convert(flow_date, '7x24', '5x16') # 0: (October 17 2020 is a Saturday, and has 0 weekday peak hours)
result = elektra.convert(flow_date, '5x16', '2x16') # 0: (October 17 2020 is a Saturday, and there could not be a 5x16 input block)

translate_blocks

Wrapper for convert, which adds the ability to convert a MW position for a term block (i.e., 7x24 monthly) to another block (or blocks) for that same term (i.e., 5x16, 2x16).

The translateBlocks method takes the following parameters:

  • iso - string | The short name of the Independent System Operator (Elektra.Iso). This is not currently used, so beware when using for CAISO.
  • mw - decimal | The number of megawatts on the input block to be used for mw/mwh computation
  • frequency - string | monthly, daily, or hourly. Currently only monthly is implemented.
  • contract_start date | The first flow date of the block. This method will compute the last flow date.
  • in_block - string | 7x24, 5x16, Wrap, 2x16, 7x8
  • out_blocks - string array | accepted values include 7x24, 5x16, Wrap, 2x16, 7x8
  • out_uom - string | Set to MW for a megawatt number. Default is mwh.

The response from this method is a DataFrame with the following columns:

  • date (i.e., flow date)
  • one column for each out_block, representing the number of MW or MWh for each date

Example

import elektra
import datetime as dt

flow_date = dt.datetime(2020, 10, 1)
result = elektra.translateBlocks('pjm', 20, 'monthly', flow_date, '7x24', ['5x16', '2x16'], 'mwh')
print(result)

is_dst_transition

Responds with variables that indicate whether the input date is a DST transition day, and whether it is the short day of the year (i.e., spring DST transition day) or the long day of the year (fall). If the date is not the transition day, the short- and long- day returns are False.

The method takes the following parameter:

  • as_of - date | The date to test

The method returns the following parameters:

  • is_tx - boolean | True, if the supplied date is one of the two yearly transition days
  • short_day - boolean | True, if the supplied date is the short day
  • long_day - boolean | True, if the supplied date is the long day

Example

import elektra
import datetime as dt
flow_date = dt.datetime(2021, 3, 14)

is_tx, short_day, long_day = elektra.is_dst_transition(flow_date)
print(is_tx) # True; this is one of the transition dates
print(short_day) # True; this is the spring DST transition date
print(long_day) # False; that would be the "fall back" date

Sample Data

This data is suitable for inputs to the hourly and block price converters:

flow_date hour_ending price
2020-10-17 1.0 26.48
2020-10-17 2.0 20.35
2020-10-17 3.0 17.19
2020-10-17 4.0 17.16
2020-10-17 5.0 20.28
2020-10-17 6.0 34.25
2020-10-17 7.0 21.24
2020-10-17 8.0 23.67
2020-10-17 9.0 22.37
2020-10-17 10.0 20.81
2020-10-17 11.0 21.10
2020-10-17 12.0 19.28
2020-10-17 13.0 18.94
2020-10-17 14.0 18.07
2020-10-17 15.0 19.43
2020-10-17 16.0 18.94
2020-10-17 17.0 18.85
2020-10-17 18.0 22.40
2020-10-17 19.0 60.50
2020-10-17 20.0 19.12
2020-10-17 21.0 20.36
2020-10-17 22.0 19.39
2020-10-17 23.0 17.67
2020-10-17 24.0 17.55

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

elektra-0.0.30.tar.gz (17.1 kB view details)

Uploaded Source

Built Distribution

elektra-0.0.30-py3-none-any.whl (15.6 kB view details)

Uploaded Python 3

File details

Details for the file elektra-0.0.30.tar.gz.

File metadata

  • Download URL: elektra-0.0.30.tar.gz
  • Upload date:
  • Size: 17.1 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.0.0 CPython/3.9.6

File hashes

Hashes for elektra-0.0.30.tar.gz
Algorithm Hash digest
SHA256 7e56815f1af402bf6c33515822758a6211e9c7498e089f0e97165bd76df8b59e
MD5 78ec3786a697da14487d1062416891a3
BLAKE2b-256 a3f7ab7ae4336eb369fa63369603f3362f662ff1df14f68a589f886a1cb65969

See more details on using hashes here.

File details

Details for the file elektra-0.0.30-py3-none-any.whl.

File metadata

  • Download URL: elektra-0.0.30-py3-none-any.whl
  • Upload date:
  • Size: 15.6 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.0.0 CPython/3.9.6

File hashes

Hashes for elektra-0.0.30-py3-none-any.whl
Algorithm Hash digest
SHA256 e25c646d8467b473bb4a878d28b3fede0312dcaf32d385006deee7f98614e29a
MD5 8578beadf9badf746dea47a8509c34e8
BLAKE2b-256 9d233295a99d37404208e441596cd384deef0354cc8aa3a092a591ff73f4ca52

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page