Bruttagente/PoloniexMarketDepth.gs

## PoloniexMarketDepth.gs
//This is a simple Google Script to fetch asks and bids for every BTC pair from Poloniex website and fill a Google Sheet.
//You had to insert your own Google Sheet address and sheet name.
//You can use the retrived data for creating personal charts and analysis.
//
//If you find this script useful, you can send me a tip on my bitcoin address: 17wzVMssHULq3LcJaESBkiB2cu2L9yCYn1
//


function marketDepth() {

  var ss = SpreadsheetApp.openById('your_Google_Sheet_Address_here');
  var data = ss.getSheetByName("Sheet_Name_here");

  var url = "https://poloniex.com/public?command=returnOrderBook&currencyPair=all&depth=200";
  var responseAPI = UrlFetchApp.fetch(url);
  var parcedData = JSON.parse(responseAPI.getContentText());


  //BTC_AMP
  var btc_amp_asks = [];
  btc_amp_asks.push(['askRate BTC_AMP', 'askAmount BTC_AMP']);

  for(var key in parcedData.BTC_AMP.asks)
    {
      btc_amp_asks.push(parcedData.BTC_AMP.asks[key]);
    }

  askRange = data.getRange(1, 1, btc_amp_asks.length, 2);
  askRange.setValues(btc_amp_asks);


  var btc_amp_bids = [];
  btc_amp_bids.push(['bidRate BTC_AMP', 'bidAmount BTC_AMP']);

  for(var key in parcedData.BTC_AMP.bids)
    {
      btc_amp_bids.push(parcedData.BTC_AMP.bids[key]);
    }

  askRange = data.getRange(1, 3, btc_amp_bids.length, 2);
  askRange.setValues(btc_amp_bids);


  //BTC_ARDR
  var btc_ardr_asks = [];
  btc_ardr_asks.push(['askRate BTC_ARDR', 'askAmount BTC_ARDR']);

  for(var key in parcedData.BTC_ARDR.asks)
    {
      btc_ardr_asks.push(parcedData.BTC_ARDR.asks[key]);
    }

  askRange = data.getRange(1, 5, btc_ardr_asks.length, 2);
  askRange.setValues(btc_ardr_asks);


  var btc_ardr_bids = [];
  btc_ardr_bids.push(['bidRate BTC_ARDR', 'bidAmount BTC_ARDR']);

  for(var key in parcedData.BTC_ARDR.bids)
    {
      btc_ardr_bids.push(parcedData.BTC_ARDR.bids[key]);
    }

  askRange = data.getRange(1, 7, btc_ardr_bids.length, 2);
  askRange.setValues(btc_ardr_bids);


  //BTC_BCN
  var btc_bcn_asks = [];
  btc_bcn_asks.push(['askRate BTC_BCN', 'askAmount BTC_BCN']);

  for(var key in parcedData.BTC_BCN.asks)
    {
      btc_bcn_asks.push(parcedData.BTC_BCN.asks[key]);
    }

  askRange = data.getRange(1, 9, btc_bcn_asks.length, 2);
  askRange.setValues(btc_bcn_asks);


  var btc_bcn_bids = [];
  btc_bcn_bids.push(['bidRate BTC_BCN', 'bidAmount BTC_BCN']);

  for(var key in parcedData.BTC_BCN.bids)
    {
      btc_bcn_bids.push(parcedData.BTC_BCN.bids[key]);
    }

  askRange = data.getRange(1, 11, btc_bcn_bids.length, 2);
  askRange.setValues(btc_bcn_bids);


  //BTC_BCY
  var btc_bcy_asks = [];
  btc_bcy_asks.push(['askRate BTC_BCY', 'askAmount BTC_BCY']);

  for(var key in parcedData.BTC_BCY.asks)
    {
      btc_bcy_asks.push(parcedData.BTC_BCY.asks[key]);
    }

  askRange = data.getRange(1, 13, btc_bcy_asks.length, 2);
  askRange.setValues(btc_bcy_asks);


  var btc_bcy_bids = [];
  btc_bcy_bids.push(['bidRate BTC_BCY', 'bidAmount BTC_BCY']);

  for(var key in parcedData.BTC_BCY.bids)
    {
      btc_bcy_bids.push(parcedData.BTC_BCY.bids[key]);
    }

  askRange = data.getRange(1, 15, btc_bcy_bids.length, 2);
  askRange.setValues(btc_bcy_bids);


  //BTC_BELA
  var btc_bela_asks = [];
  btc_bela_asks.push(['askRate BTC_BELA', 'askAmount BTC_BELA']);

  for(var key in parcedData.BTC_BELA.asks)
    {
      btc_bela_asks.push(parcedData.BTC_BELA.asks[key]);
    }

  askRange = data.getRange(1, 17, btc_bela_asks.length, 2);
  askRange.setValues(btc_bela_asks);


  var btc_bela_bids = [];
  btc_bela_bids.push(['bidRate BTC_BELA', 'bidAmount BTC_BELA']);

  for(var key in parcedData.BTC_BELA.bids)
    {
      btc_bela_bids.push(parcedData.BTC_BELA.bids[key]);
    }

  askRange = data.getRange(1, 19, btc_bela_bids.length, 2);
  askRange.setValues(btc_bela_bids);


  //BTC_BLK
  var btc_blk_asks = [];
  btc_blk_asks.push(['askRate BTC_BLK', 'askAmount BTC_BLK']);

  for(var key in parcedData.BTC_BLK.asks)
    {
      btc_blk_asks.push(parcedData.BTC_BLK.asks[key]);
    }

  askRange = data.getRange(1, 21, btc_blk_asks.length, 2);
  askRange.setValues(btc_blk_asks);


  var btc_blk_bids = [];
  btc_blk_bids.push(['bidRate BTC_BLK', 'bidAmount BTC_BLK']);

  for(var key in parcedData.BTC_BLK.bids)
    {
      btc_blk_bids.push(parcedData.BTC_BLK.bids[key]);
    }

  askRange = data.getRange(1, 23, btc_blk_bids.length, 2);
  askRange.setValues(btc_blk_bids);


  //BTC_BTCD
  var btc_btcd_asks = [];
  btc_btcd_asks.push(['askRate BTC_BTCD', 'askAmount BTC_BTCD']);

  for(var key in parcedData.BTC_BTCD.asks)
    {
      btc_btcd_asks.push(parcedData.BTC_BTCD.asks[key]);
    }

  askRange = data.getRange(1, 25, btc_btcd_asks.length, 2);
  askRange.setValues(btc_btcd_asks);


  var btc_btcd_bids = [];
  btc_btcd_bids.push(['bidRate BTC_BTCD', 'bidAmount BTC_BTCD']);

  for(var key in parcedData.BTC_BTCD.bids)
    {
      btc_btcd_bids.push(parcedData.BTC_BTCD.bids[key]);
    }

  askRange = data.getRange(1, 27, btc_btcd_bids.length, 2);
  askRange.setValues(btc_btcd_bids);


  //BTC_BTM
  var btc_btm_asks = [];
  btc_btm_asks.push(['askRate BTC_BTM', 'askAmount BTC_BTM']);

  for(var key in parcedData.BTC_BTM.asks)
    {
      btc_btm_asks.push(parcedData.BTC_BTM.asks[key]);
    }

  askRange = data.getRange(1, 29, btc_btm_asks.length, 2);
  askRange.setValues(btc_btm_asks);


  var btc_btm_bids = [];
  btc_btm_bids.push(['bidRate BTC_BTM', 'bidAmount BTC_BTM']);

  for(var key in parcedData.BTC_BTM.bids)
    {
      btc_btm_bids.push(parcedData.BTC_BTM.bids[key]);
    }

  askRange = data.getRange(1, 31, btc_btm_bids.length, 2);
  askRange.setValues(btc_btm_bids);


  //BTC_BTS
  var btc_bts_asks = [];
  btc_bts_asks.push(['askRate BTC_BTS', 'askAmount BTC_BTS']);

  for(var key in parcedData.BTC_BTS.asks)
    {
      btc_bts_asks.push(parcedData.BTC_BTS.asks[key]);
    }

  askRange = data.getRange(1, 33, btc_bts_asks.length, 2);
  askRange.setValues(btc_bts_asks);


  var btc_bts_bids = [];
  btc_bts_bids.push(['bidRate BTC_BTS', 'bidAmount BTC_BTS']);

  for(var key in parcedData.BTC_BTS.bids)
    {
      btc_bts_bids.push(parcedData.BTC_BTS.bids[key]);
    }

  askRange = data.getRange(1, 35, btc_bts_bids.length, 2);
  askRange.setValues(btc_bts_bids);


  //BTC_BURST
  var btc_burst_asks = [];
  btc_burst_asks.push(['askRate BTC_BURST', 'askAmount BTC_BURST']);

  for(var key in parcedData.BTC_BURST.asks)
    {
      btc_burst_asks.push(parcedData.BTC_BURST.asks[key]);
    }

  askRange = data.getRange(1, 37, btc_burst_asks.length, 2);
  askRange.setValues(btc_burst_asks);


  var btc_burst_bids = [];
  btc_burst_bids.push(['bidRate BTC_BURST', 'bidAmount BTC_BURST']);

  for(var key in parcedData.BTC_BURST.bids)
    {
      btc_burst_bids.push(parcedData.BTC_BURST.bids[key]);
    }

  askRange = data.getRange(1, 39, btc_burst_bids.length, 2);
  askRange.setValues(btc_burst_bids);


  //BTC_CLAM
  var btc_clam_asks = [];
  btc_clam_asks.push(['askRate BTC_CLAM', 'askAmount BTC_CLAM']);

  for(var key in parcedData.BTC_CLAM.asks)
    {
      btc_clam_asks.push(parcedData.BTC_CLAM.asks[key]);
    }

  askRange = data.getRange(1, 41, btc_clam_asks.length, 2);
  askRange.setValues(btc_clam_asks);


  var btc_clam_bids = [];
  btc_clam_bids.push(['bidRate BTC_CLAM', 'bidAmount BTC_CLAM']);

  for(var key in parcedData.BTC_CLAM.bids)
    {
      btc_clam_bids.push(parcedData.BTC_CLAM.bids[key]);
    }

  askRange = data.getRange(1, 43, btc_clam_bids.length, 2);
  askRange.setValues(btc_clam_bids);


  //BTC_DASH
  var btc_dash_asks = [];
  btc_dash_asks.push(['askRate BTC_DASH', 'askAmount BTC_DASH']);

  for(var key in parcedData.BTC_DASH.asks)
    {
      btc_dash_asks.push(parcedData.BTC_DASH.asks[key]);
    }

  askRange = data.getRange(1, 45, btc_dash_asks.length, 2);
  askRange.setValues(btc_dash_asks);


  var btc_dash_bids = [];
  btc_dash_bids.push(['bidRate BTC_DASH', 'bidAmount BTC_DASH']);

  for(var key in parcedData.BTC_DASH.bids)
    {
      btc_dash_bids.push(parcedData.BTC_DASH.bids[key]);
    }

  askRange = data.getRange(1, 47, btc_dash_bids.length, 2);
  askRange.setValues(btc_dash_bids);


  //BTC_DCR
  var btc_dcr_asks = [];
  btc_dcr_asks.push(['askRate BTC_DCR', 'askAmount BTC_DCR']);

  for(var key in parcedData.BTC_DCR.asks)
    {
      btc_dcr_asks.push(parcedData.BTC_DCR.asks[key]);
    }

  askRange = data.getRange(1, 49, btc_dcr_asks.length, 2);
  askRange.setValues(btc_dcr_asks);


  var btc_dcr_bids = [];
  btc_dcr_bids.push(['bidRate BTC_DCR', 'bidAmount BTC_DCR']);

  for(var key in parcedData.BTC_DCR.bids)
    {
      btc_dcr_bids.push(parcedData.BTC_DCR.bids[key]);
    }

  askRange = data.getRange(1, 51, btc_dcr_bids.length, 2);
  askRange.setValues(btc_dcr_bids);


  //BTC_DGB
  var btc_dgb_asks = [];
  btc_dgb_asks.push(['askRate BTC_DGB', 'askAmount BTC_DGB']);

  for(var key in parcedData.BTC_DGB.asks)
    {
      btc_dgb_asks.push(parcedData.BTC_DGB.asks[key]);
    }

  askRange = data.getRange(1, 53, btc_dgb_asks.length, 2);
  askRange.setValues(btc_dgb_asks);


  var btc_dgb_bids = [];
  btc_dgb_bids.push(['bidRate BTC_DGB', 'bidAmount BTC_DGB']);

  for(var key in parcedData.BTC_DGB.bids)
    {
      btc_dgb_bids.push(parcedData.BTC_DGB.bids[key]);
    }

  askRange = data.getRange(1, 55, btc_dgb_bids.length, 2);
  askRange.setValues(btc_dgb_bids);


  //BTC_DOGE
  var btc_doge_asks = [];
  btc_doge_asks.push(['askRate BTC_DOGE', 'askAmount BTC_DOGE']);

  for(var key in parcedData.BTC_DOGE.asks)
    {
      btc_doge_asks.push(parcedData.BTC_DOGE.asks[key]);
    }

  askRange = data.getRange(1, 57, btc_doge_asks.length, 2);
  askRange.setValues(btc_doge_asks);


  var btc_doge_bids = [];
  btc_doge_bids.push(['bidRate BTC_DOGE', 'bidAmount BTC_DOGE']);

  for(var key in parcedData.BTC_DOGE.bids)
    {
      btc_doge_bids.push(parcedData.BTC_DOGE.bids[key]);
    }

  askRange = data.getRange(1, 59, btc_doge_bids.length, 2);
  askRange.setValues(btc_doge_bids);


  //BTC_EMC2
  var btc_emc2_asks = [];
  btc_emc2_asks.push(['askRate BTC_EMC2', 'askAmount BTC_EMC2']);

  for(var key in parcedData.BTC_EMC2.asks)
    {
      btc_emc2_asks.push(parcedData.BTC_EMC2.asks[key]);
    }

  askRange = data.getRange(1, 61, btc_emc2_asks.length, 2);
  askRange.setValues(btc_emc2_asks);


  var btc_emc2_bids = [];
  btc_emc2_bids.push(['bidRate BTC_EMC2', 'bidAmount BTC_EMC2']);

  for(var key in parcedData.BTC_EMC2.bids)
    {
      btc_emc2_bids.push(parcedData.BTC_EMC2.bids[key]);
    }

  askRange = data.getRange(1, 63, btc_emc2_bids.length, 2);
  askRange.setValues(btc_emc2_bids);


  //BTC_ETC
  var btc_etc_asks = [];
  btc_etc_asks.push(['askRate BTC_ETC', 'askAmount BTC_ETC']);

  for(var key in parcedData.BTC_ETC.asks)
    {
      btc_etc_asks.push(parcedData.BTC_ETC.asks[key]);
    }

  askRange = data.getRange(1, 65, btc_etc_asks.length, 2);
  askRange.setValues(btc_etc_asks);


  var btc_etc_bids = [];
  btc_etc_bids.push(['bidRate BTC_ETC', 'bidAmount BTC_ETC']);

  for(var key in parcedData.BTC_ETC.bids)
    {
      btc_etc_bids.push(parcedData.BTC_ETC.bids[key]);
    }

  askRange = data.getRange(1, 67, btc_etc_bids.length, 2);
  askRange.setValues(btc_etc_bids);


  //BTC_ETH
  var btc_eth_asks = [];
  btc_eth_asks.push(['askRate BTC_ETH', 'askAmount BTC_ETH']);

  for(var key in parcedData.BTC_ETH.asks)
    {
      btc_eth_asks.push(parcedData.BTC_ETH.asks[key]);
    }

  askRange = data.getRange(1, 69, btc_eth_asks.length, 2);
  askRange.setValues(btc_eth_asks);


  var btc_eth_bids = [];
  btc_eth_bids.push(['bidRate BTC_ETH', 'bidAmount BTC_ETH']);

  for(var key in parcedData.BTC_ETH.bids)
    {
      btc_eth_bids.push(parcedData.BTC_ETH.bids[key]);
    }

  askRange = data.getRange(1, 71, btc_eth_bids.length, 2);
  askRange.setValues(btc_eth_bids);


  //BTC_EXP
  var btc_exp_asks = [];
  btc_exp_asks.push(['askRate BTC_EXP', 'askAmount BTC_EXP']);

  for(var key in parcedData.BTC_EXP.asks)
    {
      btc_exp_asks.push(parcedData.BTC_EXP.asks[key]);
    }

  askRange = data.getRange(1, 73, btc_exp_asks.length, 2);
  askRange.setValues(btc_exp_asks);


  var btc_exp_bids = [];
  btc_exp_bids.push(['bidRate BTC_EXP', 'bidAmount BTC_EXP']);

  for(var key in parcedData.BTC_EXP.bids)
    {
      btc_exp_bids.push(parcedData.BTC_EXP.bids[key]);
    }

  askRange = data.getRange(1, 75, btc_exp_bids.length, 2);
  askRange.setValues(btc_exp_bids);


  //BTC_FCT
  var btc_fct_asks = [];
  btc_fct_asks.push(['askRate BTC_FCT', 'askAmount BTC_FCT']);

  for(var key in parcedData.BTC_FCT.asks)
    {
      btc_fct_asks.push(parcedData.BTC_FCT.asks[key]);
    }

  askRange = data.getRange(1, 77, btc_fct_asks.length, 2);
  askRange.setValues(btc_fct_asks);


  var btc_fct_bids = [];
  btc_fct_bids.push(['bidRate BTC_FCT', 'bidAmount BTC_FCT']);

  for(var key in parcedData.BTC_FCT.bids)
    {
      btc_fct_bids.push(parcedData.BTC_FCT.bids[key]);
    }

  askRange = data.getRange(1, 79, btc_fct_bids.length, 2);
  askRange.setValues(btc_fct_bids);


  //BTC_FLDC
  var btc_fldc_asks = [];
  btc_fldc_asks.push(['askRate BTC_FLDC', 'askAmount BTC_FLDC']);

  for(var key in parcedData.BTC_FLDC.asks)
    {
      btc_fldc_asks.push(parcedData.BTC_FLDC.asks[key]);
    }

  askRange = data.getRange(1, 81, btc_fldc_asks.length, 2);
  askRange.setValues(btc_fldc_asks);


  var btc_fldc_bids = [];
  btc_fldc_bids.push(['bidRate BTC_FLDC', 'bidAmount BTC_FLDC']);

  for(var key in parcedData.BTC_FLDC.bids)
    {
      btc_fldc_bids.push(parcedData.BTC_FLDC.bids[key]);
    }

  askRange = data.getRange(1, 83, btc_fldc_bids.length, 2);
  askRange.setValues(btc_fldc_bids);


  //BTC_FLO
  var btc_flo_asks = [];
  btc_flo_asks.push(['askRate BTC_FLO', 'askAmount BTC_FLO']);

  for(var key in parcedData.BTC_FLO.asks)
    {
      btc_flo_asks.push(parcedData.BTC_FLO.asks[key]);
    }

  askRange = data.getRange(1, 85, btc_flo_asks.length, 2);
  askRange.setValues(btc_flo_asks);


  var btc_flo_bids = [];
  btc_flo_bids.push(['bidRate BTC_FLO', 'bidAmount BTC_FLO']);

  for(var key in parcedData.BTC_FLO.bids)
    {
      btc_flo_bids.push(parcedData.BTC_FLO.bids[key]);
    }

  askRange = data.getRange(1, 87, btc_flo_bids.length, 2);
  askRange.setValues(btc_flo_bids);


  //BTC_GAME
  var btc_game_asks = [];
  btc_game_asks.push(['askRate BTC_GAME', 'askAmount BTC_GAME']);

  for(var key in parcedData.BTC_GAME.asks)
    {
      btc_game_asks.push(parcedData.BTC_GAME.asks[key]);
    }

  askRange = data.getRange(1, 89, btc_game_asks.length, 2);
  askRange.setValues(btc_game_asks);


  var btc_game_bids = [];
  btc_game_bids.push(['bidRate BTC_GAME', 'bidAmount BTC_GAME']);

  for(var key in parcedData.BTC_GAME.bids)
    {
      btc_game_bids.push(parcedData.BTC_GAME.bids[key]);
    }

  askRange = data.getRange(1, 91, btc_game_bids.length, 2);
  askRange.setValues(btc_game_bids);


  //BTC_GNO
  var btc_gno_asks = [];
  btc_gno_asks.push(['askRate BTC_GNO', 'askAmount BTC_GNO']);

  for(var key in parcedData.BTC_GNO.asks)
    {
      btc_gno_asks.push(parcedData.BTC_GNO.asks[key]);
    }

  askRange = data.getRange(1, 93, btc_gno_asks.length, 2);
  askRange.setValues(btc_gno_asks);


  var btc_gno_bids = [];
  btc_gno_bids.push(['bidRate BTC_GNO', 'bidAmount BTC_GNO']);

  for(var key in parcedData.BTC_GNO.bids)
    {
      btc_gno_bids.push(parcedData.BTC_GNO.bids[key]);
    }

  askRange = data.getRange(1, 95, btc_gno_bids.length, 2);
  askRange.setValues(btc_gno_bids);


  //BTC_GNT
  var btc_gnt_asks = [];
  btc_gnt_asks.push(['askRate BTC_GNT', 'askAmount BTC_GNT']);

  for(var key in parcedData.BTC_GNT.asks)
    {
      btc_gnt_asks.push(parcedData.BTC_GNT.asks[key]);
    }

  askRange = data.getRange(1, 97, btc_gnt_asks.length, 2);
  askRange.setValues(btc_gnt_asks);


  var btc_gnt_bids = [];
  btc_gnt_bids.push(['bidRate BTC_GNT', 'bidAmount BTC_GNT']);

  for(var key in parcedData.BTC_GNT.bids)
    {
      btc_gnt_bids.push(parcedData.BTC_GNT.bids[key]);
    }

  askRange = data.getRange(1, 99, btc_gnt_bids.length, 2);
  askRange.setValues(btc_gnt_bids);


  //BTC_GRC
  var btc_grc_asks = [];
  btc_grc_asks.push(['askRate BTC_GRC', 'askAmount BTC_GRC']);

  for(var key in parcedData.BTC_GRC.asks)
    {
      btc_grc_asks.push(parcedData.BTC_GRC.asks[key]);
    }

  askRange = data.getRange(1, 101, btc_grc_asks.length, 2);
  askRange.setValues(btc_grc_asks);


  var btc_grc_bids = [];
  btc_grc_bids.push(['bidRate BTC_GRC', 'bidAmount BTC_GRC']);

  for(var key in parcedData.BTC_GRC.bids)
    {
      btc_grc_bids.push(parcedData.BTC_GRC.bids[key]);
    }

  askRange = data.getRange(1, 103, btc_grc_bids.length, 2);
  askRange.setValues(btc_grc_bids);


  //BTC_HUC
  var btc_huc_asks = [];
  btc_huc_asks.push(['askRate BTC_HUC', 'askAmount BTC_HUC']);

  for(var key in parcedData.BTC_HUC.asks)
    {
      btc_huc_asks.push(parcedData.BTC_HUC.asks[key]);
    }

  askRange = data.getRange(1, 105, btc_huc_asks.length, 2);
  askRange.setValues(btc_huc_asks);


  var btc_huc_bids = [];
  btc_huc_bids.push(['bidRate BTC_HUC', 'bidAmount BTC_HUC']);

  for(var key in parcedData.BTC_HUC.bids)
    {
      btc_huc_bids.push(parcedData.BTC_HUC.bids[key]);
    }

  askRange = data.getRange(1, 107, btc_huc_bids.length, 2);
  askRange.setValues(btc_huc_bids);


  //BTC_LBC
  var btc_lbc_asks = [];
  btc_lbc_asks.push(['askRate BTC_LBC', 'askAmount BTC_LBC']);

  for(var key in parcedData.BTC_LBC.asks)
    {
      btc_lbc_asks.push(parcedData.BTC_LBC.asks[key]);
    }

  askRange = data.getRange(1, 109, btc_lbc_asks.length, 2);
  askRange.setValues(btc_lbc_asks);


  var btc_lbc_bids = [];
  btc_lbc_bids.push(['bidRate BTC_LBC', 'bidAmount BTC_LBC']);

  for(var key in parcedData.BTC_LBC.bids)
    {
      btc_lbc_bids.push(parcedData.BTC_LBC.bids[key]);
    }

  askRange = data.getRange(1, 111, btc_lbc_bids.length, 2);
  askRange.setValues(btc_lbc_bids);


  //BTC_LSK
  var btc_lsk_asks = [];
  btc_lsk_asks.push(['askRate BTC_LSK', 'askAmount BTC_LSK']);

  for(var key in parcedData.BTC_LSK.asks)
    {
      btc_lsk_asks.push(parcedData.BTC_LSK.asks[key]);
    }

  askRange = data.getRange(1, 113, btc_lsk_asks.length, 2);
  askRange.setValues(btc_lsk_asks);


  var btc_lsk_bids = [];
  btc_lsk_bids.push(['bidRate BTC_LSK', 'bidAmount BTC_LSK']);

  for(var key in parcedData.BTC_LSK.bids)
    {
      btc_lsk_bids.push(parcedData.BTC_LSK.bids[key]);
    }

  askRange = data.getRange(1, 115, btc_lsk_bids.length, 2);
  askRange.setValues(btc_lsk_bids);


  //BTC_LTC
  var btc_ltc_asks = [];
  btc_ltc_asks.push(['askRate BTC_LTC', 'askAmount BTC_LTC']);

  for(var key in parcedData.BTC_LTC.asks)
    {
      btc_ltc_asks.push(parcedData.BTC_LTC.asks[key]);
    }

  askRange = data.getRange(1, 117, btc_ltc_asks.length, 2);
  askRange.setValues(btc_ltc_asks);


  var btc_ltc_bids = [];
  btc_ltc_bids.push(['bidRate BTC_LTC', 'bidAmount BTC_LTC']);

  for(var key in parcedData.BTC_LTC.bids)
    {
      btc_ltc_bids.push(parcedData.BTC_LTC.bids[key]);
    }

  askRange = data.getRange(1, 119, btc_ltc_bids.length, 2);
  askRange.setValues(btc_ltc_bids);


  //BTC_MAID
  var btc_maid_asks = [];
  btc_maid_asks.push(['askRate BTC_MAID', 'askAmount BTC_MAID']);

  for(var key in parcedData.BTC_MAID.asks)
    {
      btc_maid_asks.push(parcedData.BTC_MAID.asks[key]);
    }

  askRange = data.getRange(1, 121, btc_maid_asks.length, 2);
  askRange.setValues(btc_maid_asks);


  var btc_maid_bids = [];
  btc_maid_bids.push(['bidRate BTC_MAID', 'bidAmount BTC_MAID']);

  for(var key in parcedData.BTC_MAID.bids)
    {
      btc_maid_bids.push(parcedData.BTC_MAID.bids[key]);
    }

  askRange = data.getRange(1, 123, btc_maid_bids.length, 2);
  askRange.setValues(btc_maid_bids);


  //BTC_NAUT
  var btc_naut_asks = [];
  btc_naut_asks.push(['askRate BTC_NAUT', 'askAmount BTC_NAUT']);

  for(var key in parcedData.BTC_NAUT.asks)
    {
      btc_naut_asks.push(parcedData.BTC_NAUT.asks[key]);
    }

  askRange = data.getRange(1, 125, btc_naut_asks.length, 2);
  askRange.setValues(btc_naut_asks);


  var btc_naut_bids = [];
  btc_naut_bids.push(['bidRate BTC_NAUT', 'bidAmount BTC_NAUT']);

  for(var key in parcedData.BTC_NAUT.bids)
    {
      btc_naut_bids.push(parcedData.BTC_NAUT.bids[key]);
    }

  askRange = data.getRange(1, 127, btc_naut_bids.length, 2);
  askRange.setValues(btc_naut_bids);


  //BTC_NAV
  var btc_nav_asks = [];
  btc_nav_asks.push(['askRate BTC_NAV', 'askAmount BTC_NAV']);

  for(var key in parcedData.BTC_NAV.asks)
    {
      btc_nav_asks.push(parcedData.BTC_NAV.asks[key]);
    }

  askRange = data.getRange(1, 129, btc_nav_asks.length, 2);
  askRange.setValues(btc_nav_asks);


  var btc_nav_bids = [];
  btc_nav_bids.push(['bidRate BTC_NAV', 'bidAmount BTC_NAV']);

  for(var key in parcedData.BTC_NAV.bids)
    {
      btc_nav_bids.push(parcedData.BTC_NAV.bids[key]);
    }

  askRange = data.getRange(1, 131, btc_nav_bids.length, 2);
  askRange.setValues(btc_nav_bids);


  //BTC_NEOS
  var btc_neos_asks = [];
  btc_neos_asks.push(['askRate BTC_NEOS', 'askAmount BTC_NEOS']);

  for(var key in parcedData.BTC_NEOS.asks)
    {
      btc_neos_asks.push(parcedData.BTC_NEOS.asks[key]);
    }

  askRange = data.getRange(1, 133, btc_neos_asks.length, 2);
  askRange.setValues(btc_neos_asks);


  var btc_neos_bids = [];
  btc_neos_bids.push(['bidRate BTC_NEOS', 'bidAmount BTC_NEOS']);

  for(var key in parcedData.BTC_NEOS.bids)
    {
      btc_neos_bids.push(parcedData.BTC_NEOS.bids[key]);
    }

  askRange = data.getRange(1, 135, btc_neos_bids.length, 2);
  askRange.setValues(btc_neos_bids);


  //BTC_NMC
  var btc_nmc_asks = [];
  btc_nmc_asks.push(['askRate BTC_NMC', 'askAmount BTC_NMC']);

  for(var key in parcedData.BTC_NMC.asks)
    {
      btc_nmc_asks.push(parcedData.BTC_NMC.asks[key]);
    }

  askRange = data.getRange(1, 137, btc_nmc_asks.length, 2);
  askRange.setValues(btc_nmc_asks);


  var btc_nmc_bids = [];
  btc_nmc_bids.push(['bidRate BTC_NMC', 'bidAmount BTC_NMC']);

  for(var key in parcedData.BTC_NMC.bids)
    {
      btc_nmc_bids.push(parcedData.BTC_NMC.bids[key]);
    }

  askRange = data.getRange(1, 139, btc_nmc_bids.length, 2);
  askRange.setValues(btc_nmc_bids);


  //BTC_NOTE
  var btc_note_asks = [];
  btc_note_asks.push(['askRate BTC_NOTE', 'askAmount BTC_NOTE']);

  for(var key in parcedData.BTC_NOTE.asks)
    {
      btc_note_asks.push(parcedData.BTC_NOTE.asks[key]);
    }

  askRange = data.getRange(1, 141, btc_note_asks.length, 2);
  askRange.setValues(btc_note_asks);


  var btc_note_bids = [];
  btc_note_bids.push(['bidRate BTC_NOTE', 'bidAmount BTC_NOTE']);

  for(var key in parcedData.BTC_NOTE.bids)
    {
      btc_note_bids.push(parcedData.BTC_NOTE.bids[key]);
    }

  askRange = data.getRange(1, 143, btc_note_bids.length, 2);
  askRange.setValues(btc_note_bids);


  //BTC_NXC
  var btc_nxc_asks = [];
  btc_nxc_asks.push(['askRate BTC_NXC', 'askAmount BTC_NXC']);

  for(var key in parcedData.BTC_NXC.asks)
    {
      btc_nxc_asks.push(parcedData.BTC_NXC.asks[key]);
    }

  askRange = data.getRange(1, 145, btc_nxc_asks.length, 2);
  askRange.setValues(btc_nxc_asks);


  var btc_nxc_bids = [];
  btc_nxc_bids.push(['bidRate BTC_NXC', 'bidAmount BTC_NXC']);

  for(var key in parcedData.BTC_NXC.bids)
    {
      btc_nxc_bids.push(parcedData.BTC_NXC.bids[key]);
    }

  askRange = data.getRange(1, 147, btc_nxc_bids.length, 2);
  askRange.setValues(btc_nxc_bids);


  //BTC_NXT
  var btc_nxt_asks = [];
  btc_nxt_asks.push(['askRate BTC_NXT', 'askAmount BTC_NXT']);

  for(var key in parcedData.BTC_NXT.asks)
    {
      btc_nxt_asks.push(parcedData.BTC_NXT.asks[key]);
    }

  askRange = data.getRange(1, 149, btc_nxt_asks.length, 2);
  askRange.setValues(btc_nxt_asks);


  var btc_nxt_bids = [];
  btc_nxt_bids.push(['bidRate BTC_NXT', 'bidAmount BTC_NXT']);

  for(var key in parcedData.BTC_NXT.bids)
    {
      btc_nxt_bids.push(parcedData.BTC_NXT.bids[key]);
    }

  askRange = data.getRange(1, 151, btc_nxt_bids.length, 2);
  askRange.setValues(btc_nxt_bids);


  //BTC_OMNI
  var btc_omni_asks = [];
  btc_omni_asks.push(['askRate BTC_OMNI', 'askAmount BTC_OMNI']);

  for(var key in parcedData.BTC_OMNI.asks)
    {
      btc_omni_asks.push(parcedData.BTC_OMNI.asks[key]);
    }

  askRange = data.getRange(1, 153, btc_omni_asks.length, 2);
  askRange.setValues(btc_omni_asks);


  var btc_omni_bids = [];
  btc_omni_bids.push(['bidRate BTC_OMNI', 'bidAmount BTC_OMNI']);

  for(var key in parcedData.BTC_OMNI.bids)
    {
      btc_omni_bids.push(parcedData.BTC_OMNI.bids[key]);
    }

  askRange = data.getRange(1, 155, btc_omni_bids.length, 2);
  askRange.setValues(btc_omni_bids);


  //BTC_PASC
  var btc_pasc_asks = [];
  btc_pasc_asks.push(['askRate BTC_PASC', 'askAmount BTC_PASC']);

  for(var key in parcedData.BTC_PASC.asks)
    {
      btc_pasc_asks.push(parcedData.BTC_PASC.asks[key]);
    }

  askRange = data.getRange(1, 157, btc_pasc_asks.length, 2);
  askRange.setValues(btc_pasc_asks);


  var btc_pasc_bids = [];
  btc_pasc_bids.push(['bidRate BTC_PASC', 'bidAmount BTC_PASC']);

  for(var key in parcedData.BTC_PASC.bids)
    {
      btc_pasc_bids.push(parcedData.BTC_PASC.bids[key]);
    }

  askRange = data.getRange(1, 159, btc_pasc_bids.length, 2);
  askRange.setValues(btc_pasc_bids);


  //BTC_PINK
  var btc_pink_asks = [];
  btc_pink_asks.push(['askRate BTC_PINK', 'askAmount BTC_PINK']);

  for(var key in parcedData.BTC_PINK.asks)
    {
      btc_pink_asks.push(parcedData.BTC_PINK.asks[key]);
    }

  askRange = data.getRange(1, 161, btc_pink_asks.length, 2);
  askRange.setValues(btc_pink_asks);


  var btc_pink_bids = [];
  btc_pink_bids.push(['bidRate BTC_PINK', 'bidAmount BTC_PINK']);

  for(var key in parcedData.BTC_PINK.bids)
    {
      btc_pink_bids.push(parcedData.BTC_PINK.bids[key]);
    }

  askRange = data.getRange(1, 163, btc_pink_bids.length, 2);
  askRange.setValues(btc_pink_bids);


  //BTC_POT
  var btc_pot_asks = [];
  btc_pot_asks.push(['askRate BTC_POT', 'askAmount BTC_POT']);

  for(var key in parcedData.BTC_POT.asks)
    {
      btc_pot_asks.push(parcedData.BTC_POT.asks[key]);
    }

  askRange = data.getRange(1, 165, btc_pot_asks.length, 2);
  askRange.setValues(btc_pot_asks);


  var btc_pot_bids = [];
  btc_pot_bids.push(['bidRate BTC_POT', 'bidAmount BTC_POT']);

  for(var key in parcedData.BTC_POT.bids)
    {
      btc_pot_bids.push(parcedData.BTC_POT.bids[key]);
    }

  askRange = data.getRange(1, 167, btc_pot_bids.length, 2);
  askRange.setValues(btc_pot_bids);


  //BTC_PPC
  var btc_ppc_asks = [];
  btc_ppc_asks.push(['askRate BTC_PPC', 'askAmount BTC_PPC']);

  for(var key in parcedData.BTC_PPC.asks)
    {
      btc_ppc_asks.push(parcedData.BTC_PPC.asks[key]);
    }

  askRange = data.getRange(1, 169, btc_ppc_asks.length, 2);
  askRange.setValues(btc_ppc_asks);


  var btc_ppc_bids = [];
  btc_ppc_bids.push(['bidRate BTC_PPC', 'bidAmount BTC_PPC']);

  for(var key in parcedData.BTC_PPC.bids)
    {
      btc_ppc_bids.push(parcedData.BTC_PPC.bids[key]);
    }

  askRange = data.getRange(1, 171, btc_ppc_bids.length, 2);
  askRange.setValues(btc_ppc_bids);


  //BTC_RADS
  var btc_rads_asks = [];
  btc_rads_asks.push(['askRate BTC_RADS', 'askAmount BTC_RADS']);

  for(var key in parcedData.BTC_RADS.asks)
    {
      btc_rads_asks.push(parcedData.BTC_RADS.asks[key]);
    }

  askRange = data.getRange(1, 173, btc_rads_asks.length, 2);
  askRange.setValues(btc_rads_asks);


  var btc_rads_bids = [];
  btc_rads_bids.push(['bidRate BTC_RADS', 'bidAmount BTC_RADS']);

  for(var key in parcedData.BTC_RADS.bids)
    {
      btc_rads_bids.push(parcedData.BTC_RADS.bids[key]);
    }

  askRange = data.getRange(1, 175, btc_rads_bids.length, 2);
  askRange.setValues(btc_rads_bids);


  //BTC_REP
  var btc_rep_asks = [];
  btc_rep_asks.push(['askRate BTC_REP', 'askAmount BTC_REP']);

  for(var key in parcedData.BTC_REP.asks)
    {
      btc_rep_asks.push(parcedData.BTC_REP.asks[key]);
    }

  askRange = data.getRange(1, 177, btc_rep_asks.length, 2);
  askRange.setValues(btc_rep_asks);


  var btc_rep_bids = [];
  btc_rep_bids.push(['bidRate BTC_REP', 'bidAmount BTC_REP']);

  for(var key in parcedData.BTC_REP.bids)
    {
      btc_rep_bids.push(parcedData.BTC_REP.bids[key]);
    }

  askRange = data.getRange(1, 179, btc_rep_bids.length, 2);
  askRange.setValues(btc_rep_bids);


  //BTC_RIC
  var btc_ric_asks = [];
  btc_ric_asks.push(['askRate BTC_RIC', 'askAmount BTC_RIC']);

  for(var key in parcedData.BTC_RIC.asks)
    {
      btc_ric_asks.push(parcedData.BTC_RIC.asks[key]);
    }

  askRange = data.getRange(1, 181, btc_ric_asks.length, 2);
  askRange.setValues(btc_ric_asks);


  var btc_ric_bids = [];
  btc_ric_bids.push(['bidRate BTC_RIC', 'bidAmount BTC_RIC']);

  for(var key in parcedData.BTC_RIC.bids)
    {
      btc_ric_bids.push(parcedData.BTC_RIC.bids[key]);
    }

  askRange = data.getRange(1, 183, btc_ric_bids.length, 2);
  askRange.setValues(btc_ric_bids);


  //BTC_SBD
  var btc_sbd_asks = [];
  btc_sbd_asks.push(['askRate BTC_SBD', 'askAmount BTC_SBD']);

  for(var key in parcedData.BTC_SBD.asks)
    {
      btc_sbd_asks.push(parcedData.BTC_SBD.asks[key]);
    }

  askRange = data.getRange(1, 185, btc_sbd_asks.length, 2);
  askRange.setValues(btc_sbd_asks);


  var btc_sbd_bids = [];
  btc_sbd_bids.push(['bidRate BTC_SBD', 'bidAmount BTC_SBD']);

  for(var key in parcedData.BTC_SBD.bids)
    {
      btc_sbd_bids.push(parcedData.BTC_SBD.bids[key]);
    }

  askRange = data.getRange(1, 187, btc_sbd_bids.length, 2);
  askRange.setValues(btc_sbd_bids);


  //BTC_SC
  var btc_sc_asks = [];
  btc_sc_asks.push(['askRate BTC_SC', 'askAmount BTC_SC']);

  for(var key in parcedData.BTC_SC.asks)
    {
      btc_sc_asks.push(parcedData.BTC_SC.asks[key]);
    }

  askRange = data.getRange(1, 189, btc_sc_asks.length, 2);
  askRange.setValues(btc_sc_asks);


  var btc_sc_bids = [];
  btc_sc_bids.push(['bidRate BTC_SC', 'bidAmount BTC_SC']);

  for(var key in parcedData.BTC_SC.bids)
    {
      btc_sc_bids.push(parcedData.BTC_SC.bids[key]);
    }

  askRange = data.getRange(1, 191, btc_sc_bids.length, 2);
  askRange.setValues(btc_sc_bids);


  //BTC_SJCX
  var btc_sjcx_asks = [];
  btc_sjcx_asks.push(['askRate BTC_SJCX', 'askAmount BTC_SJCX']);

  for(var key in parcedData.BTC_SJCX.asks)
    {
      btc_sjcx_asks.push(parcedData.BTC_SJCX.asks[key]);
    }

  askRange = data.getRange(1, 193, btc_sjcx_asks.length, 2);
  askRange.setValues(btc_sjcx_asks);


  var btc_sjcx_bids = [];
  btc_sjcx_bids.push(['bidRate BTC_SJCX', 'bidAmount BTC_SJCX']);

  for(var key in parcedData.BTC_SJCX.bids)
    {
      btc_sjcx_bids.push(parcedData.BTC_SJCX.bids[key]);
    }

  askRange = data.getRange(1, 195, btc_sjcx_bids.length, 2);
  askRange.setValues(btc_sjcx_bids);


  //BTC_STEEM
  var btc_steem_asks = [];
  btc_steem_asks.push(['askRate BTC_STEEM', 'askAmount BTC_STEEM']);

  for(var key in parcedData.BTC_STEEM.asks)
    {
      btc_steem_asks.push(parcedData.BTC_STEEM.asks[key]);
    }

  askRange = data.getRange(1, 197, btc_steem_asks.length, 2);
  askRange.setValues(btc_steem_asks);


  var btc_steem_bids = [];
  btc_steem_bids.push(['bidRate BTC_STEEM', 'bidAmount BTC_STEEM']);

  for(var key in parcedData.BTC_STEEM.bids)
    {
      btc_steem_bids.push(parcedData.BTC_STEEM.bids[key]);
    }

  askRange = data.getRange(1, 199, btc_steem_bids.length, 2);
  askRange.setValues(btc_steem_bids);


  //BTC_STR
  var btc_str_asks = [];
  btc_str_asks.push(['askRate BTC_STR', 'askAmount BTC_STR']);

  for(var key in parcedData.BTC_STR.asks)
    {
      btc_str_asks.push(parcedData.BTC_STR.asks[key]);
    }

  askRange = data.getRange(1, 201, btc_str_asks.length, 2);
  askRange.setValues(btc_str_asks);


  var btc_str_bids = [];
  btc_str_bids.push(['bidRate BTC_STR', 'bidAmount BTC_STR']);

  for(var key in parcedData.BTC_STR.bids)
    {
      btc_str_bids.push(parcedData.BTC_STR.bids[key]);
    }

  askRange = data.getRange(1, 203, btc_str_bids.length, 2);
  askRange.setValues(btc_str_bids);


  //BTC_STRAT
  var btc_strat_asks = [];
  btc_strat_asks.push(['askRate BTC_STRAT', 'askAmount BTC_STRAT']);

  for(var key in parcedData.BTC_STRAT.asks)
    {
      btc_strat_asks.push(parcedData.BTC_STRAT.asks[key]);
    }

  askRange = data.getRange(1, 205, btc_strat_asks.length, 2);
  askRange.setValues(btc_strat_asks);


  var btc_strat_bids = [];
  btc_strat_bids.push(['bidRate BTC_STRAT', 'bidAmount BTC_STRAT']);

  for(var key in parcedData.BTC_STRAT.bids)
    {
      btc_strat_bids.push(parcedData.BTC_STRAT.bids[key]);
    }

  askRange = data.getRange(1, 207, btc_strat_bids.length, 2);
  askRange.setValues(btc_strat_bids);


  //BTC_SYS
  var btc_sys_asks = [];
  btc_sys_asks.push(['askRate BTC_SYS', 'askAmount BTC_SYS']);

  for(var key in parcedData.BTC_SYS.asks)
    {
      btc_sys_asks.push(parcedData.BTC_SYS.asks[key]);
    }

  askRange = data.getRange(1, 209, btc_sys_asks.length, 2);
  askRange.setValues(btc_sys_asks);


  var btc_sys_bids = [];
  btc_sys_bids.push(['bidRate BTC_SYS', 'bidAmount BTC_SYS']);

  for(var key in parcedData.BTC_SYS.bids)
    {
      btc_sys_bids.push(parcedData.BTC_SYS.bids[key]);
    }

  askRange = data.getRange(1, 211, btc_sys_bids.length, 2);
  askRange.setValues(btc_sys_bids);


  //BTC_VIA
  var btc_via_asks = [];
  btc_via_asks.push(['askRate BTC_VIA', 'askAmount BTC_VIA']);

  for(var key in parcedData.BTC_VIA.asks)
    {
      btc_via_asks.push(parcedData.BTC_VIA.asks[key]);
    }

  askRange = data.getRange(1, 213, btc_via_asks.length, 2);
  askRange.setValues(btc_via_asks);


  var btc_via_bids = [];
  btc_via_bids.push(['bidRate BTC_VIA', 'bidAmount BTC_VIA']);

  for(var key in parcedData.BTC_VIA.bids)
    {
      btc_via_bids.push(parcedData.BTC_VIA.bids[key]);
    }

  askRange = data.getRange(1, 215, btc_via_bids.length, 2);
  askRange.setValues(btc_via_bids);


  //BTC_VRC
  var btc_vrc_asks = [];
  btc_vrc_asks.push(['askRate BTC_VRC', 'askAmount BTC_VRC']);

  for(var key in parcedData.BTC_VRC.asks)
    {
      btc_vrc_asks.push(parcedData.BTC_VRC.asks[key]);
    }

  askRange = data.getRange(1, 217, btc_vrc_asks.length, 2);
  askRange.setValues(btc_vrc_asks);


  var btc_vrc_bids = [];
  btc_vrc_bids.push(['bidRate BTC_VRC', 'bidAmount BTC_VRC']);

  for(var key in parcedData.BTC_VRC.bids)
    {
      btc_vrc_bids.push(parcedData.BTC_VRC.bids[key]);
    }

  askRange = data.getRange(1, 219, btc_vrc_bids.length, 2);
  askRange.setValues(btc_vrc_bids);


  //BTC_VTC
  var btc_vtc_asks = [];
  btc_vtc_asks.push(['askRate BTC_VTC', 'askAmount BTC_VTC']);

  for(var key in parcedData.BTC_VTC.asks)
    {
      btc_vtc_asks.push(parcedData.BTC_VTC.asks[key]);
    }

  askRange = data.getRange(1, 221, btc_vtc_asks.length, 2);
  askRange.setValues(btc_vtc_asks);


  var btc_vtc_bids = [];
  btc_vtc_bids.push(['bidRate BTC_VTC', 'bidAmount BTC_VTC']);

  for(var key in parcedData.BTC_VTC.bids)
    {
      btc_vtc_bids.push(parcedData.BTC_VTC.bids[key]);
    }

  askRange = data.getRange(1, 223, btc_vtc_bids.length, 2);
  askRange.setValues(btc_vtc_bids);


  //BTC_XBC
  var btc_xbc_asks = [];
  btc_xbc_asks.push(['askRate BTC_XBC', 'askAmount BTC_XBC']);

  for(var key in parcedData.BTC_XBC.asks)
    {
      btc_xbc_asks.push(parcedData.BTC_XBC.asks[key]);
    }

  askRange = data.getRange(1, 225, btc_xbc_asks.length, 2);
  askRange.setValues(btc_xbc_asks);


  var btc_xbc_bids = [];
  btc_xbc_bids.push(['bidRate BTC_XBC', 'bidAmount BTC_XBC']);

  for(var key in parcedData.BTC_XBC.bids)
    {
      btc_xbc_bids.push(parcedData.BTC_XBC.bids[key]);
    }

  askRange = data.getRange(1, 227, btc_xbc_bids.length, 2);
  askRange.setValues(btc_xbc_bids);


  //BTC_XCP
  var btc_xcp_asks = [];
  btc_xcp_asks.push(['askRate BTC_XCP', 'askAmount BTC_XCP']);

  for(var key in parcedData.BTC_XCP.asks)
    {
      btc_xcp_asks.push(parcedData.BTC_XCP.asks[key]);
    }

  askRange = data.getRange(1, 229, btc_xcp_asks.length, 2);
  askRange.setValues(btc_xcp_asks);


  var btc_xcp_bids = [];
  btc_xcp_bids.push(['bidRate BTC_XCP', 'bidAmount BTC_XCP']);

  for(var key in parcedData.BTC_XCP.bids)
    {
      btc_xcp_bids.push(parcedData.BTC_XCP.bids[key]);
    }

  askRange = data.getRange(1, 231, btc_xcp_bids.length, 2);
  askRange.setValues(btc_xcp_bids);


  //BTC_XEM
  var btc_xem_asks = [];
  btc_xem_asks.push(['askRate BTC_XEM', 'askAmount BTC_XEM']);

  for(var key in parcedData.BTC_XEM.asks)
    {
      btc_xem_asks.push(parcedData.BTC_XEM.asks[key]);
    }

  askRange = data.getRange(1, 233, btc_xem_asks.length, 2);
  askRange.setValues(btc_xem_asks);


  var btc_xem_bids = [];
  btc_xem_bids.push(['bidRate BTC_XEM', 'bidAmount BTC_XEM']);

  for(var key in parcedData.BTC_XEM.bids)
    {
      btc_xem_bids.push(parcedData.BTC_XEM.bids[key]);
    }

  askRange = data.getRange(1, 235, btc_xem_bids.length, 2);
  askRange.setValues(btc_xem_bids);


  //BTC_XMR
  var btc_xmr_asks = [];
  btc_xmr_asks.push(['askRate BTC_XMR', 'askAmount BTC_XMR']);

  for(var key in parcedData.BTC_XMR.asks)
    {
      btc_xmr_asks.push(parcedData.BTC_XMR.asks[key]);
    }

  askRange = data.getRange(1, 237, btc_xmr_asks.length, 2);
  askRange.setValues(btc_xmr_asks);


  var btc_xmr_bids = [];
  btc_xmr_bids.push(['bidRate BTC_XMR', 'bidAmount BTC_XMR']);

  for(var key in parcedData.BTC_XMR.bids)
    {
      btc_xmr_bids.push(parcedData.BTC_XMR.bids[key]);
    }

  askRange = data.getRange(1, 239, btc_xmr_bids.length, 2);
  askRange.setValues(btc_xmr_bids);


  //BTC_XPM
  var btc_xpm_asks = [];
  btc_xpm_asks.push(['askRate BTC_XPM', 'askAmount BTC_XPM']);

  for(var key in parcedData.BTC_XPM.asks)
    {
      btc_xpm_asks.push(parcedData.BTC_XPM.asks[key]);
    }

  askRange = data.getRange(1, 241, btc_xpm_asks.length, 2);
  askRange.setValues(btc_xpm_asks);


  var btc_xpm_bids = [];
  btc_xpm_bids.push(['bidRate BTC_XPM', 'bidAmount BTC_XPM']);

  for(var key in parcedData.BTC_XPM.bids)
    {
      btc_xpm_bids.push(parcedData.BTC_XPM.bids[key]);
    }

  askRange = data.getRange(1, 243, btc_xpm_bids.length, 2);
  askRange.setValues(btc_xpm_bids);


  //BTC_XRP
  var btc_xrp_asks = [];
  btc_xrp_asks.push(['askRate BTC_XRP', 'askAmount BTC_XRP']);

  for(var key in parcedData.BTC_XRP.asks)
    {
      btc_xrp_asks.push(parcedData.BTC_XRP.asks[key]);
    }

  askRange = data.getRange(1, 245, btc_xrp_asks.length, 2);
  askRange.setValues(btc_xrp_asks);


  var btc_xrp_bids = [];
  btc_xrp_bids.push(['bidRate BTC_XRP', 'bidAmount BTC_XRP']);

  for(var key in parcedData.BTC_XRP.bids)
    {
      btc_xrp_bids.push(parcedData.BTC_XRP.bids[key]);
    }

  askRange = data.getRange(1, 247, btc_xrp_bids.length, 2);
  askRange.setValues(btc_xrp_bids);


  //BTC_XVC
  var btc_xvc_asks = [];
  btc_xvc_asks.push(['askRate BTC_XVC', 'askAmount BTC_XVC']);

  for(var key in parcedData.BTC_XVC.asks)
    {
      btc_xvc_asks.push(parcedData.BTC_XVC.asks[key]);
    }

  askRange = data.getRange(1, 249, btc_xvc_asks.length, 2);
  askRange.setValues(btc_xvc_asks);


  var btc_xvc_bids = [];
  btc_xvc_bids.push(['bidRate BTC_XVC', 'bidAmount BTC_XVC']);

  for(var key in parcedData.BTC_XVC.bids)
    {
      btc_xvc_bids.push(parcedData.BTC_XVC.bids[key]);
    }

  askRange = data.getRange(1, 251, btc_xvc_bids.length, 2);
  askRange.setValues(btc_xvc_bids);


  //BTC_ZEC
  var btc_zec_asks = [];
  btc_zec_asks.push(['askRate BTC_ZEC', 'askAmount BTC_ZEC']);

  for(var key in parcedData.BTC_ZEC.asks)
    {
      btc_zec_asks.push(parcedData.BTC_ZEC.asks[key]);
    }

  askRange = data.getRange(1, 253, btc_zec_asks.length, 2);
  askRange.setValues(btc_zec_asks);


  var btc_zec_bids = [];
  btc_zec_bids.push(['bidRate BTC_ZEC', 'bidAmount BTC_ZEC']);

  for(var key in parcedData.BTC_ZEC.bids)
    {
      btc_zec_bids.push(parcedData.BTC_ZEC.bids[key]);
    }

  askRange = data.getRange(1, 255, btc_zec_bids.length, 2);
  askRange.setValues(btc_zec_bids);


}