No clearing price in the orderbook

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

No clearing price in the orderbook

Porag
Hi
Just a quick question to all. I am seeing that there is no clearing price in some orderbooks.
For example,
<orderbook id="884635" timeslot="788">
  <dateExecuted>
    <iMillis>1257933600000</iMillis>
  </dateExecuted>
  <bid limitPrice="-24.640279982134842" mWh="5.6079601860752675"/>
  <bid limitPrice="-16.397515781916198" mWh="30.492423770155412"/>
  <ask limitPrice="64.87742405430609" mWh="-4.99988468873129"/>
  <ask limitPrice="76.8917606965504" mWh="-4.6087747770958885"/>
  <ask limitPrice="88.85357857866656" mWh="-4.300470332405635"/>
  <ask limitPrice="101.01364578377478" mWh="-3.994792702749115"/>
  <ask limitPrice="112.59215657067915" mWh="-3.8072359899705135"/>
  <ask limitPrice="124.56077124735587" mWh="-3.6127264244536077"/>
  <ask limitPrice="136.6454744396114" mWh="-3.48257856241503"/>
  <ask limitPrice="148.76262834590176" mWh="-3.3454070092070496"/>
  <ask limitPrice="160.47115849734283" mWh="-3.240821827618044"/>
  <ask limitPrice="172.76807786762245" mWh="-3.130158351838431"/>
  <ask limitPrice="184.7503239341364" mWh="-3.027175724093909"/>
  <ask limitPrice="196.72008642859302" mWh="-2.9204551656087196"/>
  <ask limitPrice="208.7950175240202" mWh="-2.8254825454079486"/>
  <ask limitPrice="220.77749881736284" mWh="-2.7652195915678672"/>
  <ask limitPrice="232.87735074749335" mWh="-2.695872811973652"/>
  <ask limitPrice="245.00935350195076" mWh="-2.6076139014108843"/>
  <ask limitPrice="256.9435000169853" mWh="-2.556017167992393"/>
  <ask limitPrice="269.0532329109807" mWh="-2.492912593117999"/>
  <ask limitPrice="280.99302132273436" mWh="-2.4314350868006587"/>
  <ask limitPrice="293.00563539691444" mWh="-2.3951220114396707"/>
  <ask limitPrice="304.80927608371536" mWh="-2.3662723971907544"/>
  <ask limitPrice="317.0101957181747" mWh="-2.284647105670623"/>
  <ask limitPrice="328.9009794503815" mWh="-2.2612037682886017"/>
  <ask limitPrice="341.0509266633905" mWh="-2.2165083703685244"/>
  <ask limitPrice="353.11060480052305" mWh="-2.1849695270211615"/>
  <ask limitPrice="364.90905213266086" mWh="-2.1599326192272326"/>
  <ask limitPrice="376.9744618373038" mWh="-2.1137969096486895"/>
  <ask limitPrice="389.03149408667565" mWh="-2.070989566639884"/>
  <ask limitPrice="400.99201815880076" mWh="-2.0585025951672233"/>
  <ask limitPrice="412.98743529599835" mWh="-2.01201034611689"/>
  <ask limitPrice="425.2330598100359" mWh="-2.000992856420767"/>
  <ask limitPrice="437.12576020270177" mWh="-1.9478078202944664"/>
  <ask limitPrice="449.06818420596505" mWh="-1.9382279641875975"/>
  <ask limitPrice="460.99870302774843" mWh="-1.9118983081965506"/>
  <ask limitPrice="473.06451012137177" mWh="-1.879861420554639"/>
  <ask limitPrice="485.20819850046985" mWh="-1.858396234473467"/>
</orderbook>

Some orderbook has clearing prices :

