public void DatatableTestCases5()
        {
            _datatable        = CodedUITestHelpers.PremiumDatatable();
            _datatableColumns = CodedUITestHelpers.ActionTypeMtickerStatusDatatableColumns();
            var filters     = CodedUITestHelpers.filtersAllHistRdiff();
            var expectedUDF = "=QTABLE(\"ZACKS/HDM\",{\"action_type\",\"m_ticker\",\"status\"})";

            CodedUITestHelpers.CompleteStep1("ZFA");
            CodedUITestHelpers.CompleteStep2(_datatable, null);
            CodedUITestHelpers.CompleteStep3(_datatableColumns);
            CodedUITestHelpers.CompleteStep4(filters, false);
            CodedUITestHelpers.CompleteStep5(false);
            UIMap.AssertCorrectUDFSignature(expectedUDF);
            UIMap.ClickInsertButton();
        }
        public void DatatableTestCases6()
        {
            UIMap.OpenLoginPage();
            UIMap.LoginWithApiKey();
            _datatable        = CodedUITestHelpers.PremiumDatatable();
            _datatableColumns = CodedUITestHelpers.MtickerDatatableColumns();
            var filters     = CodedUITestHelpers.filtersAllHistRdiff();
            var expectedUDF = "=QTABLE(\"ZACKS/HDM\",\"m_ticker\")";

            CodedUITestHelpers.CompleteStep1("ZFA");
            CodedUITestHelpers.CompleteStep2(_datatable, null);
            CodedUITestHelpers.CompleteStep3(_datatableColumns);
            UIMap.ClickNextButton();
            CodedUITestHelpers.CompleteStep5(false);
            UIMap.AssertCorrectUDFSignature(expectedUDF);
            UIMap.ClickInsertButton();
            System.Threading.Thread.Sleep(3000);
            var actualCellHeader = _worksheet.Cells[1, 1].Value2;

            UIMap.AssertCorrectCellValue(actualCellHeader, "M_TICKER");
            var actualCellValue = _worksheet.Cells[2, 1].Value2;
            var numberOfAttempt = 0;

            while (numberOfAttempt <= 5)
            {
                if (actualCellValue != null)
                {
                    UIMap.AssertCorrectCellValue(actualCellHeader, "M_TICKER");
                    break;
                }

                else
                {
                    numberOfAttempt += 1;
                    System.Threading.Thread.Sleep(3000);
                }
            }
        }