31:T4bc,html` ${ ccyData.map(c=>{ return ` ` }) }

Comp	Buy	${unit}$	${10*unit}$	${100*unit}$	${1000*unit}$	Sell	${unit}ლ	${10*unit}ლ	${100*unit}ლ	${1000*unit}ლ
${c.comp}	${c.buy}	${format(convertToGel(unit,c.buy))}ლ	${format(convertToGel(10*unit,c.buy))}ლ	${format(convertToGel(100*unit,c.buy))}ლ	${format(convertToGel(1000*unit,c.buy))}ლ	${c.sell}	${convertToUSD(unit,c.sell)}$	${convertToUSD(10*unit,c.sell)}$	${convertToUSD(100*unit,c.sell)}$	${convertToUSD(1000*unit,c.sell)}$

`32:T47c,html` ${ ccyData.map(c=>{ return ` ` }) }

Comp	Buy	Sell	${unit}$	${10*unit}$	${100*unit}$	${1000*unit}$
${c.comp}	${c.buy}	${c.sell}	${format( convertToGel(unit*price/(price-guessTetri/100+(price-c.buy))-unit,c.buy) )}ლ	${format(convertToGel(10unitprice/(price-guessTetri/100+(price-c.buy))-unit*10,c.buy))}ლ	${format(convertToGel(100unitprice/(price-guessTetri/100+(price-c.buy))-unit*100,c.buy))}ლ	${format(convertToGel(1000unitprice/(price-guessTetri/100+(price-c.buy))-unit*1000,c.buy))}ლ

`33:T3082,usdtry1day2 =[ { "id": "USDGEL:CUR", "dateTimeRanges": { "start": "2018-08-01T21:00:00Z", "end": "2018-08-02T20:59:59Z" }, "price": [ { "dateTime": "2018-08-01T21:05:00Z", "value": 2.4488 }, { "dateTime": "2018-08-01T21:15:00Z", "value": 2.4488 }, { "dateTime": "2018-08-01T22:15:00Z", "value": 2.4488 }, { "dateTime": "2018-08-01T23:15:00Z", "value": 2.4488 }, { "dateTime": "2018-08-02T00:15:00Z", "value": 2.4488 }, { "dateTime": "2018-08-02T01:15:00Z", "value": 2.4488 }, { "dateTime": "2018-08-02T02:15:00Z", "value": 2.4488 }, { "dateTime": "2018-08-02T03:15:00Z", "value": 2.4488 }, { "dateTime": "2018-08-02T04:15:00Z", "value": 2.4488 }, { "dateTime": "2018-08-02T05:05:00Z", "value": 2.4488 }, { "dateTime": "2018-08-02T05:10:00Z", "value": 2.45 }, { "dateTime": "2018-08-02T05:15:00Z", "value": 2.45 }, { "dateTime": "2018-08-02T05:25:00Z", "value": 2.4483 }, { "dateTime": "2018-08-02T05:30:00Z", "value": 2.4475 }, { "dateTime": "2018-08-02T05:35:00Z", "value": 2.4475 }, { "dateTime": "2018-08-02T05:40:00Z", "value": 2.45 }, { "dateTime": "2018-08-02T05:50:00Z", "value": 2.4483 }, { "dateTime": "2018-08-02T06:15:00Z", "value": 2.4483 }, { "dateTime": "2018-08-02T06:30:00Z", "value": 2.4483 }, { "dateTime": "2018-08-02T06:40:00Z", "value": 2.4475 }, { "dateTime": "2018-08-02T06:50:00Z", "value": 2.446 }, { "dateTime": "2018-08-02T06:55:00Z", "value": 2.446 }, { "dateTime": "2018-08-02T07:20:00Z", "value": 2.4485 }, { "dateTime": "2018-08-02T07:35:00Z", "value": 2.4475 }, { "dateTime": "2018-08-02T09:05:00Z", "value": 2.45 }, { "dateTime": "2018-08-02T09:10:00Z", "value": 2.45 }, { "dateTime": "2018-08-02T09:20:00Z", "value": 2.4488 }, { "dateTime": "2018-08-02T09:25:00Z", "value": 2.4488 }, { "dateTime": "2018-08-02T09:30:00Z", "value": 2.4488 }, { "dateTime": "2018-08-02T09:35:00Z", "value": 2.4488 }, { "dateTime": "2018-08-02T09:50:00Z", "value": 2.45 }, { "dateTime": "2018-08-02T10:10:00Z", "value": 2.448 }, { "dateTime": "2018-08-02T10:25:00Z", "value": 2.4475 }, { "dateTime": "2018-08-02T10:35:00Z", "value": 2.448 } ], "previousClosingPriceOneTradingDayAgo": 2.4481, "tradingDayCloseUTC": "1533243599", "lastUpdateUTC": "1533206366", "timeZoneOffset": -4, "nyTradeStartTime": "17:00:00.000", "nyTradeEndTime": "16:59:59.000", "priceMinDecimals": 4, "lastUpdateDate": "2018-08-02", "lastPrice": 2.448 }, { "id": "USDTRY:CUR", "dateTimeRanges": { "start": "2018-08-01T21:00:00Z", "end": "2018-08-02T20:59:59Z" }, "price": [ { "dateTime": "2018-08-01T21:00:00Z", "value": 4.9949 }, { "dateTime": "2018-08-01T21:05:00Z", "value": 4.9953 }, { "dateTime": "2018-08-01T21:10:00Z", "value": 4.9969 }, { "dateTime": "2018-08-01T21:15:00Z", "value": 4.9995 }, { "dateTime": "2018-08-01T21:20:00Z", "value": 4.9995 }, { "dateTime": "2018-08-01T21:25:00Z", "value": 4.9995 }, { "dateTime": "2018-08-01T21:30:00Z", "value": 5.0013 }, { "dateTime": "2018-08-01T21:35:00Z", "value": 5.0036 }, { "dateTime": "2018-08-01T21:40:00Z", "value": 5.0032 }, { "dateTime": "2018-08-01T21:45:00Z", "value": 5.0044 }, { "dateTime": "2018-08-01T21:50:00Z", "value": 5.004 }, { "dateTime": "2018-08-01T21:55:00Z", "value": 5.0019 }, { "dateTime": "2018-08-01T22:00:00Z", "value": 5.0012 }, { "dateTime": "2018-08-01T22:05:00Z", "value": 5.0021 }, { "dateTime": "2018-08-01T22:10:00Z", "value": 5.0045 }, { "dateTime": "2018-08-01T22:15:00Z", "value": 5.0047 }, { "dateTime": "2018-08-01T22:20:00Z", "value": 5.0032 }, { "dateTime": "2018-08-01T22:25:00Z", "value": 5.002 }, { "dateTime": "2018-08-01T22:30:00Z", "value": 5.002 }, { "dateTime": "2018-08-01T22:35:00Z", "value": 5.0013 }, { "dateTime": "2018-08-01T22:40:00Z", "value": 5.001 }, { "dateTime": "2018-08-01T22:45:00Z", "value": 4.9996 }, { "dateTime": "2018-08-01T22:50:00Z", "value": 4.997 }, { "dateTime": "2018-08-01T22:55:00Z", "value": 4.9969 }, { "dateTime": "2018-08-01T23:00:00Z", "value": 4.996 }, { "dateTime": "2018-08-01T23:05:00Z", "value": 4.9957 }, { "dateTime": "2018-08-01T23:10:00Z", "value": 4.9957 }, { "dateTime": "2018-08-01T23:15:00Z", "value": 4.9956 }, { "dateTime": "2018-08-01T23:20:00Z", "value": 4.9943 }, { "dateTime": "2018-08-01T23:25:00Z", "value": 4.9922 }, { "dateTime": "2018-08-01T23:30:00Z", "value": 4.9917 }, { "dateTime": "2018-08-01T23:35:00Z", "value": 4.9872 }, { "dateTime": "2018-08-01T23:40:00Z", "value": 4.9844 }, { "dateTime": "2018-08-01T23:45:00Z", "value": 4.9838 }, { "dateTime": "2018-08-01T23:50:00Z", "value": 4.9842 }, { "dateTime": "2018-08-01T23:55:00Z", "value": 4.9835 }, { "dateTime": "2018-08-02T00:00:00Z", "value": 4.9846 }, { "dateTime": "2018-08-02T00:05:00Z", "value": 4.9847 }, { "dateTime": "2018-08-02T00:10:00Z", "value": 4.9848 }, { "dateTime": "2018-08-02T00:15:00Z", "value": 4.9844 }, { "dateTime": "2018-08-02T00:20:00Z", "value": 4.9836 }, { "dateTime": "2018-08-02T00:25:00Z", "value": 4.9886 }, { "dateTime": "2018-08-02T00:30:00Z", "value": 4.9901 }, { "dateTime": "2018-08-02T00:35:00Z", "value": 4.9896 }, { "dateTime": "2018-08-02T00:40:00Z", "value": 4.989 }, { "dateTime": "2018-08-02T00:45:00Z", "value": 4.9893 }, { "dateTime": "2018-08-02T00:50:00Z", "value": 4.9899 }, { "dateTime": "2018-08-02T00:55:00Z", "value": 4.9899 }, { "dateTime": "2018-08-02T01:00:00Z", "value": 4.9905 }, { "dateTime": "2018-08-02T01:05:00Z", "value": 4.9853 }, { "dateTime": "2018-08-02T01:10:00Z", "value": 4.9868 }, { "dateTime": "2018-08-02T01:15:00Z", "value": 4.9874 }, { "dateTime": "2018-08-02T01:20:00Z", "value": 4.9874 }, { "dateTime": "2018-08-02T01:25:00Z", "value": 4.9876 }, { "dateTime": "2018-08-02T01:30:00Z", "value": 4.9849 }, { "dateTime": "2018-08-02T01:35:00Z", "value": 4.9828 }, { "dateTime": "2018-08-02T01:40:00Z", "value": 4.9829 }, { "dateTime": "2018-08-02T01:45:00Z", "value": 4.9829 }, { "dateTime": "2018-08-02T01:50:00Z", "value": 4.9829 }, { "dateTime": "2018-08-02T01:55:00Z", "value": 4.9833 }, { "dateTime": "2018-08-02T02:00:00Z", "value": 4.9838 }, { "dateTime": "2018-08-02T02:05:00Z", "value": 4.9835 }, { "dateTime": "2018-08-02T02:10:00Z", "value": 4.9839 }, { "dateTime": "2018-08-02T02:15:00Z", "value": 4.9849 }, { "dateTime": "2018-08-02T02:20:00Z", "value": 4.9847 }, { "dateTime": "2018-08-02T02:25:00Z", "value": 4.9844 }, { "dateTime": "2018-08-02T02:30:00Z", "value": 4.9845 }, { "dateTime": "2018-08-02T02:35:00Z", "value": 4.9847 }, { "dateTime": "2018-08-02T02:40:00Z", "value": 4.9846 }, { "dateTime": "2018-08-02T02:45:00Z", "value": 4.9877 }, { "dateTime": "2018-08-02T02:50:00Z", "value": 4.9882 }, { "dateTime": "2018-08-02T02:55:00Z", "value": 4.9879 }, { "dateTime": "2018-08-02T03:00:00Z", "value": 4.989 }, { "dateTime": "2018-08-02T03:05:00Z", "value": 4.989 }, { "dateTime": "2018-08-02T03:10:00Z", "value": 4.9891 }, { "dateTime": "2018-08-02T03:15:00Z", "value": 4.9889 }, { "dateTime": "2018-08-02T03:20:00Z", "value": 4.9939 }, { "dateTime": "2018-08-02T03:25:00Z", "value": 4.9926 }, { "dateTime": "2018-08-02T03:30:00Z", "value": 4.9927 }, { "dateTime": "2018-08-02T03:35:00Z", "value": 4.9923 }, { "dateTime": "2018-08-02T03:40:00Z", "value": 4.991 }, { "dateTime": "2018-08-02T03:45:00Z", "value": 4.9913 }, { "dateTime": "2018-08-02T03:50:00Z", "value": 4.9923 }, { "dateTime": "2018-08-02T03:55:00Z", "value": 4.9887 }, { "dateTime": "2018-08-02T04:00:00Z", "value": 4.9837 }, { "dateTime": "2018-08-02T04:05:00Z", "value": 4.9853 }, { "dateTime": "2018-08-02T04:10:00Z", "value": 4.9878 }, { "dateTime": "2018-08-02T04:15:00Z", "value": 4.986 }, { "dateTime": "2018-08-02T04:20:00Z", "value": 4.9846 }, { "dateTime": "2018-08-02T04:25:00Z", "value": 4.9846 }, { "dateTime": "2018-08-02T04:30:00Z", "value": 4.9878 }, { "dateTime": "2018-08-02T04:35:00Z", "value": 4.9886 }, { "dateTime": "2018-08-02T04:40:00Z", "value": 4.9884 }, { "dateTime": "2018-08-02T04:45:00Z", "value": 4.9898 }, { "dateTime": "2018-08-02T04:50:00Z", "value": 4.9847 }, { "dateTime": "2018-08-02T04:55:00Z", "value": 4.9839 }, { "dateTime": "2018-08-02T05:00:00Z", "value": 4.9833 }, { "dateTime": "2018-08-02T05:05:00Z", "value": 4.9838 }, { "dateTime": "2018-08-02T05:10:00Z", "value": 4.9841 }, { "dateTime": "2018-08-02T05:15:00Z", "value": 4.9842 }, { "dateTime": "2018-08-02T05:20:00Z", "value": 4.9843 }, { "dateTime": "2018-08-02T05:25:00Z", "value": 4.9816 }, { "dateTime": "2018-08-02T05:30:00Z", "value": 4.9776 }, { "dateTime": "2018-08-02T05:35:00Z", "value": 4.9684 }, { "dateTime": "2018-08-02T05:40:00Z", "value": 4.9715 }, { "dateTime": "2018-08-02T05:45:00Z", "value": 4.9744 }, { "dateTime": "2018-08-02T05:50:00Z", "value": 4.985 }, { "dateTime": "2018-08-02T05:55:00Z", "value": 4.987 }, { "dateTime": "2018-08-02T06:00:00Z", "value": 4.991 }, { "dateTime": "2018-08-02T06:05:00Z", "value": 4.9863 }, { "dateTime": "2018-08-02T06:10:00Z", "value": 4.9869 }, { "dateTime": "2018-08-02T06:15:00Z", "value": 4.9915 }, { "dateTime": "2018-08-02T06:20:00Z", "value": 4.9893 }, { "dateTime": "2018-08-02T06:25:00Z", "value": 4.9882 }, { "dateTime": "2018-08-02T06:30:00Z", "value": 4.9845 }, { "dateTime": "2018-08-02T06:35:00Z", "value": 4.989 }, { "dateTime": "2018-08-02T06:40:00Z", "value": 4.9911 }, { "dateTime": "2018-08-02T06:45:00Z", "value": 5.0033 }, { "dateTime": "2018-08-02T06:50:00Z", "value": 5.0034 }, { "dateTime": "2018-08-02T06:55:00Z", "value": 5.0082 }, { "dateTime": "2018-08-02T07:00:00Z", "value": 5.0165 }, { "dateTime": "2018-08-02T07:05:00Z", "value": 5.0185 }, { "dateTime": "2018-08-02T07:10:00Z", "value": 5.0237 }, { "dateTime": "2018-08-02T07:15:00Z", "value": 5.045 }, { "dateTime": "2018-08-02T07:20:00Z", "value": 5.071 }, { "dateTime": "2018-08-02T07:25:00Z", "value": 5.0436 }, { "dateTime": "2018-08-02T07:30:00Z", "value": 5.0515 }, { "dateTime": "2018-08-02T07:35:00Z", "value": 5.0491 }, { "dateTime": "2018-08-02T07:40:00Z", "value": 5.0472 }, { "dateTime": "2018-08-02T07:45:00Z", "value": 5.0523 }, { "dateTime": "2018-08-02T07:50:00Z", "value": 5.0539 }, { "dateTime": "2018-08-02T07:55:00Z", "value": 5.0593 }, { "dateTime": "2018-08-02T08:00:00Z", "value": 5.0724 }, { "dateTime": "2018-08-02T08:05:00Z", "value": 5.0744 }, { "dateTime": "2018-08-02T08:10:00Z", "value": 5.0853 }, { "dateTime": "2018-08-02T08:15:00Z", "value": 5.0702 }, { "dateTime": "2018-08-02T08:20:00Z", "value": 5.0771 }, { "dateTime": "2018-08-02T08:25:00Z", "value": 5.0631 }, { "dateTime": "2018-08-02T08:30:00Z", "value": 5.068 }, { "dateTime": "2018-08-02T08:35:00Z", "value": 5.0717 }, { "dateTime": "2018-08-02T08:40:00Z", "value": 5.0667 }, { "dateTime": "2018-08-02T08:45:00Z", "value": 5.0617 }, { "dateTime": "2018-08-02T08:50:00Z", "value": 5.0664 }, { "dateTime": "2018-08-02T08:55:00Z", "value": 5.0725 }, { "dateTime": "2018-08-02T09:00:00Z", "value": 5.0767 }, { "dateTime": "2018-08-02T09:05:00Z", "value": 5.0725 }, { "dateTime": "2018-08-02T09:10:00Z", "value": 5.0771 }, { "dateTime": "2018-08-02T09:15:00Z", "value": 5.0775 }, { "dateTime": "2018-08-02T09:20:00Z", "value": 5.0813 }, { "dateTime": "2018-08-02T09:25:00Z", "value": 5.0881 }, { "dateTime": "2018-08-02T09:30:00Z", "value": 5.0896 }, { "dateTime": "2018-08-02T09:35:00Z", "value": 5.0884 }, { "dateTime": "2018-08-02T09:40:00Z", "value": 5.0814 }, { "dateTime": "2018-08-02T09:45:00Z", "value": 5.0864 }, { "dateTime": "2018-08-02T09:50:00Z", "value": 5.0862 }, { "dateTime": "2018-08-02T09:55:00Z", "value": 5.0871 }, { "dateTime": "2018-08-02T10:00:00Z", "value": 5.0905 }, { "dateTime": "2018-08-02T10:05:00Z", "value": 5.0836 }, { "dateTime": "2018-08-02T10:10:00Z", "value": 5.0871 }, { "dateTime": "2018-08-02T10:15:00Z", "value": 5.0875 }, { "dateTime": "2018-08-02T10:20:00Z", "value": 5.0868 }, { "dateTime": "2018-08-02T10:25:00Z", "value": 5.0831 }, { "dateTime": "2018-08-02T10:30:00Z", "value": 5.0772 }, { "dateTime": "2018-08-02T10:35:00Z", "value": 5.0675 }, { "dateTime": "2018-08-02T10:40:00Z", "value": 5.0655 }, { "dateTime": "2018-08-02T10:45:00Z", "value": 5.0683 }, { "dateTime": "2018-08-02T10:50:00Z", "value": 5.069 }, { "dateTime": "2018-08-02T10:55:00Z", "value": 5.0687 }, { "dateTime": "2018-08-02T11:00:00Z", "value": 5.0708 }, { "dateTime": "2018-08-02T11:05:00Z", "value": 5.0702 } ], "previousClosingPriceOneTradingDayAgo": 4.9946, "tradingDayCloseUTC": "1533243599", "lastUpdateUTC": "1533207976", "timeZoneOffset": -4, "nyTradeStartTime": "17:00:00.000", "nyTradeEndTime": "16:59:59.000", "priceMinDecimals": 4, "lastUpdateDate": "2018-08-02", "lastPrice": 5.054 } ]34:T6d0,ccyData={ var sell = Array.from(domTar.querySelectorAll('tbody tr td:nth-child(3)')).map(d=>d.innerText.trim()); var buy = Array.from(domTar.querySelectorAll('tbody tr td:nth-child(2)')).map(d=>d.innerText.trim()); var comp = Array.from(domTar.querySelectorAll('tbody tr td:nth-child(1)')).map(d=>d.innerText.trim()) .filter((d,i)=>i<11) var result = comp.map((d,i)=>{ if(d=="საქართველოს ბანკი"){ return bgOpt; } return { comp:d, buy:+buy[i], sell:+sell[i] } }); // var result = [bgOpt]; result = result.filter(d=>d.comp!='ვითიბი ბანკი'); var maxBuy = d3.max(result,d=>d.buy); var minSell = d3.min(result,d=>d.sell); var minBuy = d3.min(result,d=>d.buy); var maxSell = d3.max(result,d=>d.sell); result.forEach(r=>{ r.comp = r.comp.replace('ბანკი','') r.maxBuy=""; r.minSell=""; if(r.buy==minBuy){ r.minBuy=true; } if(r.buy==maxBuy){ r.maxBuy=true; } if(r.sell==minSell){ r.minSell=true; } if(r.sell==maxSell){ r.maxSell=true; } if(isNaN(r.buy)){ r.buy=0 } if(isNaN(r.sell)){ r.sell=0 } r.avg = (r.buy+r.sell)/2; r.bloombergDiff = Math.round((r.avg-price)*10000)/10000 r.nbgDiff = Math.round((r.avg-nbgCcy)*10000)/10000 }); result.sort((a,b)=>a.comp>b.comp); result.unshift({ comp:'NBG', buy:nbgCcy, sell:nbgCcy }) result.unshift({ comp:'Bloomberg', buy:price, sell:price }) result.forEach(r=>r.dateTime = new Date()) instituteDataHistory.push(result); return result; }35:T65c,ccyDataMicro={ var sell = Array.from(domTar.querySelectorAll('tbody tr td:nth-child(3)')).map(d=>d.innerText.trim()); var buy = Array.from(domTar.querySelectorAll('tbody tr td:nth-child(2)')).map(d=>d.innerText.trim()); var comp = Array.from(domTar.querySelectorAll('tbody tr td:nth-child(1)')).map(d=>d.innerText.trim()); var result = comp.map((d,i)=>{ if(d=="საქართველოს ბანკი"){ return bgOpt; } return { comp:d, buy:+buy[i], sell:+sell[i] } }); var maxBuy = d3.max(result,d=>d.buy); var minSell = d3.min(result,d=>d.sell); var minBuy = d3.min(result,d=>d.buy); var maxSell = d3.max(result,d=>d.sell); result.forEach(r=>{ r.comp = r.comp.replace('ბანკი','') r.maxBuy=""; r.minSell=""; if(r.buy==minBuy){ r.minBuy=true; } if(r.buy==maxBuy){ r.maxBuy=true; } if(r.sell==minSell){ r.minSell=true; } if(r.sell==maxSell){ r.maxSell=true; } if(isNaN(r.buy)){ r.buy=0 } if(isNaN(r.sell)){ r.sell=0 } r.avg = (r.buy+r.sell)/2; r.bloombergDiff = Math.round((r.avg-price)*10000)/10000 r.nbgDiff = Math.round((r.avg-nbgCcy)*10000)/10000 }); result.sort((a,b)=>a.comp>b.comp); result.unshift({ comp:'NBG', buy:nbgCcy, sell:nbgCcy }) result.unshift({ comp:'Bloomberg', buy:price, sell:price }) result.forEach(r=>r.dateTime = new Date()) instituteDataHistory.push(result); return result; }36:Ta3e,function generateComparisonsSVG(passedData){ var computedWidth = notebookWidth-220; if(computedWidth<0) computedWidth=0; var width = computedWidth//window.innerWidth; var max = d3.max(passedData,d=>d3.max(d.filter(r=>r.buy),s=>s.sell)); var min = d3.min(passedData,d=>d3.min(d.filter(r=>r.buy),s=>s.buy)); var minDate = passedData[0][0].dateTime; var maxDate = passedData[passedData.length-1][0].dateTime; var yScale = d3.scaleLinear().domain([max,min]).range([0,700]) var xScale = d3.scaleTime() .domain([minDate,maxDate]) .range([0,width]) var yAxis = d3.axisLeft(yScale) .ticks(10); var axis = d3.select(svg``).call(yAxis); axis.selectAll('.domain').remove(); axis.selectAll('text').attr('fill','gray').attr('x',-10).attr('text-anchor','end') var xAxisG = d3.axisBottom(xScale) .ticks(10); var xaxisG = d3.select(svg``).call(xAxisG); xaxisG.selectAll('.domain').remove(); xaxisG.selectAll('text').attr('fill','gray').attr('x',0).attr('text-anchor','middle').attr('font-size',10) var lineBuy = d3.line().x(d=>xScale(d.dateTime)).y(d=>yScale(d.buy)) var lineSell = d3.line().x(d=>xScale(d.dateTime)).y(d=>yScale(d.sell)); // // var convertedData = passedData[0].map((d,i)=>{ return passedData.map(arr=>{ return arr[i] }) }) return `` }37:T905,function generateSvg(config,data){ var computedWidth = notebookWidth-300; if(computedWidth<0) computedWidth=0; var width = computedWidth//window.innerWidth; var yScaleT = d3.scaleLinear().domain([config.max_value_t,config.min_value_t]).range([0,300]) var yScaleG = d3.scaleLinear().domain([config.max_value_g,config.min_value_g]).range([0,300]) var xScale = d3.scaleTime() .domain([new Date(config.min_date_g),new Date(config.max_date_g)]) .range([0,width]) var yAxisT = d3.axisLeft(yScaleT) .ticks(10); var axisT = d3.select(svg``).call(yAxisT); axisT.selectAll('.domain').remove(); axisT.selectAll('text').attr('fill','gray').attr('opacity',0.4).attr('x',-10).attr('text-anchor','end') var yAxisG = d3.axisRight(yScaleG) .ticks(10); var axisG = d3.select(svg``).call(yAxisG); axisG.selectAll('.domain').remove(); axisG.selectAll('text').attr('fill','red').attr('x',10).attr('text-anchor','start') var xAxisG = d3.axisBottom(xScale) .ticks(10); var xaxisG = d3.select(svg``).call(xAxisG); xaxisG.selectAll('.domain').remove(); xaxisG.selectAll('text').attr('fill','gray').attr('x',0).attr('text-anchor','middle').attr('font-size',10) var lineT = d3.line().x(d=>xScale(new Date(d[config.dateName]))).y(d=>yScaleT(d.value)) var lineG = d3.line().x(d=>xScale(new Date(d[config.dateName]))).y(d=>yScaleG(d.value)); var instituteLines = null; if(instituteDataHistory){ } return `` }38:T903,function generateOverviewSvg(data,by,params){ var computedWidth = notebookWidth-100; if(computedWidth<0) computedWidth=0; var width = params && params.width||computedWidth/2//window.innerWidth; var height=300; if(params&¶ms.filterByQuarter){ var currentDate = new Date(); var quartCurr = Math.floor((currentDate.getMonth()) /3)+1; data = data.filter(d=>{ var date = new Date(d.values[0].date); var quartData = Math.floor((date.getMonth()) /3)+1; if(quartCurr==quartData){ return true; } return false; }) } if(params&¶ms.filterByMonth){ var currentDate = new Date(); var month = currentDate.getMonth(); data = data.filter(d=>{ var date = new Date(d.values[0].date); if(month==date.getMonth()){ return true; } return false; }) } var yScales = data.map(d=>{ return d3.scaleLinear().domain([d['maxValue'+by],d['minValue'+by]]).range([0,height]); }); var xScales = data.map(d=>{ return d3.scaleTime().domain([new Date(d['minDate'+by]),new Date(d['maxDate'+by])]).range([0,width]); }); var lines = data.map((d,i)=>{ return d3.line().x(d=>xScales[i](new Date(d.date))).y(d=>yScales[i](d.value)) }); return `` }39:T6ec,function group(data,by){ if(by=='week'){ data.forEach(d=>{ var currDate = new Date(d.date); var minDate = new Date(d.date); var maxDate = new Date(d.date); var day = currDate.getDay(); var diff = currDate.getDate() - day + (day == 0 ? -6:1); minDate.setDate(diff) maxDate.setDate(diff+6); d.minDateweek =minDate; d.maxDateweek =maxDate; }) } if(by=='month'){ data.forEach(d=>{ var currDate = new Date(d.date); var minDate = new Date(currDate.getFullYear(),currDate.getMonth(),1); var maxDate = new Date(currDate.getFullYear(),currDate.getMonth()+1,0); d.minDatemonth =minDate.toString(); d.maxDatemonth =maxDate.toString();; }) } if(by=='quarter'){ data.forEach(d=>{ var currDate = new Date(d.date); var currQuarter = Math.floor((currDate.getMonth()) /3)+1; var minDate = new Date(currDate.getFullYear(),3*currQuarter-3,0); var maxDate = new Date(currDate.getFullYear(),3*currQuarter,0); d.minDatequarter =minDate.toString(); d.maxDatequarter =maxDate.toString(); d.maxDatequarter =maxDate.toString();; }) } if(by=='year'){ data.forEach(d=>{ var currDate = new Date(d.date); var minDate = new Date(currDate.getFullYear(),0,1); var maxDate = new Date(currDate.getFullYear(),12,0); d.minDateyear =minDate.toString(); d.maxDateyear =maxDate.toString();; }) } var result = data.$groupBy(['minDate'+by,'maxDate'+by]); result.forEach(d=>{ d['minValue'+by] = d3.min(d.values,v=>v.value); d['maxValue'+by] = d3.max(d.values,v=>v.value) }) return result; }3a:T610,EarlierStatistics = `

# Currency

1 $ = ${price} ლ

### Day - ${price} ლ ${svg`${generateSvg(ranges.day,usdtry1day)}`}
### Month - ${price} ლ ${svg`${generateSvg(ranges.month,usdtry1month)}`}
### Year - ${price} ლ ${svg`${generateSvg(ranges.year,usdtry1year)}`}
### 5 Year - ${price} ლ ${svg`${generateSvg(ranges.year5,usdtry5year)}`} ${d3.range(2).map(d=>"
")}

# Statistics & Projections ### Last Month / Year ${svg`${generateOverviewSvg(group(usdtry1month[0].price,"week"),'week')}`} ${svg`${generateOverviewSvg(group(usdtry1year[0].price,"week"),'week')}`} ### Last Year / 5 year ${svg`${generateOverviewSvg(group(usdtry1year[0].price,"month"),'month')}`} ${svg`${generateOverviewSvg(group(usdtry5year[0].price,"month"),'month')}`} ##### Last 5 year same month ${svg`${generateOverviewSvg(group(usdtry5year[0].price,"month"),'month',{filterByMonth:true})}`} ${svg`${generateOverviewSvg(group(usdtry5year[0].price,"month"),'month',{filterByQuarter:true})}`} ### Last Year / 5 year ${svg`${generateOverviewSvg(group(usdtry1year[0].price,"quarter"),'quarter')}`} ${svg`${generateOverviewSvg(group(usdtry5year[0].price,"quarter"),'quarter')}`} ##### last five year same quarter ${svg`${generateOverviewSvg(group(usdtry5year[0].price,"quarter"),'quarter',{width:notebookWidth-30,filterByQuarter:true})}`} ### Last 5 year ${svg`${generateOverviewSvg(group(usdtry5year[0].price,"year"),'year',{width:notebookWidth-30})}`} ${d3.range(200).map(d=>"
")} `.length3b:T602,{ if(dataHistory.length >3){ var computedWidth = notebookWidth-220; var height=700; var passedData = dataHistory; var max = d3.max(passedData,d=>d3.max(d.filter(r=>r.sell),s=>s.sell)); var min = d3.min(passedData,d=>d3.min(d.filter(r=>r.buy),s=>s.buy)); var minDate = passedData[0][0].dateTime; var maxDate = passedData[passedData.length-1][0].dateTime; var yScale = d3.scaleLinear().domain([max,min]).range([0,700]) var xScale = d3.scaleTime() .domain([minDate,maxDate]) .range([0,computedWidth]) var htmlNode = html`${generateComparisonsSVG(dataHistory)}`; var svg = d3.select(htmlNode); var texts = d3.select(htmlNode) .selectAll('.comp') .attr('cursor','move'); var nodes = texts.nodes(); svg.attr('pointer-events','all') .on('mouseover',d=>{ svg.selectAll('.tooltip').remove() var tooltip = svg.append('g').attr('class','tooltip').attr('transform',`translate(${d3.event.x+10},${d3.event.y-485})`); tooltip.append('rect').attr('width',200).attr('height',100); tooltip.append('text').text(xScale.invert(d3.event.x-80)).attr('fill','white').attr('x',0).attr('y',50); tooltip.append('text').text(yScale.invert(d3.event.y-979)).attr('fill','white').attr('x',0).attr('y',70); console.log(d3.event.x,d3.event.y) ; }) .on('mouseleave',d=>{ svg.selectAll('.tooltip').remove() }) texts.call(drag); yield htmlNode; } return "waiting for data ..." }3c:[] 2f:{"title":"ვალუტის კურსის ინტერაქტიული ანალიზი ","cells":[{"id":241,"value":"md`# ვალუტის კურსის ინტერაქტიული ანალიზი `","pinned":false,"hidden":false,"mode":"ojs"},{"id":1234,"value":"md`## სხვადასხვა ინსტიტუტების გაცვლითი კურსი`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1200,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":1360,"value":"viewof unit = html` `","pinned":false,"hidden":false,"mode":"ojs"},{"id":771,"value":"md`## მოგება ${guessTetri} თეთრიანი კურსის კურსის ცვლილების გამოცნობისას\n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1416,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":1322,"value":"viewof guessTetri = html` `","pinned":false,"hidden":false,"mode":"ojs"},{"id":2041,"value":"md`# მოკლევადიანი ცვლილების მოლოდინები \nმწვანე ნიშნავს მოლოდინს რომ მიმდინარე მდგომარეობით დოლარი მოიმატებს, წითელი დოლარი დაიკლებს \n# ინსტიტუტები\n\n\n 0?'#017453':'#BF0903'};color:white\"> ${bloombergDiff} ბლუმბერგის კურსთან შედარებით
\n0?'#017453':'#BF0903'};color:white\"> ${nbgDiff} ეროვნულის კურსთან შედარებით
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2057,"value":"html`\n\n\n\n${sortedExpectationsData.map(d=>{\n return ``\n}).join('')}\n\n\n\n${sortedExpectationsData.map(d=>{\n return ``\n}).join('')}\n\n\n${sortedExpectationsData.map(d=>{\n return ``\n}).join('')}\n\n

