Diskuze: Je mozne dostat data z teto stranky?

V předchozím kvízu, Online test znalostí JavaScript, jsme si ověřili nabyté zkušenosti z kurzu.

Aktivity

Jarmil Patocka

Člen

Jarmil Patocka:19.6.2017 14:51

Ahoj,

predem se priznavam, ze s JS nemam zadne zkusenosti a proto se obracim s prosbou a dotazem na toto forum. Pokud by nekdo vedel a mohl poradit, budu velice vdecny.

http://www.nordpoolspot.com/…hange-rates/?…

Potreboval bych automaticky tahat a nasledne vyuzivat data z teto webove stranky (GBP/EUR smenny kurz - bohuzel potrebuji data z tohoto zdroje, zobrazene jako seznam kurzu za posledni mesic), ale stranka je hodne resena JS a dynamicky generovana a nevim, jestli je mozne zjistit odkud to ta publikovana data taha. Nejradeji bych vyuzil napr. Google Sheets a nejakou jejich IMPORT funkci, aby to pravidelne nacitalo a aktualizovalo data z tehle tabulky, ale nejsem si jist, zda-li to vubec pujde.

Pokud by se na to mohl nekdo podivat a ze zdrojaku rici, jestli existuje nejaka sance jak ta data z te tabulky pomoci Google Sheets dostat, budu velice vdecny.

Dekuji za odpoved.

Jarmil

Odpovědět

19.6.2017 14:51

Jarmil Patocka

Člen

Jarmil Patocka:19.6.2017 15:02

Asi nejjednodussi reseni by bylo zjistit zdoj/URL adresu pro "Exchange rates.xls" soubor, ktery to vygeneruje pri kliknuti na ikonku "Export data to Excel" v pravem hornim rohu toho framu, ve kterem jsou data zobrazena. Je to generovano funkci ctrl.exportXls() a tady koncim, a dal se nehnu.

Je nejak mozne zjistit URL toho souboru, odkud by se pak snadno dal stahnout a dale zpracovat?

Diky za odpoved.

Jarmil

Nahoru Odpovědět

19.6.2017 15:02

David Hynek

Tvůrce

David Hynek:19.6.2017 15:39

ten server nabízí možnost si za úplatu ty data stahovat a dostal bys přesně to co chceš. http://www.nordpoolspot.com/…uct-details/

Nahoru Odpovědět

19.6.2017 15:39

Čím víc vím, tím víc věcí nevím.

David Hynek

Tvůrce

David Hynek:19.6.2017 15:42

A jestli potřebuješ jen poměr eura k libře, tak zkus tohle: https://www.cnb.cz/…ho_trhu.html výsledný poměr je skoro stejný. Jen si ty data stáhni každý den, ulož a pak s nimi můžeš nakládat jak potřebuješ... tedy vypsat poslední měsíc, nebo posledních 30 dní a pod.

Editováno 19.6.2017 15:44

Nahoru Odpovědět

19.6.2017 15:42

Čím víc vím, tím víc věcí nevím.

Jiří Fencl

Člen

Jiří Fencl:19.6.2017 15:45

Netusim, jak dlouho a jestli se pohybujete i v oblasti obchodovani v IT, ale dnes chteji zakaznici zasadne vse zdarma, co nejkvalitneji a nejlepe na pockani

Nerad bych se ale jakkoliv dotkl tazatele neb z dotazu bych usoudil, ze to chce jen pro soukrome ucely...

Nahoru Odpovědět

19.6.2017 15:45

Jarmil Patocka

Člen

Jarmil Patocka:19.6.2017 16:41

Ano, data chci vyuzit pro svoje soukrome vypocty a nejaka overovani, a z toho duvodu se mi za data od NordPoolSpotu nechce platit (vim, ze je jako zpoplatnena nabizi). Jak jiz bylo zmineno, potrebuji presne tyto hodnoty kurzu GBP/EUR, ktere se vyuzivaji pro dalsi vypocty ve spotovych trzich s elektrinou, tudiz mi hodnoty z CNB nebo jinych zdroju jsou k nicemu, i kdyz jsou rozdily nekdy ne prilis velke.

