Пример #1
0
        private Dictionary <String, Int32> getMonedas()
        {
            Dictionary <String, Int32> monedas = new Dictionary <String, Int32>();

            Excel.Worksheet sh = Q1XLS.getSheet(CFG.getMasterSheet());

            if (sh == null)
            {
                return(null);
            }

            Boolean done = false;
            int     row  = 2;

            while (!done)
            {
                String m = sh.Cells[row, 1].Value();
                if (m == null)
                {
                    return(monedas);
                }
                if (m.Length > 2)
                {
                    monedas.Add(m, row);
                    row++;
                }
                else
                {
                    done = true;
                }
            }
            return(monedas);
        }
Пример #2
0
        private void threadTickers()
        {
            int row = 2;

            Excel.Worksheet sh = Q1XLS.getSheet(CFG.getMasterSheet());
            while (CFG.Loading)
            {
                decimal euro = web.getEuro();
                Dictionary <String, Ticker> tickers = web.getTickersMap(null);

                foreach (String m in monedas.Keys)
                {
                    row = monedas[m];
                    Ticker t = tickers[m];
                    sh.Cells[row, 2] = t.rank;
                    sh.Cells[row, 3] = Math.Round(t.price_usd / euro, 2);
                    sh.Cells[row, 4] = t.available_supply;
                    sh.Cells[row, 5] = t.percent_change_1h;
                    sh.Cells[row, 6] = t.percent_change_24h;
                    sh.Cells[row, 7] = t.percent_change_7d;
                    sh.Cells[row, 9] = DateTime.Now;
                }
                Thread.Sleep(CFG.Interval);
            }
            sh.Cells[row, 15] = "Acaba";
        }
Пример #3
0
        void wbActivate(Excel.Workbook Wb)
        {
            string shName = CFG.getMasterSheet();

            Excel.Worksheet sh = Q1XLS.getSheet(shName);
            if (sh != null)
            {
                // Ocultar la opcion de menu
            }
        }
Пример #4
0
        void wbOpen(Excel.Workbook Wb)
        {
            string shName = CFG.getMasterSheet();

            Excel.Worksheet sh = Q1XLS.getSheet(shName);
            if (sh != null)
            {
                Q1Threading t = Q1Threading.getInstance();
                t.startTickers();
                // Ocultar la opcion de menu
            }
        }