\n\n	${d.comp}
\nბლუმბერგის კურსიდან სხვაობის მოლოდინი \n	0&& 'style=\"background-color:#017453;color:white;border:1px solid black\"'} \n >${d.bloombergDiff}
\nეროვნულის კურსის ცვლილების მოლოდინი \n	0&& 'style=\"background-color:#017453;color:white;border:1px solid black\"'} \n >${d.nbgDiff}

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2236,"value":"viewof restartButton = button(\"restart\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":2427,"value":"md`

\n# მიმდინარე მდგომარეობით კურსი \n\n

1 $ = ${price} ლ - Bloomberg

1 $ = ${nbgCcy} ლ - NBG

1 $ = ${bgOpt.buy} - ${bgOpt.sell} ლ - BOG

\n
\n\n\n# სტატისტიკა \nგრაფიკზე დატანილია როგორც ლარი (წითელი), ასევე ლირა (ნაცრისფერი), რადგან ერთმანეთთან საკმაო კორელაციაში იმყოფებიან.\n\nხოლო მარცხნივ და მარჯვნივ აღნიშნულია პერიოდის განმავლობაში ცვლილება\n`\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":2424,"value":"md`### Day - ${price} ლ\n${svg`${generateSvg(ranges.day,usdtry1day)}`}\n\n
\n\n
\n### Year - ${price} ლ\n${svg`${generateSvg(ranges.year,usdtry1year)}`}\n
\n### 5 Year - ${price} ლ\n${svg`${generateSvg(ranges.year5,usdtry5year)}`}\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":174,"value":"md`\n\n\n\n${d3.range(2).map(d=>\"
\")}\n\n

