by Palanion » Wed Oct 19, 2011 1:45 pm
For sorting within the player pool or free agent set:
There are many things you can sort by that have not visible links or data.
Copy this address into your URL field and edit the variables (in red):
fantasygames.sportingnews.com/stratomatic/trade/release_pickup_option.html?player_id=[color=red:8b8442872a]0[/color:8b8442872a]&position_id=[color=red:8b8442872a]X[/color:8b8442872a]&max_price=[color=red:8b8442872a]50000000[/color:8b8442872a]&avail=&hand=[color=red:8b8442872a]IS NOT NULL[/color:8b8442872a]&order_by=[color=red:8b8442872a]XXX[/color:8b8442872a]&rowstart=[color=red:8b8442872a]X[/color:8b8442872a]
Replace each appropriate variable with the correct codes/abbreviations listed below.
For [b:8b8442872a]player_id[/b:8b8442872a], I recommend it stays as 0. You can put in a player's ID number, but then there's really nothing to sort.
For [b:8b8442872a]position_ID[/b:8b8442872a], [code:1:8b8442872a]-1 (SP)
-2 (RP)
-3 (CL)
-4 (SP*)
-5 (non* SP)
-6 (RP-only)
1 (P)
2 (C)
3 (1b)
4 (2b)
5 (3b)
6 (ss)
7 (LF)
8 (CF)
9 (RF)
Any other number is ALL hitters
[/code:1:8b8442872a]
For [b:8b8442872a]max_price[/b:8b8442872a], you can put any amount (e.g., 1300000 for $1.3m).
For [b:8b8442872a]avail[/b:8b8442872a], leave this as is for all available free agents. If you want the entire player pool, then use (%2B).
For [b:8b8442872a]hand[/b:8b8442872a], use ='L' for left, ='R' for right, ='S' for switch, or IS NOT NULL for all players.
For [b:8b8442872a]order_by[/b:8b8442872a], you can order by any of the following:
[code:1:8b8442872a]name
range+ASC
error+ASC
arm+ASC
at_bats
doubles
triples
homeruns
rbis
walks
stolen_bases
bat_avg
on_base_pct
slug_pct
ops
strikeouts
bunting
hit_run
running
price
balance_value
wins
losses
saves
innings
hits_allowed
er_allowed
homeruns_allowed
walks_allowed
struckout
hold
WHIP
ERA
pitcher_batting
[/code:1:8b8442872a]
Add +ASC or +DESC to the [b:8b8442872a]order_by [/b:8b8442872a]for ascending or descending order.
For [b:8b8442872a]rowstart[/b:8b8442872a], the default is blank or 1. Each page is 25 rows, so if you want to skip to the third page, then it would be rowstart=51.
Use commas to sort by multiple criteria (e.g., range+ASC, error+ASC).
Enjoy the myriad of combinations.
EXAMPLES (again, the red shows the variables entered):
Do you want to sort all right fielders by their arm strength?
fantasygames.sportingnews.com/stratomatic/trade/release_pickup_option.html?player_id=[color=red:8b8442872a]0[/color:8b8442872a]&position_id=[color=red:8b8442872a]9[/color:8b8442872a]&max_price=[color=red:8b8442872a]50000000[/color:8b8442872a]&avail=&hand=[color=red:8b8442872a]IS NOT NULL[/color:8b8442872a]&order_by=[color=red:8b8442872a]arm+ASC[/color:8b8442872a]
Order starting pitchers by their defensive rating?
fantasygames.sportingnews.com/stratomatic/trade/release_pickup_option.html?player_id=[color=red:8b8442872a]0[/color:8b8442872a]&position_id=[color=red:8b8442872a]-4[/color:8b8442872a]&max_price=[color=red:8b8442872a]50000000[/color:8b8442872a]&avail=&hand=[color=red:8b8442872a]IS NOT NULL[/color:8b8442872a]&order_by=[color=red:8b8442872a]range+ASC[/color:8b8442872a]
OBP by catchers under $3.5 mil. by range (i.e., 1s, then 2s, with the 1s by obp, 2s by obp...)
fantasygames.sportingnews.com/stratomatic/trade/release_pickup_option.html?player_id=[color=red:8b8442872a]0[/color:8b8442872a]&position_id=[color=red:8b8442872a]2[/color:8b8442872a]&max_price=[color=red:8b8442872a]3500000[/color:8b8442872a]&avail=&hand=[color=red:8b8442872a]IS NOT NULL[/color:8b8442872a]&order_by=[color=red:8b8442872a]range+ASC,on_base_pct+DESC[/color:8b8442872a]
Want to sort those ranges by arm before OBP?
fantasygames.sportingnews.com/stratomatic/trade/release_pickup_option.html?player_id=[color=red:8b8442872a]0[/color:8b8442872a]&position_id=[color=red:8b8442872a]2[/color:8b8442872a]&max_price=[color=red:8b8442872a]3500000[/color:8b8442872a]&avail=&hand=[color=red:8b8442872a]IS NOT NULL[/color:8b8442872a]&order_by=[color=red:8b8442872a]range+ASC,arm+ASC,on_base_pct+DESC[/color:8b8442872a]
Enjoy!
Bill
Last edited by
Palanion on Thu Oct 20, 2011 9:33 am, edited 2 times in total.