Demos
Bite-Sized DemosImporting Market Data into Molecule
July 19, 2024 | 5:26
Transcript
Alex CerboneSales Engineer, Molecule
Narrator Hello, and thanks for watching. This video provides a brief demo and general overview of how to import market data into Molecule. If you have any questions about Molecule that are more specific to your organization, we're happy to show you more. Reach out to us for a custom demo on our website at molecule.io. Enjoy the demo.
Alex Cerbone Hi, we're going to be talking about importing market data into the Molecule system today. So let's open up the application and refresh ourselves with the market data screen. For market data, we have an embedded hierarchy in the system. You'll see the different colors here on the left-hand side are telling us where it lies in that hierarchy. Copied from the prior day is going to be at the bottom, and then that user-provided mark is going to be at the top. We have two levels as well for the user-provided. This user-provided is going to overwrite your settlement values that are coming in from any of the market data streams that we have imported into the system already. But you can also do things like providing an estimate. If we have our own market data that's feeding an intraday, we want to supplement the information in the system here, then we could do that with the estimate, or we can even run our valuation side by side in the reporting functions by using one of these user-provided curves as well. When I click into one of these curves, I'm going to use this WTI Curve as my example on most, where I can see most of these are green.
Alex Cerbone This goes down to the individual level of our forward curves too. And then I have a user-provided estimate that has been updated in here as well. I'll close this one out. You'll see under my Actions, I have the option to download my market data information, my curves, my surfaces. So if I want to work from an existing curve, this is a really good way to start because it's also in the exact representation of the template that we need. So let's say I want to roll something off of my WTI Curve, I can download the individual Curve, make the changes that I need. If I want a general template, then I can download a template here. This is also where I'm going to go to upload a file. We have a little shortcut up top or you can go into the Actions as well. So if I download a Curves template, It'll pop up here for me. I'll have my as-of date at the top. I'll have my separate commodities that have been lined up at the top row here. We're using the Molecule symbol that has been assigned out for each of those individual underlyings.
Alex Cerbone And then we have our buckets. So the only requirement that we have for these is that we're using the same granularity for the uploads here. So this is a daily granularity, whereas the WTI curve that I have loaded up already is at a monthly granularity. So what I did on this was I took my forward curve from the 17th. Today is the 20th, but it's early in the morning here, so we don't have any forward curves out. And I put a estimate on here based off of the movements and the trends that I've seen over the weekend of what I'm anticipating to happen in the marketplace here. I load this up as either an estimate or an actual curve. And how I tell the system whether it's an estimate or an actual curve, is based off of the name of it. So I'm going to create this curve, go to Save As, and you'll see I have one of my CL Curve that will overwrite the settlements if I put it in this way, or I can put it in as this estimate curve. Let's say I want to overwrite what I have now. So I'm going to replace this one out.
Alex Cerbone And then when I go back to the system here, I can upload a file coming from my desktop. I want that CL curve on the 20th. It should be available for me. It'll tell me that it is uploading that information And then you'll see it pop up in messages of that upload has been successful. So now if I go to my May 20th date, I scroll down to my CL, you'll see it's highlighted purple here. So that tells me that that is user-provided. I click in and I will see the market data curve that I've uploaded into the system. Same thing for estimates. Just these will pop up blue for you. And then we'll also have our settlements that come in from our original market data sources that will overwrite them when they're settled at the end of day there.
Narrator Thanks again for watching our demo video. If you have any questions about how Molecule will work for your specific business, please reach out for a custom demo at molecule.io.