Jak jsem psal, idealni by bylo, pokud by bylo mozne ze zdrojaku stranek jakym zpusobem je soubor "Exchange rates.xls" generovan JS a pod jakou URL adresou je k dispozici. S tim uz by bylo nasledne zpracovani dat trivialni.

Pokud neco podobneho neni mozne ze zdrojaku vyzjistit, omlouvam se a muj dotaz muzete ignorovat. Opravdu se v tom nevyznam a tak se obracim na foru, kde by JS nekdo rozumet mohl.

Jeste jednou diky.

Jarmil

Nahoru Odpovědět

19.6.2017 16:41

Marian Benčat

Člen

Marian Benčat:20.6.2017 19:03

Web je napsaný (alepsoň ta část s tabulkou) v Angularu 1.

Volá se fce:

toXls: function(a, b, c) {
                   var d, e, f, g, h, i, j, k, l, m, n;
                   for (g = b.cloneNode(!0), f = g.getElementsByTagName("td"), m = 0, n = f.length; m < n; m++) d = f[m], e = d.innerHTML, d.hasChildNodes() && (d.childNodes[0].nodeValue = e.replace(/\s/g, "")), "-" === e && (d.childNodes[0].nodeValue = "");
                   if (j = g.outerHTML.replace(/&amp;nbsp;/g, "&nbsp;"), i = document.createElement("form"), i.action = "/api/marketdata/exportxls", i.method = "POST", i.target = "_blank", h = {
                           PageId: a,
                           Content: j,
                           Unit: c
                       })
                       for (l in h) k = document.createElement("textarea"), k.name = l, k.value = h[l], i.appendChild(k);
                   return i.style.display = "none", document.body.appendChild(i), i.submit()
               }

A to se volá zde:

return a = document.getElementById("datatable"), this.ExportExcelService.toXls(this.state.dashboardPageId, a, this.state.tData[this.dk].unit)

Zkráceně.. je to strašně prasácké řešení.. Pošlou si na API data z Browser z té tabulky a ten vrátí Excel jako soubor..

pokud si otevřeš F12 konzoli, otevřeš si Sources->Assets->Script-release->nordpool.js

pak dole klikni na tlačítko "{}" to ti to udělá, že ten minifikovaný zdroják pujde debugovat a bude čitelný,..

pak zajdi na řádku 1303 a dej si tam breakpoing:

Jako to vidis zde:
http://i64.tinypic.com/2hofo2c.png
Pak klikni na to tlacitko a uvidis s jakyma parametrama volaji tu funkci.. Pokud si to budes debugovat dále, zjistíš, že dělají POST request na URL:
/api/marketdata/exportxls

s určitým payloadem (to jsou defakto ty argumenty té funkce).

Vypadá to navíc, že mají povolené CORS, takže by jsi ten POST request měl být schopný volat i od sebe.

Nahoru Odpovědět

20.6.2017 19:03

Totalitní admini..

Marian Benčat

Člen

Marian Benčat:20.6.2017 19:09

Abych byl presnejsi. pri kliknuti na download vytvori skrytý formulář, kam napere ty data a ten odešle, prostě prasárna.

Nahoru Odpovědět

20.6.2017 19:09

Totalitní admini..

Marian Benčat

Člen

Marian Benčat:20.6.2017 19:13

Jak to vypadá

Nahoru Odpovědět

20.6.2017 19:13

Totalitní admini..

Marian Benčat

Člen

Marian Benčat:20.6.2017 19:20

Mimochodem,... ještě jeden postřeh.. nevrátí to excel.. Pokud se koukneš, co je to za soubor.. je to HTML table s příponou XLSX, což umí excel otevřít, ale ve skutečnosti je to HTMLková tabulka...

Request má vypadat takto:

POST http://www.nordpoolspot.com//api/marketdata/exportxls

Payload:
content:

