Merchant Capacity Prices

Capacity Price Analysis

U.S. Electricity and Gas Prices
You can create a macro that reads from the internet and then puts outputs in different sheets. I find this one of the most useful things to do with excel.


Subject

Excel File

Notes

Video Link

Chapter Reference

Page Reference















Uploading German Electricity and Gas Data



Reads Data from Internet








Working with UK Electricity Price and Gas Data












Working with PJM Data

PJM Hub 1

Data Analysis

https://www.youtube.com/watch?v=UF8i9TbRzBk






Automatically Uploading Natural Gas Prices

Natural Gas Read

Shows how to automatically Read
https://www.youtube.com/watch?v=NLcMIj6ZUk8






Data Analysis on Natural Gas Spreads

Natural Gas Spreads

Reading from Internet and Data

https://www.youtube.com/watch?v=ANKp2LenZRk






EIA Natural Gas Spreads

U.S. Spreads 1

Dense Data Analysis

https://www.youtube.com/watch?v=QD7ZwFmphWA





PJM Merchant Plant Analysis

PJM Merchant Analysis

Long Video (a little boring)

https://www.youtube.com/watch?v=wGGS_qemhI8






U.S. Markets Data Analysis

EIA U.S. Data

Long Video (data analysis)

https://www.youtube.com/watch?v=wGGS_qemhI8






U.S. Markets Merchant Analysis by Region

EIA Merchant Analysis

Graphing and Analysis

https://www.youtube.com/watch?v=JiV-n5zQ7AQ






PJM Supply Curve Analysis

PJM Supply Curve

Flexible Range Names with Offset
https://www.youtube.com/watch?v=mUvWD2On3ms





NEPOOL Supply Curve Analysis

NEPOOL Supply Curve










Supply and Demand Analysis

Simple Supply and Demand










Supply and Demand Analysis with Demand Curve

Supply and Demand with Elasticity










Simple Screening Analysis

Screening










Long-term Marginal Cost with Multiple Technologies
Long-term Pricing










Capacity Price Value












Capacity Price Analysis












Working with EIA 923 Data Base
























……………………………………………………………………………
……………………………………………………………
………………………………………………….
….
……………………………………………………………………………………….
…………………………………….
…………………………………