home

News topics - US

headline news | recent news | latest news | market news | topics | stock topics

Country: US | UK | AU | HK | SG | MY

Market news - chevrons indicate local prediction, arrows show global predictions, circles show importance << error (1040, u'Too many connections') << error getdata ['', '(select max(p.dates) as dates, round(sum(pup*greatest(imp2-0.5,0.01))/sqrt(sum(greatest(imp2-.5,0.01))),2) as pup, round(sum(dud*greatest(imp-13,0.01))/sqrt(count(dates)*sum(greatest(imp-13,0.01))),2) as dud, round(sum(greatest(imp-12,0)*greatest(imp2,0))*sqrt((count(dates))),3) as imp, round(sum(imp2*imp2)*sqrt((count(dates))),3) as imp2, group_concat(if(locate(\'?\',img)>0,\'\',img) order by abs(pup)* greatest(imp2-.5,0.01) desc SEPARATOR \'\' ) as img, count(dates) as c ,group_concat(distinct concat(if(pup>.05,\'+ \',if(pup<-.05,\'- \',\'= \')), substring_index(substring_index(p.title,\'http\',1),\'|\',1), \'\') order by abs(pup)* greatest(imp2-.5,0.01) desc SEPARATOR \'
\') as summary , pp.sym as sym,pp.grps as grps,p.cat as cat from gdelt p inner join hashes pp using (id) inner join impact using(id) where p.dates>date_sub(now(), interval 6 hour) and imp2>0 and (isnull(pp.dup) or pp.dup=0 or pp.dup=pp.id) group by pp.sym,pp.grps,p.cat) as t inner join ggroup using (grps) left join stock on t.sym=stock.symexch']getdata default, columns (column) , cols (sector, grptitle, fastdate, pchange, imgs, close, category, grp, title, country, datecount, source, price, stock, fewlines, symbol, linkgrp, link, date, fastgrp, day, count, img, url, macro, lines, summary, micro, linkid, plainsymbol, minus) , layouts (striped, layout) , wheres (syms, where, fast, general) , filters (grp, cc, general, micro, important, veryimportant, exch, stock) , sorts (sort, fastdate, max, sum, olddatecount, sum2, datecount, date, freq) , heading, datas (data, textdata, sym)