<table id=\"datatable\" class=\"narrow\"><thead><tr class=\"column-headers\"><th class=\"row-name table-time-position sortable-position\">&nbsp;</th><th class=\"draggable sortable\">Official</th></tr></thead><tbody><tr class=\"data-row evenrow\"><td class=\"row-name\">21-06-2017</td><td class=\"future sortable\">1,1389</td></tr><tr class=\"data-row oddrow\"><td class=\"row-name\">20-06-2017</td><td class=\"sortable\">1,1444</td></tr><tr class=\"data-row evenrow\"><td class=\"row-name\">19-06-2017</td><td class=\"sortable\">1,1445</td></tr><tr class=\"data-row oddrow\"><td class=\"row-name\">18-06-2017</td><td class=\"sortable\">1,1445</td></tr><tr class=\"data-row evenrow\"><td class=\"row-name\">17-06-2017</td><td class=\"sortable\">1,1434</td></tr><tr class=\"data-row oddrow\"><td class=\"row-name\">16-06-2017</td><td class=\"sortable\">1,1370</td></tr><tr class=\"data-row evenrow\"><td class=\"row-name\">15-06-2017</td><td class=\"sortable\">1,1368</td></tr><tr class=\"data-row oddrow\"><td class=\"row-name\">14-06-2017</td><td class=\"sortable\">1,1347</td></tr><tr class=\"data-row evenrow\"><td class=\"row-name\">13-06-2017</td><td class=\"sortable\">1,1328</td></tr><tr class=\"data-row oddrow\"><td class=\"row-name\">12-06-2017</td><td class=\"sortable\">1,1386</td></tr><tr class=\"data-row evenrow\"><td class=\"row-name\">11-06-2017</td><td class=\"sortable\">1,1386</td></tr><tr class=\"data-row oddrow\"><td class=\"row-name\">10-06-2017</td><td class=\"sortable\">1,1386</td></tr><tr class=\"data-row evenrow\"><td class=\"row-name\">09-06-2017</td><td class=\"sortable\">1,1523</td></tr><tr class=\"data-row oddrow\"><td class=\"row-name\">08-06-2017</td><td class=\"sortable\">1,1462</td></tr><tr class=\"data-row evenrow\"><td class=\"row-name\">07-06-2017</td><td class=\"sortable\">1,1484</td></tr><tr class=\"data-row oddrow\"><td class=\"row-name\">06-06-2017</td><td class=\"sortable\">1,1478</td></tr><tr class=\"data-row evenrow\"><td class=\"row-name\">05-06-2017</td><td class=\"sortable\">1,1478</td></tr><tr class=\"data-row oddrow\"><td class=\"row-name\">04-06-2017</td><td class=\"sortable\">1,1478</td></tr><tr class=\"data-row evenrow\"><td class=\"row-name\">03-06-2017</td><td class=\"sortable\">1,1470</td></tr><tr class=\"data-row oddrow\"><td class=\"row-name\">02-06-2017</td><td class=\"sortable\">1,1445</td></tr><tr class=\"data-row evenrow\"><td class=\"row-name\">01-06-2017</td><td class=\"sortable\">1,1452</td></tr><tr class=\"data-row oddrow\"><td class=\"row-name\">31-05-2017</td><td class=\"sortable\">1,1532</td></tr><tr class=\"data-row evenrow\"><td class=\"row-name\">30-05-2017</td><td class=\"sortable\">1,1490</td></tr><tr class=\"data-row oddrow\"><td class=\"row-name\">29-05-2017</td><td class=\"sortable\">1,1465</td></tr><tr class=\"data-row evenrow\"><td class=\"row-name\">28-05-2017</td><td class=\"sortable\">1,1465</td></tr><tr class=\"data-row oddrow\"><td class=\"row-name\">27-05-2017</td><td class=\"sortable\">1,1476</td></tr><tr class=\"data-row evenrow\"><td class=\"row-name\">26-05-2017</td><td class=\"sortable\">1,1550</td></tr><tr class=\"data-row oddrow\"><td class=\"row-name\">25-05-2017</td><td class=\"sortable\">1,1615</td></tr><tr class=\"data-row evenrow\"><td class=\"row-name\">24-05-2017</td><td class=\"sortable\">1,1544</td></tr><tr class=\"data-row oddrow\"><td class=\"row-name\">23-05-2017</td><td class=\"sortable\">1,1625</td></tr><tr class=\"data-row evenrow\"><td class=\"row-name\">22-05-2017</td><td class=\"sortable\">1,1767</td></tr></tbody><tfoot><tr class=\"column-headers\"><th class=\"row-name table-time-position sortable-position\">&nbsp;</th><th class=\"sortable\">Official</th></tr></tfoot></table>

