Public/EnergyProducts/Find-OctopusEnergyHelperAgileRate.ps1
|
<# .Synopsis Find the desired target rate for the specified period of time under the Agile Octopus tariff .PARAMETER apikey The Octopus Energy API Key .PARAMETER timespan The period of time which should be tracked .PARAMETER target Value used to specify if the highest or lowest value should be found .PARAMETER gsp The GSP of the electricity meter point .PARAMETER mpan The mpan of the electricity meter .PARAMETER period_from Search through rates from the given datetime (inclusive). .PARAMETER period_to Search through rates to the given datetime (exclusive). .INPUTS None .OUTPUTS Returns a list of rates which meet the desired duration .EXAMPLE Get-OctopusEnergyHelperEnergyProductTariff -duration (New-TimeSpan -hours 2 -minutes 30) -target "lowest" -mpan 123456789012 .EXAMPLE Get-OctopusEnergyHelperEnergyProductTariff -duration (New-TimeSpan -hours 2 -minutes 30) -target "highest" -gsp A .EXAMPLE $fromDate = Get-Date 21:00 Get-OctopusEnergyHelperEnergyProductTariff -duration (New-TimeSpan -hours 2 -minutes 30) -target "lowest" -gsp A -period_from $fromDate .FUNCTIONALITY Retrieves Agile Octopus rates which meet the target for the specified duration. E.g Find the time period which has the lowest total rate over a 2 1/2 hours period. #> function Find-OctopusEnergyHelperAgileRate { [CmdletBinding(SupportsShouldProcess=$true,DefaultParameterSetName='MPAN')] [OutputType([System.Collections.Generic.List[PSObject]])] Param( [securestring]$ApiKey=(Get-OctopusEnergyHelperAPIAuth), [Parameter(Mandatory=$true,ParameterSetName='GSPCode')] [Parameter(Mandatory=$true,ParameterSetName='MPAN')] [timespan]$duration, [Parameter(ParameterSetName='GSPCode')] [Parameter(ParameterSetName='MPAN')] [ValidateSet("lowest","highest")] [string]$target="lowest", [Parameter(Mandatory=$true,ParameterSetName='GSPCode')] [ValidateSet("A","B","C","D","E","F","G","H","J","K","L","M","N","P")] [string]$gsp, [Parameter(Mandatory=$false,ParameterSetName='MPAN')] [ValidateNotNullOrEmpty()] [string]$mpan = (Get-OctopusEnergyHelperConfig -property mpan), [Parameter(ParameterSetName='GSPCode')] [Parameter(ParameterSetName='MPAN')] [datetime]$period_from = $((Get-Date)), [Parameter(ParameterSetName='GSPCode')] [Parameter(ParameterSetName='MPAN')] [datetime]$period_to ) if($mpan) { if( $pscmdlet.ShouldProcess("Octopus Energy API", "Retrieve Meter Point Information") ) { $meterPoint = Get-OctopusEnergyHelperMeterPoint -mpan $mpan -ApiKey $ApiKey } $gsp = $meterPoint.gsp -replace "_","" } $tariffParams = @{ ApiKey = $ApiKey tariff_code = "E-1R-AGILE-18-02-21-$gsp" period_from = $period_from } if($period_to){$tariffParams.Add("period_to",$period_to)} if( $pscmdlet.ShouldProcess("Octopus Energy API", "Retrieve Agile Octopus Tariff Data") ) { $tariffs = Get-OctopusEnergyHelperEnergyProductTariff @tariffParams } $rates= $tariffs.'standard-unit-rates' $dataPoints = [int]$duration.TotalHours * 2 If([int]$dataPoints -gt $rates.count){Throw "Duration greater than the number of available rates"} $desiredRange = [System.Collections.Generic.List[PSObject]]::new($dataPoints) $sum = ($rates | Measure-Object -Property "value_exc_vat" -Sum).Sum If($target -eq "highest"){$sum=0} for(($startMarker = 0),($endMarker = $dataPoints -1) ; $endMarker -lt $rates.Count ;($startMarker++), ($endMarker++)) { $rangeMeasure = $rates[$startMarker..$endMarker] | Measure-Object -Property "value_exc_vat" -Sum Switch($target) { "lowest" { If($rangeMeasure.Sum -lt $sum) { $sum = $rangeMeasure.Sum $desiredRange = $rates[$startMarker..$endMarker] } } "highest" { If($rangeMeasure.Sum -gt $sum) { $sum = $rangeMeasure.Sum $desiredRange = $rates[$startMarker..$endMarker] } } } } Return $desiredRange } |