<orderbook id="1000199" timeslot="857" clearingPrice="165.78262064141182">
  <dateExecuted>
    <iMillis>1258149600000</iMillis>
  </dateExecuted>
  <bid limitPrice="-39.03324748041557" mWh="11.613771290933556"/>
  <bid limitPrice="-3.5860377963023766" mWh="139.42965144303787"/>
  <bid limitPrice="12.309612068943188" mWh="11.613771290933556"/>
  <ask limitPrice="108.67324118056902" mWh="-0.9211742075691101"/>
  <ask limitPrice="120.67841614506183" mWh="-3.713018843635038"/>
  <ask limitPrice="132.84836098458524" mWh="-3.558387519264655"/>
  <ask limitPrice="144.71121974918992" mWh="-3.4159922330687653"/>
  <ask limitPrice="156.87107269375966" mWh="-3.274101446820954"/>
  <ask limitPrice="168.6859963697669" mWh="-3.1608956784696627"/>
  <ask limitPrice="180.82695322292486" mWh="-3.053638856089493"/>
  <ask limitPrice="192.69978519834217" mWh="-2.935832085263284"/>
  <ask limitPrice="204.71986724896263" mWh="-2.868180800600197"/>
  <ask limitPrice="216.58752131364642" mWh="-2.7853290968935625"/>
  <ask limitPrice="228.63256116967247" mWh="-2.713817352085462"/>
  <ask limitPrice="240.6522406727409" mWh="-2.6404101644374585"/>
  <ask limitPrice="252.58579786428083" mWh="-2.567803943649435"/>
  <ask limitPrice="264.6557331444699" mWh="-2.5432128214829364"/>
  <ask limitPrice="276.50542983566845" mWh="-2.484926823693889"/>
  <ask limitPrice="288.70660141255746" mWh="-2.423147083070612"/>
  <ask limitPrice="300.4941838062272" mWh="-2.3676478173938365"/>
  <ask limitPrice="312.75830519840446" mWh="-2.321692052394257"/>
  <ask limitPrice="324.5378999927515" mWh="-2.2869259997172606"/>
  <ask limitPrice="336.60487304148296" mWh="-2.2530771493241737"/>
  <ask limitPrice="348.71731546039246" mWh="-2.1988543453412523"/>
  <ask limitPrice="360.5048584749728" mWh="-2.162409324014949"/>
  <ask limitPrice="372.6038676511153" mWh="-2.159836276224762"/>
  <ask limitPrice="384.46704263928234" mWh="-2.0995765343852755"/>
  <ask limitPrice="396.75695759078656" mWh="-2.0666839268001564"/>
  <ask limitPrice="408.4223675360027" mWh="-2.0649781005546846"/>
  <ask limitPrice="420.91761941181403" mWh="-2.0063874088344997"/>
  <ask limitPrice="432.7274742307108" mWh="-1.9725410298185504"/>
  <ask limitPrice="444.64994242068707" mWh="-1.9507693263343282"/>
  <ask limitPrice="456.8708667768024" mWh="-1.9248097688598795"/>
  <ask limitPrice="468.66360746748614" mWh="-1.9115297028906246"/>
  <ask limitPrice="480.7359211339034" mWh="-1.8793573925462237"/>
</orderbook>


Any reason why the first one don't have any clearing prices?

Thanks in advance
Porag
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: No clearing price in the orderbook

grampajohn
Administrator
Hello -
Porag wrote
Hi
Just a quick question to all. I am seeing that there is no clearing price in some orderbooks.
For example,
<orderbook id="884635" timeslot="788">
  <dateExecuted>
    <iMillis>1257933600000</iMillis>
  </dateExecuted>
  <bid limitPrice="-24.640279982134842" mWh="5.6079601860752675"/>
  <bid limitPrice="-16.397515781916198" mWh="30.492423770155412"/>
  <ask limitPrice="64.87742405430609" mWh="-4.99988468873129"/>
  <ask limitPrice="76.8917606965504" mWh="-4.6087747770958885"/>
  ...
</orderbook>

Some orderbook has clearing prices :

<orderbook id="1000199" timeslot="857" clearingPrice="165.78262064141182">
  <dateExecuted>
    <iMillis>1258149600000</iMillis>
  </dateExecuted>
  <bid limitPrice="-39.03324748041557" mWh="11.613771290933556"/>
  <bid limitPrice="-3.5860377963023766" mWh="139.42965144303787"/>
  <bid limitPrice="12.309612068943188" mWh="11.613771290933556"/>
  <ask limitPrice="108.67324118056902" mWh="-0.9211742075691101"/>
  ...
</orderbook>

Any reason why the first one don't have any clearing prices?
An orderbook shows uncleared bids and asks for a given auction -- the asks with higher prices than the clearing price, and the bids with lower prices than the clearing price. Ignore the signs - they show the direction of money and energy transfer. But what happens if the lowest ask is higher than the highest bid? No orders get cleared, and so the clearing price is null and the orderbook includes all the submitted asks and bids.

Does this make sense?

John
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: No clearing price in the orderbook

Porag
Hi John,

I have a question.

For the same target timeslot's n-1 hourahead auction, do the producers submit exactly the same uncleared asks which were not cleared in the n hourAhead auction?

Thanks
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: No clearing price in the orderbook

grampajohn
Administrator
Hello, Porag -
Porag wrote
For the same target timeslot's n-1 hourahead auction, do the producers submit exactly the same uncleared asks which were not cleared in the n hourAhead auction?
No. Should they?

John
Loading...