unit:

EUR/GBP

pageId:

pageId

Zde máš code do POSTmana:

POST //api/marketdata/exportxls HTTP/1.1
Host: www.nordpoolspot.com
Content-Type: application/x-www-form-urlencoded
Cache-Control: no-cache
Postman-Token: 2d1d10d8-84f3-e7f0-5fec-5525d1816168

content=%3Ctable+id%3D%5C%22datatable%5C%22+class%3D%5C%22narrow%5C%22%3E%3Cthead%3E%3Ctr+class%3D%5C%22column-headers%5C%22%3E%3Cth+class%3D%5C%22row-name+table-time-position+sortable-position%5C%22%3E%26nbsp%3B%3C%2Fth%3E%3Cth+class%3D%5C%22draggable+sortable%5C%22%3EOfficial%3C%2Fth%3E%3C%2Ftr%3E%3C%2Fthead%3E%3Ctbody%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E21-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22future+sortable%5C%22%3E1%2C1389%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+oddrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E20-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1444%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E19-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1445%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+oddrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E18-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1445%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E17-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1434%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+oddrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E16-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1370%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E15-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1368%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+oddrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E14-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1347%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E13-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1328%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+oddrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E12-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1386%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E11-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1386%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+oddrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E10-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1386%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E09-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1523%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+oddrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E08-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1462%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E07-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1484%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+oddrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E06-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1478%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E05-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1478%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+oddrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E04-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1478%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E03-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1470%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+oddrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E02-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1445%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E01-06-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1452%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+oddrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E31-05-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1532%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E30-05-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1490%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+oddrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E29-05-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1465%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E28-05-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1465%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+oddrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E27-05-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1476%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E26-05-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1550%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+oddrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E25-05-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1615%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E24-05-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1544%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+oddrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E23-05-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1625%3C%2Ftd%3E%3C%2Ftr%3E%3Ctr+class%3D%5C%22data-row+evenrow%5C%22%3E%3Ctd+class%3D%5C%22row-name%5C%22%3E22-05-2017%3C%2Ftd%3E%3Ctd+class%3D%5C%22sortable%5C%22%3E1%2C1767%3C%2Ftd%3E%3C%2Ftr%3E%3C%2Ftbody%3E%3Ctfoot%3E%3Ctr+class%3D%5C%22column-headers%5C%22%3E%3Cth+class%3D%5C%22row-name+table-time-position+sortable-position%5C%22%3E%26nbsp%3B%3C%2Fth%3E%3Cth+class%3D%5C%22sortable%5C%22%3EOfficial%3C%2Fth%3E%3C%2Ftr%3E%3C%2Ftfoot%3E%3C%2Ftable%3E&unit=EUR%2FGBP&pageId=351

Z výše zmíněného vyplývá, že máš stejně smůlu :-)

pokud však netrváš na tom, že chceš EXCEl, tak stačí zavolat toto api:

http://www.nordpoolspot.com/api/marketdata/page/351?currency=,EUR,EUR,EUR&endDate=20-06-2017

kde parametry můžeš měnit.. nemají tam CORS, takže ti data vrátí:

