dailyfrackedfeet

This function returns fracked feet per day averaged by sub region. It sends a post request to the Hyperion V4 dailyfrackedfeet endpoint.

In the Formula Builder, select Hyperion 4.0, then choose the dailyfrackedfeet function from the Enter Function dropdown. Once selected, click Insert to automatically add the formula to Excel.

Syntax

=SMXH4.dailyfrackedfeet(aggregate_by,region_natgas,sub_region_natgas,date_frac_min,date_frac_max)

---

Arguments

Parameter	Description	Example
aggregate_by	Specifies a parameter by which to aggregate data.	"date"
region_natgas	Region divisions based on natural gas production profiles.	"gulf"
sub_region_natgas	Subregion divisions based on natural gas production profiles.	"S LA"
date_frac_min	A date in MM/DD/YYYY format	"1/3/2022"
date_frac_max	A date in MM/DD/YYYY format	"12/31/2022"

Note

Performance considerations: This function may take some time to retrieve and organize large amounts of data. For best performance, it is recommended to limit the number of input parameters and retrieve only the data needed for analysis.

Note

No Data: Output data will return “No Data” when input data is invalid or does not exist.

Examples

Retrieve daily fracked feet data:

1. To retrieve daily fracked feet in a specific region_natgas:

=SMXH4.dailyfrackedfeet("","northeast", "","","")

---

Input:

Output:

2. To retrieve daily fracked feet with a minimum date and an maximum date:

=SMXH4.dailyfrackedfeet("","", "","1/15/2021","12/15/2021")

---

Input:

Output:

3. To retrieve daily fracked feet with a specific date range and a particular sub_region_natgas:

=SMXH4.dailyfrackedfeet("","", "Haynesville - TX","1/15/2021","12/15/2021")

---

Input:

Output:

---

Output Parameters

Field	Type	Description	Example
fracked_feet	float	Aggregate fracked feet estimate.	1057.5
date_frac	string	A date in MM/DD/YYYY format	“11/24/2023”
region_natgas	string	Region divisions based on natural gas production profiles.	“gulf”
sub_region_natgas	string	Subregion divisions based on natural gas production profiles.	“West - TX”

---

Errors

Functions may return the following error messages:

Error	Description
#VALUE!	Input parameters are invalid or cannot be parsed.
#REF!	The function cannot retrieve data from the SynMaxax API due to a network or connectivity issue.
!!! EXCEPTION	Invalid input parameters. Make sure dates are enclosed in quotes. Check if the API key is valid. To know more about how to use an API key, please check the section on authentication.
#No Data	Input data is invalid or does not exist.

Note

You can also check the logs for more information on errors. You can access the logs by clicking on SynMax Commodities on the Excel ribbon and then clicking on Logs.