Schema: LiveSurfaceAtm (ID: 1030)
METADATA
| Attribute | Value |
|---|---|
| Topic | 1000-analytics |
| MLink Token | OptSurface |
| SRSE Product | SRAnalytics |
Note: The symbol
=next to a field number indicates that it is a primary key.
BODY
| # | Field | Type | Default Value | Comment |
|---|---|---|---|---|
| 10= | ekey | ExpiryKey | ||
| 11= | surfaceType | enum : SurfaceCurveType | ||
| 100 | ticker | TickerKey | underlying stock key that this option expiration attaches to | |
| 103 | fkey | ExpiryKey | future that this option expiration month written on (if any) | |
| 106 | uBid | double | underlier bid price | |
| 109 | uAsk | double | underlier ask price | |
| 112 | years | float | time to expiration (in years) | |
| 115 | rate | float | interest rate | |
| 118 | sdiv | float | stock dividend (borrow rate) | |
| 121 | ddiv | float | present value of discrete dividend stream | |
| 124 | exType | byte | exercise type of the options used to compute this surface | |
| 127 | modelType | byte | option pricing model used for price calcs | |
| 130 | earnCnt | float | number of qualifying earnings events prior to expiration [can be fractional] (from StockEarningsCalendar) | |
| 133 | earnCntAdj | float | number of qualifying earnings events prior to expiration [adjusted] (from StockEarningsCalendar + LiveSurfaceTerm) | |
| 136 | axisVolRT | float | axis volatility x sqrt(years) (used to compute xAxis) [usually 4m atm vol] | |
| 139 | axisFUPrc | float | axis FwdUPrc (fwd underlying price used to compute xAxis) | |
| 142 | moneynessType | enum : MoneynessType | moneyness (xAxis) convention | |
| 145 | underlierMode | enum : UnderlierMode | underlier pricing mode (None=use spot/stock market; FrontMonth=use front month future market * uPrcRatio; Actual = use actual underlier future market) | |
| 148 | priceQuoteType | enum : PriceQuoteType | Price or Vol | |
| 151 | atmVol | float | atm vol (xAxis = 0) | |
| 154 | atmCen | float | atm vol (xAxis = 0) (eMove/earnCntAdj censored) | |
| 157 | atmVolHist | float | historical realized volatility (includes eMoveHist x earnCntAdj adjustment). Note that this is the default atmVol if no implied markets existed previous day. | |
| 160 | atmCenHist | float | censored (earnings events removed) historical realized volatility. Trailing periods is 2x forward time to expiration. From HistoricalVolatility(windowType=hlCen).mv_nnn | |
| 163 | minAtmVol | float | minimum estimated atm vol | |
| 166 | maxAtmVol | float | maximum estimated atm vol | |
| 169 | eMove | float | implied earnings move (from LiveSurfaceTerm) | |
| 172 | eMoveHist | float | historical earnings move (avg of trailing 8 moves). From StockEarningsCalendar.eMoveHist | |
| 175 | atmMove | float | fixed strike atm move from prior period | |
| 178 | atmCenMove | float | fixed strike atm (censored) move from prior period | |
| 181 | atmPhi | float | surface phi @ xAxis = 0 | |
| 184 | atmVega | float | surface vega @ xAxis = 0 | |
| 187 | slope | float | volatility surface slope (dVol / dXAxis) @ ATM (xAxis=0) | |
| 190 | varSwapFV | float | variance swap fair value (estimated by numerical integration over OTM price surface) | |
| 193 | gridType | enum : GridType | gridType defines D11 - U12 xAxis points + spline type | |
| 196 | minXAxis | float | minimum xAxis value; xAxis values to the left extrapolate horizontally | |
| 199 | maxXAxis | float | maximum xAxis value; xAxis values to the right extrapolate horizontally | |
| 202 | minCurvValue | float | minimum curvature (2nd derivative) of skew curve (can be negative if curve is not strictly convex) | |
| 205 | minCurvXAxis | float | xAxis of minimum curvature point | |
| 208 | maxCurvValue | float | maximum curvature (2nd derivative) of skew curve | |
| 211 | maxCurvXAxis | float | xAxis of maximum curvature point | |
| 214 | skewMinX | float | xAxis = (effStrike / effAxisFUPrc - 1.0) / axisVolRT; effStrike = strike * strikeRatio; effAxisFUPrc = axisFUPrc * symbolRatio | |
| 217 | skewMinY | float | skewMinX / skewMinY are the skew curve minimum point (usually a positive x value and a negative y value) | |
| 220 | skewD11 | float | skew @ D11 point (volatility skew curve) | |
| 223 | skewD10 | float | skew @ D10 point | |
| 226 | skewD9 | float | skew @ D9 point | |
| 229 | skewD8 | float | skew @ D8 point | |
| 232 | skewD7 | float | skew @ D7 point | |
| 235 | skewD6 | float | skew @ D6 point | |
| 238 | skewD5 | float | skew @ D5 point | |
| 241 | skewD4 | float | skew @ D4 point | |
| 244 | skewD3 | float | skew @ D3 point | |
| 247 | skewD2 | float | skew @ D2 point | |
| 250 | skewD1 | float | skew @ D1 point | |
| 253 | skewC0 | float | central value (@xAxis = 0) [usually zero] | |
| 256 | skewU1 | float | skew @ U1 point | |
| 259 | skewU2 | float | skew @ U2 point | |
| 262 | skewU3 | float | skew @ U3 point | |
| 265 | skewU4 | float | skew @ U4 point | |
| 268 | skewU5 | float | skew @ U5 point | |
| 271 | skewU6 | float | skew @ U6 point | |
| 274 | skewU7 | float | skew @ U7 point | |
| 277 | skewU8 | float | skew @ U8 point | |
| 280 | skewU9 | float | skew @ U9 point | |
| 283 | skewU10 | float | skew @ U10 point | |
| 286 | skewU11 | float | skew @ U11 point | |
| 289 | sdivD3 | float | sdiv @ D3 point | |
| 292 | sdivD2 | float | sdiv @ D2 point | |
| 295 | sdivD1 | float | sdiv @ D1 point | |
| 298 | sdivU1 | float | sdiv @ U1 point | |
| 301 | sdivU2 | float | sdiv @ U2 point | |
| 304 | sdivU3 | float | sdiv @ U3 point | |
| 307 | pwidth | float | minimum mkt premium width | |
| 310 | vwidth | float | minimum mkt volatility width | |
| 313 | cCnt | byte | num call strikes | |
| 316 | pCnt | byte | num put strikes | |
| 319 | cBidMiss | byte | number of call bid violations (surface outside the market) | |
| 322 | cAskMiss | byte | number of call ask violations (surface outside the market) | |
| 325 | pBidMiss | byte | number of put bid violations (surface outside the market) | |
| 328 | pAskMiss | byte | number of put ask violations (surface outside the market) | |
| 331 | fitAvgErr | float | surface fit R2 (mid-market values) | |
| 334 | fitAvgAbsErr | float | mean square error (mid-market values) | |
| 337 | fitMaxPrcErr | float | worst case surface premium violation | |
| 340 | fitErrXX | float | okey_xx of the option with the largest fit error in this expiration | |
| 343 | fitErrCP | enum : CallPut | okey_cp of the option with the largest fit error in this expiration | |
| 346 | fitErrDe | float | delta of the option with the largest fit error in this expiration | |
| 349 | fitErrBid | float | bid of the option with the largest fit error in this expiration | |
| 352 | fitErrAsk | float | ask of the option with the largest fit error in this expiration | |
| 355 | fitErrPrc | float | surface prc of the option with the largest fit error in this expiration | |
| 358 | fitErrVol | float | surface vol of the option with the largest fit error in this expiration | |
| 361 | counter | int | message counter - number of surface fits today | |
| 364 | skewCounter | int | skew surface fit counter | |
| 367 | sdivCounter | int | sdiv surface fit counter | |
| 380 | tradingSession | enum : TradingSession | trading session this surface is from | |
| 373 | tradeableStatus | enum : TradeableStatus | indicates whether the surface is currently tradeable or not (all server surface integrity checks pass) | |
| 376 | surfaceResult | enum : SurfaceResult | ||
| 379 | timestamp | DateTime |
Get Schema API Call
- Python
- cUrl
import requests
# Replace with your desired MLINK URL
MLINK_PROD_URL = 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json'
# Replace with your MLINK API Key
API_KEY = 'XXXX-XXXX-XXXX-XXXX'
# Replace with your desired MsgType.
MSG_TYPE = 'LiveSurfaceAtm'
# Request Parameters for Get Schema Of The MsgType
params = {
# Required Parameters
"apiKey": API_KEY,
"cmd": 'getschema',
"msgType": MSG_TYPE,
}
response = requests.get(MLINK_PROD_URL, params=params)
curl -G 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json' \
--data-urlencode 'apiKey=XXXX-XXXX-XXXX-XXXX' \
--data-urlencode 'cmd=getschema' \
--data-urlencode 'msgType=LiveSurfaceAtm'
Get Msg API Call
- Python
- cUrl
import requests
# Replace with your desired MLINK URL
MLINK_PROD_URL = 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json'
# Replace with your MLINK API Key
API_KEY = 'XXXX-XXXX-XXXX-XXXX'
# Replace with your desired MsgType.
MSG_TYPE = 'LiveSurfaceAtm'
# Replace with your pkey value for getting the specific message desired
PKEY = 'ReplaceThisValueForTheQueryToWork'
# Replace with your desired view. A "|" separated list of views can be provided
# If no view is provided, all views will be returned.
VIEW = 'ticker|fkey|uBid|uAsk|years|rate|sdiv|ddiv|exType|modelType|earnCnt|earnCntAdj|axisVolRT|axisFUPrc|moneynessType|underlierMode|priceQuoteType|atmVol|atmCen|atmVolHist|atmCenHist|minAtmVol|maxAtmVol|eMove|eMoveHist|atmMove|atmCenMove|atmPhi|atmVega|slope|varSwapFV|gridType|minXAxis|maxXAxis|minCurvValue|minCurvXAxis|maxCurvValue|maxCurvXAxis|skewMinX|skewMinY|skewD11|skewD10|skewD9|skewD8|skewD7|skewD6|skewD5|skewD4|skewD3|skewD2|skewD1|skewC0|skewU1|skewU2|skewU3|skewU4|skewU5|skewU6|skewU7|skewU8|skewU9|skewU10|skewU11|sdivD3|sdivD2|sdivD1|sdivU1|sdivU2|sdivU3|pwidth|vwidth|cCnt|pCnt|cBidMiss|cAskMiss|pBidMiss|pAskMiss|fitAvgErr|fitAvgAbsErr|fitMaxPrcErr|fitErrXX|fitErrCP|fitErrDe|fitErrBid|fitErrAsk|fitErrPrc|fitErrVol|counter|skewCounter|sdivCounter|tradingSession|tradeableStatus|surfaceResult|timestamp'
# Replace with your desired where clause.
# a string in the form "field1:eq:valuse" or "(field1:ne:value1 & field1:ne:value2)
# "WHERE" clauses can contain the following comparison symbols:
# :gt: is greater than
# :ge: is greater than or equal to
# :lt: is less than
# :le: is less than or equal to
# :eq: is equal
# :ne: is not equal
# %26 is an AND statement
# | is an OR statement
# :sw: is starts with
# :ew: is ends with
# :cv: is contains values
# :nv: is does not contain value
# :cb: is contained between (two dates for instance) separated by '$'
WHERE = ''
# Request Parameters for getmsg Of The MsgType
params = {
# Required Parameters
"apiKey": API_KEY,
"cmd": 'getmsg',
"pkey": PKEY,
"msgType": MSG_TYPE,
# Optional Parameters
"view": VIEW,
"where": WHERE
}
response = requests.get(MLINK_PROD_URL, params=params)
curl -G 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json' \
--data-urlencode 'apiKey=XXXX-XXXX-XXXX-XXXX' \
--data-urlencode 'cmd=getmsg' \
--data-urlencode 'pkey=ReplaceThisValueForTheQueryToWork' \
--data-urlencode 'msgType=LiveSurfaceAtm' \
--data-urlencode 'view=ticker|fkey|uBid|uAsk|years|rate|sdiv|ddiv|exType|modelType|earnCnt|earnCntAdj|axisVolRT|axisFUPrc|moneynessType|underlierMode|priceQuoteType|atmVol|atmCen|atmVolHist|atmCenHist|minAtmVol|maxAtmVol|eMove|eMoveHist|atmMove|atmCenMove|atmPhi|atmVega|slope|varSwapFV|gridType|minXAxis|maxXAxis|minCurvValue|minCurvXAxis|maxCurvValue|maxCurvXAxis|skewMinX|skewMinY|skewD11|skewD10|skewD9|skewD8|skewD7|skewD6|skewD5|skewD4|skewD3|skewD2|skewD1|skewC0|skewU1|skewU2|skewU3|skewU4|skewU5|skewU6|skewU7|skewU8|skewU9|skewU10|skewU11|sdivD3|sdivD2|sdivD1|sdivU1|sdivU2|sdivU3|pwidth|vwidth|cCnt|pCnt|cBidMiss|cAskMiss|pBidMiss|pAskMiss|fitAvgErr|fitAvgAbsErr|fitMaxPrcErr|fitErrXX|fitErrCP|fitErrDe|fitErrBid|fitErrAsk|fitErrPrc|fitErrVol|counter|skewCounter|sdivCounter|tradingSession|tradeableStatus|surfaceResult|timestamp' \
--data-urlencode 'where='
Get Msgs API Call
- Python
- cUrl
import requests
# Replace with your desired MLINK URL
MLINK_PROD_URL = 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json'
# Replace with your MLINK API Key
API_KEY = 'XXXX-XXXX-XXXX-XXXX'
# Replace with your desired MsgType.
MSG_TYPE = 'LiveSurfaceAtm'
# Replace with your desired view. A "|" separated list of views can be provided
# If no view is provided, all views will be returned
VIEW = 'ticker|fkey|uBid|uAsk|years|rate|sdiv|ddiv|exType|modelType|earnCnt|earnCntAdj|axisVolRT|axisFUPrc|moneynessType|underlierMode|priceQuoteType|atmVol|atmCen|atmVolHist|atmCenHist|minAtmVol|maxAtmVol|eMove|eMoveHist|atmMove|atmCenMove|atmPhi|atmVega|slope|varSwapFV|gridType|minXAxis|maxXAxis|minCurvValue|minCurvXAxis|maxCurvValue|maxCurvXAxis|skewMinX|skewMinY|skewD11|skewD10|skewD9|skewD8|skewD7|skewD6|skewD5|skewD4|skewD3|skewD2|skewD1|skewC0|skewU1|skewU2|skewU3|skewU4|skewU5|skewU6|skewU7|skewU8|skewU9|skewU10|skewU11|sdivD3|sdivD2|sdivD1|sdivU1|sdivU2|sdivU3|pwidth|vwidth|cCnt|pCnt|cBidMiss|cAskMiss|pBidMiss|pAskMiss|fitAvgErr|fitAvgAbsErr|fitMaxPrcErr|fitErrXX|fitErrCP|fitErrDe|fitErrBid|fitErrAsk|fitErrPrc|fitErrVol|counter|skewCounter|sdivCounter|tradingSession|tradeableStatus|surfaceResult|timestamp'
# Replace with your desired where clause.
# a string in the form "field1:eq:value" or "(field1:ne:value1 & field1:ne:value2)
# "WHERE" clauses can contain the following comparison symbols:
# :gt: is greater than
# :ge: is greater than or equal to
# :lt: is less than
# :le: is less than or equal to
# :eq: is equal
# :ne: is not equal
# %26 is an AND statement
# | is an OR statement
# :sw: is starts with
# :ew: is ends with
# :cv: is contains values
# :nv: is does not contain value
# :cb: is contained between (two dates for instance) separated by '$'
WHERE = ''
# Replace with your desired limit of how many messages you receive. The default limit is 500
LIMIT = 500
# Order clause eg. "(field1:DESC | field1:ASC | field2:DESC:ABS | field2:ASC:ABS" (default is unordered; default is faster)
ORDER = 'ticker:ASC'
# Request Parameters for getmsgs Of The MsgType
params = {
# Required Parameters
"apiKey": API_KEY,
"cmd": 'getmsgs',
"msgType": MSG_TYPE,
# Optional Parameters
"view": VIEW,
"where": WHERE,
"limit": LIMIT,
"order": ORDER
}
response = requests.get(MLINK_PROD_URL, params=params)
curl -G 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json' \
--data-urlencode 'apiKey=XXXX-XXXX-XXXX-XXXX' \
--data-urlencode 'cmd=getmsgs' \
--data-urlencode 'msgType=LiveSurfaceAtm' \
--data-urlencode 'view=ticker|fkey|uBid|uAsk|years|rate|sdiv|ddiv|exType|modelType|earnCnt|earnCntAdj|axisVolRT|axisFUPrc|moneynessType|underlierMode|priceQuoteType|atmVol|atmCen|atmVolHist|atmCenHist|minAtmVol|maxAtmVol|eMove|eMoveHist|atmMove|atmCenMove|atmPhi|atmVega|slope|varSwapFV|gridType|minXAxis|maxXAxis|minCurvValue|minCurvXAxis|maxCurvValue|maxCurvXAxis|skewMinX|skewMinY|skewD11|skewD10|skewD9|skewD8|skewD7|skewD6|skewD5|skewD4|skewD3|skewD2|skewD1|skewC0|skewU1|skewU2|skewU3|skewU4|skewU5|skewU6|skewU7|skewU8|skewU9|skewU10|skewU11|sdivD3|sdivD2|sdivD1|sdivU1|sdivU2|sdivU3|pwidth|vwidth|cCnt|pCnt|cBidMiss|cAskMiss|pBidMiss|pAskMiss|fitAvgErr|fitAvgAbsErr|fitMaxPrcErr|fitErrXX|fitErrCP|fitErrDe|fitErrBid|fitErrAsk|fitErrPrc|fitErrVol|counter|skewCounter|sdivCounter|tradingSession|tradeableStatus|surfaceResult|timestamp' \
--data-urlencode 'where=' \
--data-urlencode 'limit=500' \
--data-urlencode 'order=ticker:ASC'
Get Aggregate API Call
- Python
- cUrl
import requests
# Replace with your desired MLINK URL
MLINK_PROD_URL = 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json'
# Replace with your MLINK API Key
API_KEY = 'XXXX-XXXX-XXXX-XXXX'
# Replace with your desired MsgType.
MSG_TYPE = 'LiveSurfaceAtm'
# Replace with fields you want to see aggregate values for. A "|" separated list of measures should be provided
MEASURE = 'ticker|fkey|uBid|uAsk|years|rate|sdiv|ddiv|exType|modelType|earnCnt|earnCntAdj|axisVolRT|axisFUPrc|moneynessType|underlierMode|priceQuoteType|atmVol|atmCen|atmVolHist|atmCenHist|minAtmVol|maxAtmVol|eMove|eMoveHist|atmMove|atmCenMove|atmPhi|atmVega|slope|varSwapFV|gridType|minXAxis|maxXAxis|minCurvValue|minCurvXAxis|maxCurvValue|maxCurvXAxis|skewMinX|skewMinY|skewD11|skewD10|skewD9|skewD8|skewD7|skewD6|skewD5|skewD4|skewD3|skewD2|skewD1|skewC0|skewU1|skewU2|skewU3|skewU4|skewU5|skewU6|skewU7|skewU8|skewU9|skewU10|skewU11|sdivD3|sdivD2|sdivD1|sdivU1|sdivU2|sdivU3|pwidth|vwidth|cCnt|pCnt|cBidMiss|cAskMiss|pBidMiss|pAskMiss|fitAvgErr|fitAvgAbsErr|fitMaxPrcErr|fitErrXX|fitErrCP|fitErrDe|fitErrBid|fitErrAsk|fitErrPrc|fitErrVol|counter|skewCounter|sdivCounter|tradingSession|tradeableStatus|surfaceResult|timestamp'
# Replace with fields you want to see aggregated. A "|" separated list of fields should be provided
GROUP = 'moneynessType|underlierMode|priceQuoteType|gridType|fitErrCP|tradingSession|tradeableStatus|surfaceResult'
# Replace with your desired where clause.
# a string in the form "field1:eq:value" or "(field1:ne:value1 & field1:ne:value2)
# "WHERE" clauses can contain the following comparison symbols:
# :gt: is greater than
# :ge: is greater than or equal to
# :lt: is less than
# :le: is less than or equal to
# :eq: is equal
# :ne: is not equal
# %26 is an AND statement
# | is an OR statement
# :sw: is starts with
# :ew: is ends with
# :cv: is contains values
# :nv: is does not contain value
# :cb: is contained between (two dates for instance) separated by '$'
WHERE = ''
# Request Parameters for getaggregate Of The MsgType
params = {
# Required Parameters
"apiKey": API_KEY,
"cmd": 'getaggregate',
"msgType": MSG_TYPE,
"measure": MEASURE,
"group": GROUP,
# Optional Parameters
"where": WHERE,
}
response = requests.get(MLINK_PROD_URL, params=params)
curl -G 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json' \
--data-urlencode 'apiKey=XXXX-XXXX-XXXX-XXXX' \
--data-urlencode 'cmd=getaggregate' \
--data-urlencode 'msgType=LiveSurfaceAtm' \
--data-urlencode 'measure=ticker|fkey|uBid|uAsk|years|rate|sdiv|ddiv|exType|modelType|earnCnt|earnCntAdj|axisVolRT|axisFUPrc|moneynessType|underlierMode|priceQuoteType|atmVol|atmCen|atmVolHist|atmCenHist|minAtmVol|maxAtmVol|eMove|eMoveHist|atmMove|atmCenMove|atmPhi|atmVega|slope|varSwapFV|gridType|minXAxis|maxXAxis|minCurvValue|minCurvXAxis|maxCurvValue|maxCurvXAxis|skewMinX|skewMinY|skewD11|skewD10|skewD9|skewD8|skewD7|skewD6|skewD5|skewD4|skewD3|skewD2|skewD1|skewC0|skewU1|skewU2|skewU3|skewU4|skewU5|skewU6|skewU7|skewU8|skewU9|skewU10|skewU11|sdivD3|sdivD2|sdivD1|sdivU1|sdivU2|sdivU3|pwidth|vwidth|cCnt|pCnt|cBidMiss|cAskMiss|pBidMiss|pAskMiss|fitAvgErr|fitAvgAbsErr|fitMaxPrcErr|fitErrXX|fitErrCP|fitErrDe|fitErrBid|fitErrAsk|fitErrPrc|fitErrVol|counter|skewCounter|sdivCounter|tradingSession|tradeableStatus|surfaceResult|timestamp' \
--data-urlencode 'group=moneynessType|underlierMode|priceQuoteType|gridType|fitErrCP|tradingSession|tradeableStatus|surfaceResult' \
--data-urlencode 'where='
Get Count API Call
- Python
- cUrl
import requests
# Replace with your desired MLINK URL
MLINK_PROD_URL = 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json'
# Replace with your MLINK API Key
API_KEY = 'XXXX-XXXX-XXXX-XXXX'
# Replace with your desired MsgType.
MSG_TYPE = 'LiveSurfaceAtm'
# Replace with your desired where clause.
# a string in the form "field1:eq:value" or "(field1:ne:value1 & field1:ne:value2)
# "WHERE" clauses can contain the following comparison symbols:
# :gt: is greater than
# :ge: is greater than or equal to
# :lt: is less than
# :le: is less than or equal to
# :eq: is equal
# :ne: is not equal
# %26 is an AND statement
# | is an OR statement
# :sw: is starts with
# :ew: is ends with
# :cv: is contains values
# :nv: is does not contain value
# :cb: is contained between (two dates for instance) separated by '$'
WHERE = ''
# Request Parameters for getCount Of The MsgType
params = {
# Required Parameters
"apiKey": API_KEY,
"cmd": 'getcount',
"msgType": MSG_TYPE,
# Optional Parameters
"where": WHERE,
}
response = requests.get(MLINK_PROD_URL, params=params)
curl -G 'https://mlink-live.nms.saturn.spiderrockconnect.com/rest/json' \
--data-urlencode 'apiKey=XXXX-XXXX-XXXX-XXXX' \
--data-urlencode 'cmd=getcount' \
--data-urlencode 'msgType=LiveSurfaceAtm' \
--data-urlencode 'where='