import json,csv,os
reg=json.load(open('/opt/crew/paper/registry.json'))
out=csv.writer(open('/opt/crew/work/ppdata/entry_caps.csv','w'))
out.writerow(['test','pool','tok','entry_t','entry_bkk','entry_cap_usd','cap_col'])
for t in reg['tests']:
    f=t.get('trades')
    if not f or not os.path.exists(f): continue
    for r in csv.DictReader(open(f)):
        for c in ('cap_buy_usd','cap_chk_usd'):
            if r.get(c) not in (None,''): v=r[c];col=c;break
        else: v='';col=''
        out.writerow([t['id'],r.get('pool',''),r.get('tok',''),r.get('entry_t',''),r.get('entry_bkk',''),v,col])