Anyway to update URL using google sheets
I look up dozens of contracts per day for options flow. Trying to break it down so it makes sense, but it's difficult to type out.
This is what an example URL looks like: https://unusualwhales.com/flow/option_chains?chain=TGT250620C00160000&days=1&mins=5&
| This won't change | https://unusualwhales.com/flow/option_chains?chain= | |
|---|---|---|
| Dynamic | TGT | This is the Ticker this example is Target or TGT |
| Dynamic | 250620 | This is the expiration date = 06/20/2025 |
| Dynamic | C00160000 | The letter C means it's a CALL (this will only ever be P or C) The numbers are the strike in this case it's the $160 strike (not sure what the extra 0's are) |
|---|---|---|
| Doesn't ever need to change | &days=1&mins=5& | This is the time frame to look at the contract, in this case it's 1 day in 5 minute intervals |
So in sheets I want something like below (examples on the far right)
| Ticker | enter data here | PLTR |
|---|---|---|
| Expiration Date | enter data here | 02/07/2025 |
| Side & Strike | enter data here | Call 90 |
The URL it would spit out would be this: https://unusualwhales.com/flow/option_chains?chain=PLTR250207C00090000&days=1&mins=5&
Hopefully that makes sense. I've already spent a couple of hours trying various things haha