For the past week, I’ve been doing my internship at Altagas. I’m starting to get more comfortable working the long days and sitting in a chair for 8 hours. I had a couple of jobs to complete today, one of them was to compile the monthly averages of NYMEX WTI Settle Price and Bank of Canada Noon Rates into one tab of the spreadsheet. Instead of doing it manually, which probably would’ve been faster, I decided to learn a bit of Visual Basic and Macro Recording to design a Macro function that did the task for me. Although it didn’t work 100% effectively it did make the process a lot more enjoyable and I definitely learnt more that way, while getting the job done.
Along with that I’ve been assigned a more challenging project. I have to compile data from the Bloomberg terminal and determine how the Naphtha prices in Europe affect Propane Prices in North America. However, the task has been slightly simplified now because we couldn’t find any transport costs, but at least during this process I learnt how to do a regression analysis on excel. Currently I’m working on taking Ethane, Propane and Naphtha Prices from North America and Europe and calculating the gross margin using the prices of the products that are produced when the gases are heated up and broken down.
So far my experience has been incredible and super educational, I’ve learnt a lot about using excel, especially the shortcuts and macro functions. Along with that I've gained quite of bit of knowledge regarding Natural Gas Liquids and the mid-stream processing that happens in gas companies. This past week I even got to go the opportunity to go to Harmattan, a gas plant, which was pretty cool because it was the first time I’ve actually been inside a real processing plant. My internship has been really fun so far and I’m looking forward to what other challenges and opportunities it will put forth.