ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAX
1
NameIndexCount
TotalTrades
BasePriceDailyVolumeEnhanceLevelRegionHow to Use Warflash's Public Price Sheets V2Support MatrixSee also http://status.bdomarketapi.com/
2
[Archer] Arctic Fang Helmet60438102204,000,00000EURegion/Languageusdeeskrthtwrujpfrpttrsp
3
[Archer] Arctic Fang Outfit Set604383051,020,000,00000
1) a) Copy this sheet to your spreadsheet: See the image to the right.
CNA✓-----------
4
[Archer] Badakka Gloves61345103281,000,00000Language
If the newly copied sheet shows a '#Value' error simply refresh the page (f5)
NA✓✓✓---------
5
[Archer] Badakka Hat (Bucket)61343802352,000,00000us
b) Rename the copied sheet to 'Prices' (after copying it will be called 'Copy of Prices').
EU✓✓✓-----✓---
6
[Archer] Badakka Shoes61345203281,000,00000
2) Start looking up prices: See 'Look-up examples' below.
KR✓--✓--------
7
[Archer] Badakka Shoes (Papu)61345302281,000,00000
Sheet Shorthand
CEU✓✓----------
8
[Archer] Black Knight Armor61052807530,000,00000EU-us
Prices will update automatically every 30 mins.
SA✓-✓------✓-✓
9
[Archer] Black Knight Gloves61052905176,000,00000To view the ongoing discussion about price fetching, join the lifeskill Discord: https://discord.gg/j4xvqJVTH✓---✓-------
10
[Archer] Black Knight Helmet61052707220,000,00000Sheet ID
Contact for questions about the price sheets and price fetching: @warflash on Discord
RU✓-----✓-----
11
[Archer] Black Knight Outfit Set6105310601,100,000,000001q50gm4O8Vx6qfXEOmZ7xOgSZ_h70oExmtagTZM1TvUk
Contact for questions about this guide: @summer_rains on Discord.
SEA✓-----------
12
[Archer] Black Knight Shoes61053006176,000,00000TW✓----✓------
13
[Archer] Bloody Suit60883201641,100,000,00000
Prices provided by Warflash
JP✓------✓----
14
[Archer] Calpheon Noble Suit126973616595166,00010
Link to the API guide.
Look-up examplesMENA✓---------✓-
15
[Archer] Cantabile Clothes590641012530,000,00000
16
[Archer] Cantabile Gloves590642011176,000,000001) Base items: XLOOKUP (click for documentation)
17
[Archer] Cantabile Headband590640012220,000,00000Item (Input)Price (Output)Formula
18
[Archer] Cantabile Outfit Set5906440181,100,000,00000Valencia Meal23,200=XLOOKUP(L18,Prices!$A:$A,Prices!$E:$E)
19
[Archer] Cantabile Shoes590643013176,000,00000
20
[Archer] Chipmunk Headband59061802203,000,00000
Alternative look-up methods that you may be more familiar with: VLOOKUP, HLOOKUP, INDEX+MATCH
ShorthandIDRegions
Languages
21
[Archer] Corvicanus Crossbow560129070330,000,00000
Please don't use direct references (e.g. =Prices!$E$2) as they will break over time.
CNA-us
1QzB2AvZQXXkgc1CInu07XFxCx0oHBUFkFhEunYBvcEw
CNAus
22
[Archer] Corvicanus Greatbow560132074395,000,00000NA-de
1O7WfmIKezbSrIyWYewiqM_WnhrzGZlT_Z0lnLbY0so8
NAde
23
[Archer] Corvicanus Premium Set560133013332,020,000,000002) Enhanced items: FILTEREU-de
1j1fIyV_Gzn6iryAVzKwobk5pm8eLGBy8BGvZro6ja6Y
EUes
24
[Archer] Corvicanus Ra'ghon560130066199,000,00000Item (Input)Level (Input)Price (Output)FormulaEU-es
1hMJOyddJKVGbyBjUUwGWWGwWp-0hn452p6eRgLRDTj4
KRkr
25
[Archer] Corvicanus Robe5601280851,100,000,00000
lookup by name →
Kzarka Amulet202,240,000,000=INDEX(FILTER(Prices!$E:$E,Prices!$A:$A=L25,Prices!$G:$G=M25))KR-kr
1N4x4hfihUSoe9ETA8fn0dISRSyf2PQvDYtxEtv3F7Qg
CEUth
26
[Archer] Crayodel Soldier Hat60025806220,000,00000
lookup by index →
104100241,000,000=INDEX(FILTER(Prices!$E:$E,Prices!$B:$B=L26,Prices!$G:$G=M26),1)NA-es
1XH4oRQeTtecHBGYd87RmgMCZUZhCoq3AdC20akEgf38
SAtw
27
[Archer] Crayodel Soldier Outfit Set6002600181,100,000,00000
Please note that the price sheet is missing enhanced prices for certain items, which will show as #N/A. This issue may be resolved at some point in the future.
CEU-us
1VKMOsY2N2MYba-3ufidw5lPlbGb_1mXszA0KZ09nM9s
THru
28
[Archer] Crayodel Soldier Uniform60025903880,000,00000
Also, some base items appear twice in the price list. I wrapped the lookup formula in an INDEX() to only take the first result, which as far as I know is the right one.
SA-es
1BqU9WpfmensP8fgKV4Ji-a7cZAO8pcVhfsQqkysEUms
RUjp
29
[Archer] Delphe Knight Armor1269907015,600,00000TH-th
14vHOAsIj2kQfcsPsfQDYVspp38KFP_2dwFjrrapqQrU
SEAfr
30
[Archer] Derictus Armor560136051705,000,00000
If you have trouble understanding the formulas, I strongly encourage you to read the documentation and compare it to the formulas used here.
RU-us
18W68acOUsF7R09152mpJtqdnZSVhtj83k1v84t1tF0A
TWpt
31
[Archer] Derictus Classic Set560141061,630,000,00000
The Google sheets documentation is easy to read and incredibly helpful.
NA-us
1NsGi5c648KgnCyLdYWvtfkr36zjXK6FdBFxMjVQ_-9I
JPtr
32
[Archer] Derictus Crossbow560138040330,000,00000
If that still doesn't solve things, feel free to message me or @ me in the lifeskill Discord (Summer#8727).
SEA-us
1MImPpNxX47JfblbJVWatItMNYK0U0QtPM-g-Xl3z2gA
MENAsp
33
[Archer] Derictus Gloves560137059176,000,00000TW-tw
1SACVeQqcIecs4kPwPhd2x0nJy54BCAprf2YA_xnaLgA
34
[Archer] Derictus Greatbow560140054395,000,00000JP-us
1M256U1m3u3c6JC6iVtbpkdS-j4Dqj17U_uGBxc0I4TI
35
[Archer] Derictus Helmet560135070220,000,00000RU-ru
1ox0o-r9Ybff6UZk_4N4-Lh23m-NQvZ3aKvGCBWWbS8o
36
[Archer] Derictus Premium Set560142014322,020,000,00000JP-jp
1yHXcMWUC-797E50Lob-VUsyBNusC9ccbxzgt88qJLDs
37
[Archer] Derictus Ra'ghon560139047199,000,00000TH-us
1PrbdGNuP812PZQaEW6seFvygzzI3zO5PlnNvJemqg2s
38
[Archer] Duskherald Armor607143079530,000,00000EU-us
1q50gm4O8Vx6qfXEOmZ7xOgSZ_h70oExmtagTZM1TvUk
39
[Archer] Duskherald Classic Set607149021,630,000,00000EU-fr
1LqIi0RAm5pAtF66HTSNhTp5LRX5bPo_cc2sKarzg9Vw
40
[Archer] Duskherald Crossbow607146062330,000,00000CEU-de
1dBwNNUa4hA8aFNNb5DG3FKUGn4heiVg8C-98A5lFbWs
41
[Archer] Duskherald Gloves607144077176,000,00000KR-us
1wLh6u4NwKXn_RZjoNdpKnGDrzh0fOgWJbojmLFVCny0
42
[Archer] Duskherald Greatbow607148056395,000,00000MENA-us
1EFP3DLWPq76bVD6Z9z8-yoyjtJSlpOwbd7XHPd3YgqM
43
[Archer] Duskherald Helmet6071420109220,000,00000SA-us
1hBBWZkRRPdGiUWZWp1hSTPnH2xl37G39COW3lUekW2k
44
[Archer] Duskherald Premium Set607150016962,020,000,00000TW-us
1tPVsHE3mBawHp3tlzbj82nUq00gPto9Selc_Z3pJlY8
45
[Archer] Duskherald Ra'ghon607147064199,000,00000SA-pt
1p9SiQEGn8fuK7314ujdYasejjT4ponxgsUdf9SgYmdg
46
[Archer] Duskherald Shoes607145075176,000,00000MENA-tr
1imwi55_O92okrpnkdlrThVuHa4J_Kth0kepc6v3O8iA
47
[Archer] Edan's Travel Wear12700011751,120,00000SA-sp
18vP9JqQXoWu27bXfcLg-z-rKpBw-s6yj1OE292rkgAA
48
[Archer] Elderwood Armor612411011530,000,00000
49
[Archer] Elderwood Gloves612412013176,000,00000
50
[Archer] Elderwood Helmet612410010219,000,00000
51
[Archer] Elderwood Outfit Set6124140261,100,000,00000
52
[Archer] Elderwood Shoes612413011176,000,00000
53
[Archer] Garnier Troupe Garb126980761,400,00000
54
[Archer] Gierach Armor5600020457530,000,00000
55
[Archer] Gierach Classic Set56000708091,630,000,00000
56
[Archer] Gierach Crossbow5600050463330,000,00000
57
[Archer] Gierach Gloves5600030463176,000,00000
58
[Archer] Gierach Greatbow560043090395,000,00000
59
[Archer] Gierach Helmet5600010551220,000,00000
60
[Archer] Gierach Premium Set560083069402,020,000,00000
61
[Archer] Gierach Ra'ghon5600060462199,000,00000
62
[Archer] Gierach Shoes5600040473176,000,00000
63
[Archer] Glorious Shudad Armor590353045880,000,00000
64
[Archer] Glorious Shudad Classic Set590426041,630,000,00000
65
[Archer] Glorious Shudad Crossbow590424060330,000,00000
66
[Archer] Glorious Shudad Greatbow590443018395,000,00000
67
[Archer] Glorious Shudad Helmet590352048220,000,00000
68
[Archer] Glorious Shudad Premium Set
5904770542,020,000,00000
69
[Archer] Glorious Shudad Ra'ghon590425066198,000,00000
70
[Archer] Grave Keeper Gloves60705602176,000,00000
71
[Archer] Grave Keeper Hat60705407220,000,00000
72
[Archer] Grave Keeper Outfit Set6070570151,100,000,00000
73
[Archer] Heidel Masquerade Outfit Set604370071,090,000,00000
74
[Archer] Heidel Masquerade Phantom Mask
60436802218,000,00000
75
[Archer] Heidel Masquerade Suit60436902870,000,00000
76
[Archer] Ignis Armor590486023880,000,00000
77
[Archer] Ignis Classic Set59048904261,630,000,00000
78
[Archer] Ignis Crossbow590487019330,000,00000
79
[Archer] Ignis Helmet590485049220,000,00000
80
[Archer] Ignis Ra'ghon590488016198,000,00000
81
[Archer] Jordine's Casual Wear127010801,400,00000
82
[Archer] Karlstein Armor560075035880,000,00000
83
[Archer] Karlstein Armor75407605470,000,00000
84
[Archer] Karlstein Classic Set56007909971,630,000,00000
85
[Archer] Karlstein Crossbow560077029330,000,00000
86
[Archer] Karlstein Crossbow75407704179,000,00000
87
[Archer] Karlstein Hat560074061220,000,00000
88
[Archer] Karlstein Hat7540750381,000,00000
89
[Archer] Karlstein Ra'ghon560078033198,000,00000
90
[Archer] Karlstein Ra'ghon7540780397,500,00000
91
[Archer] Kibelius Armor560093032705,000,00000
92
[Archer] Kibelius Classic Set56009203751,630,000,00000
93
[Archer] Kibelius Crossbow560094041330,000,00000
94
[Archer] Kibelius Divinus Armor560090016705,000,00000
95
[Archer] Kibelius Divinus Classic Set56008801721,630,000,00000
96
[Archer] Kibelius Divinus Premium Set61113703142,020,000,00000
97
[Archer] Kibelius Greatbow5600960496395,000,00000
98
[Archer] Kibelius Helmet5600890126220,000,00000
99
[Archer] Kibelius Premium Set61113802272,020,000,00000
100
[Archer] Kibelius Ra'ghon560095043199,000,00000