{
    "data": {
        "Rows": [
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1444",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1444_True",
                        "DisplayNameOrDominatingDirection": "1,1444",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "20-06-2017",
                "StartTime": "2017-06-20T00:00:00",
                "EndTime": "2017-06-21T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1445",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1445_True",
                        "DisplayNameOrDominatingDirection": "1,1445",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "19-06-2017",
                "StartTime": "2017-06-19T00:00:00",
                "EndTime": "2017-06-20T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1445",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1445_True",
                        "DisplayNameOrDominatingDirection": "1,1445",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "18-06-2017",
                "StartTime": "2017-06-18T00:00:00",
                "EndTime": "2017-06-19T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1434",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1434_True",
                        "DisplayNameOrDominatingDirection": "1,1434",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "17-06-2017",
                "StartTime": "2017-06-17T00:00:00",
                "EndTime": "2017-06-18T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1370",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1370_True",
                        "DisplayNameOrDominatingDirection": "1,1370",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "16-06-2017",
                "StartTime": "2017-06-16T00:00:00",
                "EndTime": "2017-06-17T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1368",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1368_True",
                        "DisplayNameOrDominatingDirection": "1,1368",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "15-06-2017",
                "StartTime": "2017-06-15T00:00:00",
                "EndTime": "2017-06-16T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1347",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1347_True",
                        "DisplayNameOrDominatingDirection": "1,1347",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "14-06-2017",
                "StartTime": "2017-06-14T00:00:00",
                "EndTime": "2017-06-15T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1328",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1328_True",
                        "DisplayNameOrDominatingDirection": "1,1328",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "13-06-2017",
                "StartTime": "2017-06-13T00:00:00",
                "EndTime": "2017-06-14T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1386",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1386_True",
                        "DisplayNameOrDominatingDirection": "1,1386",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "12-06-2017",
                "StartTime": "2017-06-12T00:00:00",
                "EndTime": "2017-06-13T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1386",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1386_True",
                        "DisplayNameOrDominatingDirection": "1,1386",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "11-06-2017",
                "StartTime": "2017-06-11T00:00:00",
                "EndTime": "2017-06-12T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1386",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1386_True",
                        "DisplayNameOrDominatingDirection": "1,1386",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "10-06-2017",
                "StartTime": "2017-06-10T00:00:00",
                "EndTime": "2017-06-11T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1523",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1523_True",
                        "DisplayNameOrDominatingDirection": "1,1523",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "09-06-2017",
                "StartTime": "2017-06-09T00:00:00",
                "EndTime": "2017-06-10T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1462",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1462_True",
                        "DisplayNameOrDominatingDirection": "1,1462",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "08-06-2017",
                "StartTime": "2017-06-08T00:00:00",
                "EndTime": "2017-06-09T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1484",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1484_True",
                        "DisplayNameOrDominatingDirection": "1,1484",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "07-06-2017",
                "StartTime": "2017-06-07T00:00:00",
                "EndTime": "2017-06-08T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1478",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1478_True",
                        "DisplayNameOrDominatingDirection": "1,1478",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "06-06-2017",
                "StartTime": "2017-06-06T00:00:00",
                "EndTime": "2017-06-07T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1478",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1478_True",
                        "DisplayNameOrDominatingDirection": "1,1478",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "05-06-2017",
                "StartTime": "2017-06-05T00:00:00",
                "EndTime": "2017-06-06T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1478",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1478_True",
                        "DisplayNameOrDominatingDirection": "1,1478",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "04-06-2017",
                "StartTime": "2017-06-04T00:00:00",
                "EndTime": "2017-06-05T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1470",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1470_True",
                        "DisplayNameOrDominatingDirection": "1,1470",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "03-06-2017",
                "StartTime": "2017-06-03T00:00:00",
                "EndTime": "2017-06-04T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1445",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1445_True",
                        "DisplayNameOrDominatingDirection": "1,1445",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "02-06-2017",
                "StartTime": "2017-06-02T00:00:00",
                "EndTime": "2017-06-03T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1452",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1452_True",
                        "DisplayNameOrDominatingDirection": "1,1452",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "01-06-2017",
                "StartTime": "2017-06-01T00:00:00",
                "EndTime": "2017-06-02T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1532",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1532_True",
                        "DisplayNameOrDominatingDirection": "1,1532",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "31-05-2017",
                "StartTime": "2017-05-31T00:00:00",
                "EndTime": "2017-06-01T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1490",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1490_True",
                        "DisplayNameOrDominatingDirection": "1,1490",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "30-05-2017",
                "StartTime": "2017-05-30T00:00:00",
                "EndTime": "2017-05-31T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1465",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1465_True",
                        "DisplayNameOrDominatingDirection": "1,1465",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "29-05-2017",
                "StartTime": "2017-05-29T00:00:00",
                "EndTime": "2017-05-30T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1465",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1465_True",
                        "DisplayNameOrDominatingDirection": "1,1465",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "28-05-2017",
                "StartTime": "2017-05-28T00:00:00",
                "EndTime": "2017-05-29T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1476",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1476_True",
                        "DisplayNameOrDominatingDirection": "1,1476",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "27-05-2017",
                "StartTime": "2017-05-27T00:00:00",
                "EndTime": "2017-05-28T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1550",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1550_True",
                        "DisplayNameOrDominatingDirection": "1,1550",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "26-05-2017",
                "StartTime": "2017-05-26T00:00:00",
                "EndTime": "2017-05-27T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1615",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1615_True",
                        "DisplayNameOrDominatingDirection": "1,1615",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "25-05-2017",
                "StartTime": "2017-05-25T00:00:00",
                "EndTime": "2017-05-26T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1544",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1544_True",
                        "DisplayNameOrDominatingDirection": "1,1544",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "24-05-2017",
                "StartTime": "2017-05-24T00:00:00",
                "EndTime": "2017-05-25T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1625",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1625_True",
                        "DisplayNameOrDominatingDirection": "1,1625",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "23-05-2017",
                "StartTime": "2017-05-23T00:00:00",
                "EndTime": "2017-05-24T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1767",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1767_True",
                        "DisplayNameOrDominatingDirection": "1,1767",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "22-05-2017",
                "StartTime": "2017-05-22T00:00:00",
                "EndTime": "2017-05-23T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            },
            {
                "Columns": [
                    {
                        "Index": 0,
                        "Scale": 4,
                        "SecondaryValue": null,
                        "IsDominatingDirection": false,
                        "IsValid": true,
                        "IsAdditionalData": false,
                        "Behavior": 0,
                        "Name": "Official",
                        "Value": "1,1767",
                        "GroupHeader": "GBP/EUR",
                        "DisplayNegativeValueInBlue": false,
                        "CombinedName": "GBP/EUR Official",
                        "DateTimeForData": "0001-01-01T00:00:00",
                        "DisplayName": "1,1767_True",
                        "DisplayNameOrDominatingDirection": "1,1767",
                        "IsOfficial": true,
                        "UseDashDisplayStyle": false
                    }
                ],
                "Name": "21-05-2017",
                "StartTime": "2017-05-21T00:00:00",
                "EndTime": "2017-05-22T00:00:00",
                "DateTimeForData": "0001-01-01T00:00:00",
                "DayNumber": 0,
                "StartTimeDate": "0001-01-01T00:00:00",
                "IsExtraRow": false,
                "IsNtcRow": false,
                "EmptyValue": "",
                "Parent": null
            }
        ],
        "IsDivided": false,
        "SectionNames": null,
        "EntityIDs": [
            "9098fe30-88e9-11e3-8188-f3d05153b2ef"
        ],
        "DataStartdate": "2017-05-21T00:00:00",
        "DataEnddate": "2017-06-21T00:00:00",
        "AreaChanges": [],
        "Units": [
            "EUR/GBP"
        ],
        "LatestResultDate": "2017-06-21T00:00:00",
        "ContainsPreliminaryValues": false,
        "ContainsExchangeRates": false,
        "ExchangeRateOfficial": null,
        "ExchangeRatePreliminary": null,
        "ExchangeUnit": null,
        "DateUpdated": "2017-06-20T12:41:58.794",
        "CombinedHeadersEnabled": false,
        "DataType": 0,
        "TimeZoneInformation": 0
    },
    "cacheKey": "6A4FE85C67CE3B044EE81B90F62C2B0A",
    "conf": {
        "Id": "d04a2bdf-642b-4ab5-b26c-faa7b7a49889",
        "Name": null,
        "Published": "0001-01-01T00:00:00",
        "ShowGraph": false,
        "ResolutionPeriod": {
            "Id": "44196997-77b8-41cd-b955-42943a6e9c53",
            "Resolution": 1,
            "Unit": 0,
            "PeriodNumber": 31
        },
        "ResolutionPeriodY": {
            "Id": "1e1f6ee5-fe73-4626-a9e3-e7394d9f45b3",
            "Resolution": 1,
            "Unit": 2,
            "PeriodNumber": 1
        },
        "Entities": [
            {
                "ProductType": {
                    "Id": "1627c4f9-ddc6-4209-a889-32b9807994eb",
                    "Attributes": [
                        {
                            "Id": "100f3aff-3885-4865-85e4-e72f619c8a7e",
                            "Name": "Currency (From)",
                            "Role": "From",
                            "HasRoles": true,
                            "Values": [
                                "GBP"
                            ]
                        },
                        {
                            "Id": "a97a9473-68ba-4d0b-8a1b-93cb717b58f1",
                            "Name": "Currency (To)",
                            "Role": "To",
                            "HasRoles": true,
                            "Values": [
                                "EUR"
                            ]
                        },
                        {
                            "Id": "a5d5ed06-3fc5-44a5-b9b1-f36ae709fd12",
                            "Name": "Unit",
                            "Role": "",
                            "HasRoles": false,
                            "Values": [
                                "EUR/GBP"
                            ]
                        }
                    ],
                    "Name": "N2EX_EXC_OFF_D",
                    "DisplayName": "N2EX official currency exchange rate. Daily value.                                                                                                    "
                },
                "SecondaryProductType": {
                    "Id": "0cbb9b51-ecdf-448c-9082-f82351ac65f3",
                    "Attributes": null,
                    "Name": "NA",
                    "DisplayName": "-- Not applicable --"
                },
                "SecondaryProductBehavior": 0,
                "Id": "cb638514-2287-996c-db45-9742732ac806",
                "Name": "Official",
                "GroupHeader": "GBP/EUR",
                "DataUpdated": "0001-01-01T00:00:00",
                "Attributes": [
                    {
                        "Id": "100f3aff-3885-4865-85e4-e72f619c8a7e",
                        "Name": "Currency (From)",
                        "HasRoles": true,
                        "Role": "From",
                        "Value": "GBP"
                    },
                    {
                        "Id": "a97a9473-68ba-4d0b-8a1b-93cb717b58f1",
                        "Name": "Currency (To)",
                        "HasRoles": true,
                        "Role": "To",
                        "Value": "EUR"
                    },
                    {
                        "Id": "a5d5ed06-3fc5-44a5-b9b1-f36ae709fd12",
                        "Name": "Unit",
                        "HasRoles": false,
                        "Role": "",
                        "Value": "EUR/GBP"
                    }
                ],
                "Drillable": false,
                "DateRanges": [
                    {
                        "Id": "00000000-0000-0000-0000-000000000000",
                        "DateFrom": "2013-01-01T11:00:00Z",
                        "DateTo": "2099-12-12T11:00:00Z",
                        "IsNew": false
                    }
                ],
                "Index": 0,
                "IndexForColumn": 0,
                "MinMaxDisabled": false,
                "DisableNumberGroupSeparator": 0,
                "TimeserieID": null,
                "SecondaryTimeserieID": "00000000-0000-0000-0000-000000000000",
                "HasPreliminary": false,
                "TimeseriePreliminaryID": null,
                "Scale": 0,
                "SecondaryScale": 0,
                "DataType": 0,
                "SecondaryDataType": 0,
                "LastUpdate": "0001-01-01T00:00:00",
                "Unit": null,
                "IsDominatingDirection": false,
                "DisplayAsSeparatedColumn": false,
                "EnableInChart": false,
                "BlueNegativeValues": false
            }
        ],
        "TableType": 0,
        "ExtraRows": [],
        "Filters": [],
        "IsDrillDownEnabled": false,
        "DrillDownMode": 0,
        "IsMinValueEnabled": false,
        "IsMaxValueEnabled": false,
        "ValidYearsBack": 2,
        "IsNtcEnabled": false,
        "NtcProductType": {
            "Id": "7bf1b60f-f512-44fa-b920-df02acea15a0",
            "Attributes": null,
            "Name": "NA",
            "DisplayName": "-- Not applicable --"
        },
        "NtcHeader": "",
        "ShowTimelineGraph": 0,
        "ExchangeMode": 0,
        "IsPivotTable": 0,
        "IsCombinedHeadersEnabled": 0,
        "NtcFormat": 0,
        "DisplayHourAlsoInUKTime": false
    },
    "header": {
        "title": "Exchange rates",
        "description": "",
        "questionMarkInfo": ""
    },
    "endDate": "20-06-2017",
    "currency": "EUR",
    "pageId": 351
}

