IEX DAM Data
Motivated by this post from RAJ PRATAP SINGH I took a shot at plotting IEX DAM pricing data myself using different tools. These are my findings.
Data Downloading.
IEX website allows you to download data for a particular day as a XL file. So I downloaded DAM MCP data for 23rd August 2024 as an XL file. I wanted to plot MCP variation across the 96, 15 minute time blocks over 24 hours starting midnight.
Plot using paid version of ChatGPT
Paid version of ChatGPT was the easiest option. I uploaded the raw XL file from IEX and asked for a XY plot of MCP vs Time Blocks. It replied that Time block data was nan. So I asked it to replace with serial numbers 1 to 96. It gave me my plot which I was able to download. This is the result.
I also tried with Gemini in Sheets but it replied it is still learning so it can’t do.
?
Using chart functionality in XL
It works but it needs some work. I had to clean the data first and then copy paste the chart into paint to get my image. Here is the result.
Using Python
Steps.
-??????? Clean the XL
-??????? Upload XL
-??????? Read XL into a Pandas data frame.
-??????? Plot using Matplotlib
-??????? Download plot.
Here is the result.