\n# Statistics & Projections\n\n

\n### Last 5 year \n${svg`${generateOverviewSvg(group(usdtry5year[0].price,\"year\"),'year',{width:notebookWidth-30})}`}\n

\n### Last five year same quarter\n${svg`${generateOverviewSvg(group(usdtry5year[0].price,\"quarter\"),'quarter',{width:notebookWidth-30,filterByQuarter:true})}`}\n

\n### Last 5 year same month\n${svg`${generateOverviewSvg(group(usdtry5year[0].price,\"month\"),'month',{width:notebookWidth-30,filterByMonth:true})}`}\n\n\n\n\n\n\n${d3.range(10).map(d=>\"
\")}\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":854,"value":"nbgLogs=[{\n date:\"25 apr 2018\",\n type:\"sell\",\n amount:30000000,\n ccy:\"GEL\"\n}]","pinned":false,"hidden":false,"mode":"ojs"},{"id":1473,"value":"md`# Data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":726,"value":"usdtry1day = {\n //return test1monthData;\n ///*\n restartButton;\nvar result = load(\"https://www.bloomberg.com/markets/api/bulk-time-series/price/USDGEL%3ACUR,USDTRY%3ACUR?timeFrame=1_DAY\")\n yield result;\n for(var i=0;i<540;i++){\n yield Promises.delay(15*60 * 1000, load(\"https://www.bloomberg.com/markets/api/bulk-time-series/price/USDGEL%3ACUR,USDTRY%3ACUR?timeFrame=1_DAY\"))\n }\n //*/\n \n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2185,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":38,"value":"usdtry1month= new Promise((res,rej)=>{\n setTimeout(d=>{\n const result = load(\"https://www.bloomberg.com/markets/api/bulk-time-series/price/USDGEL%3ACUR,USDTRY%3ACUR?timeFrame=1_MONTH\");\n res(result)\n },6000) \n \n})\n ","pinned":false,"hidden":false,"mode":"ojs"},{"id":46,"value":"usdtry1year= new Promise((res,rej)=>{\n setTimeout(d=>{\n const result = load(\"https://www.bloomberg.com/markets/api/bulk-time-series/price/USDGEL%3ACUR,USDTRY%3ACUR?timeFrame=1_YEAR\");\n res(result)\n },9000) \n \n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":48,"value":"usdtry5year= new Promise((res,rej)=>{\n setTimeout(d=>{\n const result = load(\"https://www.bloomberg.com/markets/api/bulk-time-series/price/USDGEL%3ACUR,USDTRY%3ACUR?timeFrame=5_YEAR\");\n res(result)\n },9000) \n \n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1457,"value":" nbgCcy = {\n var arr = domNbg.innerText.split(/\\n/g).map(d=>d.trim()).filter(d=>d);\n var i = arr.indexOf('USD');\n return +arr[i+2];\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":365,"value":"price = usdtry1day[0].lastPrice","pinned":false,"hidden":false,"mode":"ojs"},{"id":2407,"value":"Array.from(domTar.querySelectorAll('tbody tr td:nth-child(1)'))\n .map(d=>d.innerText.trim())\n .filter((d,i)=>i<11)\n ","pinned":true,"hidden":false,"mode":"ojs"},{"id":1154,"value":"$34","pinned":true,"hidden":false,"mode":"ojs"},{"id":2216,"value":"$35","pinned":false,"hidden":false,"mode":"ojs"},{"id":2123,"value":"sortedExpectationsData = ccyData.sort((a,b)=>a.avg>b.avg?1:-1).filter(d=>d.avg)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2166,"value":"bloombergDiff = Math.round(10000*d3.mean(sortedExpectationsData,d=>d.bloombergDiff))/10000","pinned":false,"hidden":false,"mode":"ojs"},{"id":2174,"value":"nbgDiff = Math.round(10000*d3.mean(sortedExpectationsData,d=>d.nbgDiff))/10000","pinned":false,"hidden":false,"mode":"ojs"},{"id":988,"value":"bgOpt = {\n var arr = domBG.querySelector('Table tbody tr').innerText\n .split(/\\s/g)\n .filter(d=>d);\n \n return {\n comp:'საქართველოს ბანკი',\n buy:+arr[1].replace(/,/,'.'),\n sell:+arr[2].replace(/,/,'.')\n }\n \n return arr\n \n} ","pinned":false,"hidden":false,"mode":"ojs"},{"id":95,"value":"ranges = new Object({\n day: getRanges(usdtry1day),\n month:getRanges(usdtry1month),\n year:getRanges(usdtry1year),\n year5:getRanges(usdtry5year),\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1682,"value":"dataHistory = {\n\n for(var i=0;i<10000;i++){\n yield Promises.delay(10*1000, new Promise((resolve,reject)=>{ return resolve(instituteDataHistory.map(d=>d.filter(h=>h.comp!='ვითიბი ')))}))\n } \n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1579,"value":"md`# Svg`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1844,"value":"drag = d3.drag()\n .on('drag',function(d){\n d3.select(this)\n .attr('x',d3.event.x-this.getBoundingClientRect().width/2)\n .attr('y',d3.event.y+this.getBoundingClientRect().height/2-5)\n \n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1693,"value":"$36","pinned":false,"hidden":false,"mode":"ojs"},{"id":190,"value":"$37","pinned":false,"hidden":false,"mode":"ojs"},{"id":1674,"value":"instituteDataHistory=[]","pinned":false,"hidden":false,"mode":"ojs"},{"id":1867,"value":"JSON.stringify(instituteDataHistory)","pinned":false,"hidden":false,"mode":"ojs"},{"id":431,"value":"$38","pinned":false,"hidden":false,"mode":"ojs"},{"id":603,"value":"function getAxisByType(scale,type,height){\n var typemap = {\n 'week':{\n format: '%a',\n ticks:8\n },'month':{\n format: '%d',\n ticks:15\n },'quarter':{\n format: '%d %b',\n ticks:5\n },'year':{\n format: '%b',\n ticks:12\n }\n }\n var str = typemap[type].format;\n \n var format = d3.timeFormat(str);\n var cont = d3.select(svg``);\n var g = cont.append('g')\n g.attr('transform',`translate(0,${height})`)\n var axisBottom = d3.axisBottom(scale).tickFormat(format).ticks(typemap[type].ticks)\n var axis = g.call(axisBottom)\n axis.selectAll('.domain').remove();\n var result = cont.html();\n\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1583,"value":"md`# Calculations`","pinned":false,"hidden":false,"mode":"ojs"},{"id":783,"value":"function convertToGel(usd,ccy){\n if(ccy==0) {return 0;}\n var pr = ccy?ccy:price;\n return Math.round(Math.round(usd*pr*100)/100)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1363,"value":"function convertToUSD(gel,ccy){\n if(ccy==0) {return 0;}\n var pr = (ccy)?1/ccy:1/price;\n return Math.round(Math.round(gel*pr*100)/100)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":154,"value":"getRanges = function getRanges(objName){\n var dateName = \"dateTime\";\n if(!objName[0].price[0][dateName]){\n dateName=\"date\"\n }\n debugger;\n var result = {\n dateName:dateName,\n min_date_g : objName[0].price[0][dateName],\n max_date_g : objName[0].price[objName[0].price.length-1][dateName],\n min_value_g: d3.min(objName[0].price,d=>d.value),\n max_value_g: d3.max(objName[0].price,d=>d.value),\n \n min_date_t : objName[1].price[0][dateName],\n max_date_t : objName[1].price[objName[1].price.length-1][dateName],\n min_value_t: d3.min(objName[1].price,d=>d.value),\n max_value_t: d3.max(objName[1].price,d=>d.value)\n }\n \n result.min_date = d3.min([result.min_date_g,result.min_date_t]);\n result.max_date = d3.max([result.max_date_g,result.max_date_t]);\n \n return result;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":395,"value":"$39","pinned":false,"hidden":false,"mode":"ojs"},{"id":1585,"value":"md`# Libs`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1991,"value":"import {button} from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":836,"value":"import {load,scrape} from \"@bumbeishvili/fetcher\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":6,"value":"d3 = require(\"d3\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":397,"value":"md`# Utils`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1402,"value":"format=d=>d","pinned":false,"hidden":false,"mode":"ojs"},{"id":400,"value":"\nArray.prototype.$groupBy = function $groupBy (props) {\n var arr = this;\n var partialResult = {};\n \n arr.forEach(el=>{\n \n var grpObj = {};\n \n props.forEach(prop=>{\n grpObj[prop] = el[prop]\n });\n \n var key = JSON.stringify(grpObj);\n \n if(!partialResult[key]) partialResult[key] = [];\n \n partialResult[key].push(el);\n \n });\n \n var finalResult = Object.keys(partialResult).map(key=>{\n var keyObj = JSON.parse(key);\n keyObj.values = partialResult[key];\n return keyObj;\n })\n \n return finalResult;\n}\n\n\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":403,"value":"Date.prototype.$getWeekNumber = function $getWeekNumber(){\n var d = new Date(Date.UTC(this.getFullYear(), this.getMonth(), this.getDate()));\n var dayNum = d.getUTCDay() || 7;\n d.setUTCDate(d.getUTCDate() + 4 - dayNum);\n var yearStart = new Date(Date.UTC(d.getUTCFullYear(),0,1));\n return Math.ceil((((d - yearStart) / 86400000) + 1)/7)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1605,"value":"md`# Parsing`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1144,"value":"domBG = {\n restartButton;\n yield scrape(\"http://bankofgeorgia.ge/ge/information/treasury-operations/exchange-rates\",'dom')\n \n for(var i=0;i<540;i++){\n yield Promises.delay(60 * 1000, scrape(\"http://bankofgeorgia.ge/ge/information/treasury-operations/exchange-rates\",'dom'))\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1444,"value":"domTar = {\n restartButton;\n yield scrape(\"https://taripebi.ge/%E1%83%95%E1%83%90%E1%83%9A%E1%83%A3%E1%83%A2%E1%83%90-%E1%83%91%E1%83%90%E1%83%9C%E1%83%99%E1%83%94%E1%83%91%E1%83%A8%E1%83%98\",'dom')\n \n for(var i=0;i<540;i++){\n yield Promises.delay(60 * 1000, scrape(\"https://taripebi.ge/%E1%83%95%E1%83%90%E1%83%9A%E1%83%A3%E1%83%A2%E1%83%90-%E1%83%91%E1%83%90%E1%83%9C%E1%83%99%E1%83%94%E1%83%91%E1%83%A8%E1%83%98\",'dom'))\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1449,"value":"domNbg = scrape(\"https://www.nbg.gov.ge/index.php?m=582&lng=geo\",'dom')","pinned":false,"hidden":false,"mode":"ojs"},{"id":2198,"value":"","pinned":false,"hidden":false,"mode":"ojs"},{"id":2218,"value":"","pinned":false,"hidden":false,"mode":"ojs"},{"id":679,"value":"md`# Observable vars`","pinned":false,"hidden":false,"mode":"ojs"},{"id":685,"value":"notebookWidth=width","pinned":false,"hidden":false,"mode":"ojs"},{"id":523,"value":"md`# Debug`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2020,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs"},{"id":2038,"value":"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1712,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W3c","stdlib":"1","titling":"auto"}