Editováno 20.6.2017 19:23

Akceptované řešení
+20 Zkušeností
+2,50 Kč

Nahoru Odpovědět

20.6.2017 19:20

Totalitní admini..

Jarmil Patocka

Člen

Jarmil Patocka:21.6.2017 15:01

Ahoj, dekuji moc za detailni vysvetleni. S timhle uz se da pracovat a je to v podstate presne to, co jsem hledal a potreboval. Z toho JSON uz si potrebna data budu schopen v Google Sheets vytahnout a dale dle potreb zpracovat.

Jeste jednou ti moc dekuji za tvuj cas a pomoc!

Nahoru Odpovědět

21.6.2017 15:01

Marian Benčat

Člen

Marian Benčat:25.6.2017 20:00

Označ to tedy jako vyřešený.

Nahoru Odpovědět

25.6.2017 20:00

Totalitní admini..

Honza Bittner

Tvůrce

Honza Bittner:25.6.2017 21:04

Označil jsem. :-)

Nahoru Odpovědět

25.6.2017 21:04

FIT ČVUT alumnus :-) Sleduj mě na https://twitter.com/tenhobi a ptej se na cokoli na https://github.com/tenhobi/ama.

Marian Benčat

Člen

Marian Benčat:26.6.2017 12:23

Ty jses nějakéj super kapo tady, co může říkat, co je řešení jo?

Nahoru Odpovědět

26.6.2017 12:23

Totalitní admini..

Honza Bittner

Tvůrce

Honza Bittner:26.6.2017 12:39

Jojo. Role supermoderátor.

Nahoru Odpovědět

26.6.2017 12:39

FIT ČVUT alumnus :-) Sleduj mě na https://twitter.com/tenhobi a ptej se na cokoli na https://github.com/tenhobi/ama.

Pavel Kříž

Člen

Pavel Kříž:30.7.2017 11:29

Kromě již zmíněných možností se dá použít služba Apifier, která je přímo na scrapování webu dělaná. Vše si můžeš upravit dle vlastních potřeb a vrátit data jako JSON nebo si je zapsat do Firebase atd., možností je spousta (ve smyslu použití Apifier).

Nahoru Odpovědět

30.7.2017 11:29

Děláme co je v našich silách, aby byly zdejší diskuze co nejkvalitnější. Proto do nich také mohou přispívat pouze registrovaní členové. Pro zapojení do diskuze se přihlas. Pokud ještě nemáš účet, zaregistruj se, je to zdarma.

Zobrazeno 16 zpráv z 16.

Nejčastěji vyhledáváné

Diskuze: Je mozne dostat data z teto stranky?