-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 07, 2019 at 07:15 AM
-- Server version: 10.1.36-MariaDB
-- PHP Version: 5.6.38
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `shield_db`
--
-- --------------------------------------------------------
--
-- Table structure for table `apply_for_jobs`
--
CREATE TABLE `apply_for_jobs` (
`ID` int(30) NOT NULL,
`Apply_ID` varchar(200) NOT NULL,
`Name` varchar(200) NOT NULL,
`Contact` varchar(200) NOT NULL,
`Apply_For` varchar(200) NOT NULL,
`Resume_File` varchar(2000) NOT NULL,
`Date` varchar(200) NOT NULL,
`Time` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `apply_for_jobs`
--
INSERT INTO `apply_for_jobs` (`ID`, `Apply_ID`, `Name`, `Contact`, `Apply_For`, `Resume_File`, `Date`, `Time`) VALUES
(2, 'APLY-293', 'Nitikesh Rao', '6260880067', 'BA', '79-resume.pdf', '05-03-2019', '04:07:47PM');
-- --------------------------------------------------------
--
-- Table structure for table `blog`
--
CREATE TABLE `blog` (
`ID` int(30) NOT NULL,
`Blog_ID` varchar(200) NOT NULL,
`Title` varchar(200) NOT NULL,
`Primary_Image` varchar(200) NOT NULL,
`Short_Description` varchar(2000) NOT NULL,
`Blog_Content` text NOT NULL,
`Date` varchar(200) NOT NULL,
`Time` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `blog`
--
INSERT INTO `blog` (`ID`, `Blog_ID`, `Title`, `Primary_Image`, `Short_Description`, `Blog_Content`, `Date`, `Time`) VALUES
(3, 'BBLOG-545', 'STOCK MARKET OPENING UPDATE 30 JAN 2019', '3.jpg', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Ipsam inventore, itaque soluta. Aperiam', '
MORNING BELL:
\r\n\r\n
\r\n\r\n
SENSEX UPSIDE POINTS\r\n229@35821.50
\r\n\r\n
\r\n\r\n
NIFTY UPSIDE POINTS 50.05@\r\n10702.25.
\r\n\r\n
\r\n\r\n
Stocks In Ban:
\r\n\r\n
\r\n\r\n
\r\n\r\nADANIENT,
\r\n\r\n
\r\n\r\nADANIPOWER,
\r\n\r\n
\r\n\r\nJISLJALEQS,
\r\n\r\n
\r\n\r\nBANKINDIA,
\r\n\r\n
\r\n\r\nDHFL.
\r\n\r\n
\r\n\r\nAxis Bank Q3: Profit surges to\r\nRs 1,680.8 crore; NII rises 18.4 percent to Rs 5,603.6 crore.Gross NPA improves\r\nto 5.75 percent.
\r\n\r\nHCL Technologies Q3: Profit\r\nrises 2.8 percent to Rs 2,611 crore,revenue jumps 5.6 percent to Rs 15,699\r\ncrore.
\r\n\r\nBank of Baroda Q3: Profit jumps\r\nto Rs 471.2 crore; NII grows 7.9 percent to Rs 4,743.2 crore . Net NPA improves\r\nto 4.26 percent.
\r\n\r\nApar Industries Q3: Profit\r\nfalls 12.2 percent to Rs 35 crore; revenue increases 41.4 percent to Rs 2,119\r\ncrore.
\r\n\r\nGodrej Consumer Q3: Profit\r\nslips 1.5 percent to Rs 424 crore; revenue increases 3.5 percent to Rs 2,721.9\r\ncrore.
\r\n\r\nGranules India Q3: Profit jumps\r\n72.3 percent to Rs 60 crore; revenue surges 53.8 percent to Rs 631.8 crore.
\r\n\r\nRamco Industries Q3: Profit\r\ndips 8 percent to Rs 10.7 crore; revenue drops 0.1 percent to Rs 181.3 crore.
\r\n\r\nDCM Shriram Q3: Consolidated\r\nprofit rises 5.7 percent to Rs 225 crore; revenue increases 18.6 percent to Rs\r\n2,115.2 crore.
\r\n\r\nBajaj FinServ Q3: Consolidated\r\nprofit jumps 16.4 percent to Rs 851 crore; revenue rises 24 percent to Rs\r\n29,611 crore.
\r\n\r\nKEC International Q3: Profit\r\nrises 0.6 percent to Rs 112.4 crore; revenue increases 10.1 percent to Rs\r\n2,646.6 crore.
\r\n\r\nKingfa Science Q3: Profit falls\r\n35 percent to Rs 530.9 crore; revenue dips 12.7 percent to Rs 16,336.7 crore.
\r\n\r\n
\r\n\r\nFor More Detail Visit\r\n-https://www.capitalpride.in/
\r\n\r\nOr Call On -- 95848-46647
\r\n\r\n
', '30-01-2019', '10:00:41AM'),
(5, 'BBLOG-545', 'STOCK MARKET OPENING UPDATE 30 JAN 2019', '06.jpg', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Ipsam inventore, itaque soluta. Aperiam', 'MORNING BELL:
\r\n\r\n
\r\n\r\n
SENSEX UPSIDE POINTS\r\n229@35821.50
\r\n\r\n
\r\n\r\n
NIFTY UPSIDE POINTS 50.05@\r\n10702.25.
\r\n\r\n
\r\n\r\n
Stocks In Ban:
\r\n\r\n
\r\n\r\n
\r\n\r\nADANIENT,
\r\n\r\n
\r\n\r\nADANIPOWER,
\r\n\r\n
\r\n\r\nJISLJALEQS,
\r\n\r\n
\r\n\r\nBANKINDIA,
\r\n\r\n
\r\n\r\nDHFL.
\r\n\r\n
\r\n\r\nAxis Bank Q3: Profit surges to\r\nRs 1,680.8 crore; NII rises 18.4 percent to Rs 5,603.6 crore.Gross NPA improves\r\nto 5.75 percent.
\r\n\r\nHCL Technologies Q3: Profit\r\nrises 2.8 percent to Rs 2,611 crore,revenue jumps 5.6 percent to Rs 15,699\r\ncrore.
\r\n\r\nBank of Baroda Q3: Profit jumps\r\nto Rs 471.2 crore; NII grows 7.9 percent to Rs 4,743.2 crore . Net NPA improves\r\nto 4.26 percent.
\r\n\r\nApar Industries Q3: Profit\r\nfalls 12.2 percent to Rs 35 crore; revenue increases 41.4 percent to Rs 2,119\r\ncrore.
\r\n\r\nGodrej Consumer Q3: Profit\r\nslips 1.5 percent to Rs 424 crore; revenue increases 3.5 percent to Rs 2,721.9\r\ncrore.
\r\n\r\nGranules India Q3: Profit jumps\r\n72.3 percent to Rs 60 crore; revenue surges 53.8 percent to Rs 631.8 crore.
\r\n\r\nRamco Industries Q3: Profit\r\ndips 8 percent to Rs 10.7 crore; revenue drops 0.1 percent to Rs 181.3 crore.
\r\n\r\nDCM Shriram Q3: Consolidated\r\nprofit rises 5.7 percent to Rs 225 crore; revenue increases 18.6 percent to Rs\r\n2,115.2 crore.
\r\n\r\nBajaj FinServ Q3: Consolidated\r\nprofit jumps 16.4 percent to Rs 851 crore; revenue rises 24 percent to Rs\r\n29,611 crore.
\r\n\r\nKEC International Q3: Profit\r\nrises 0.6 percent to Rs 112.4 crore; revenue increases 10.1 percent to Rs\r\n2,646.6 crore.
\r\n\r\nKingfa Science Q3: Profit falls\r\n35 percent to Rs 530.9 crore; revenue dips 12.7 percent to Rs 16,336.7 crore.
\r\n\r\n
\r\n\r\nFor More Detail Visit\r\n-https://www.capitalpride.in/
\r\n\r\nOr Call On -- 95848-46647
\r\n\r\n
', '30-01-2019', '10:00:41AM'),
(6, 'BBLOG-545', 'STOCK MARKET OPENING UPDATE 30 JAN 2019', 'case-details-big.jpg', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Ipsam inventore, itaque soluta. Aperiam', 'MORNING BELL:
\r\n\r\n
\r\n\r\n
SENSEX UPSIDE POINTS\r\n229@35821.50
\r\n\r\n
\r\n\r\n
NIFTY UPSIDE POINTS 50.05@\r\n10702.25.
\r\n\r\n
\r\n\r\n
Stocks In Ban:
\r\n\r\n
\r\n\r\n
\r\n\r\nADANIENT,
\r\n\r\n
\r\n\r\nADANIPOWER,
\r\n\r\n
\r\n\r\nJISLJALEQS,
\r\n\r\n
\r\n\r\nBANKINDIA,
\r\n\r\n
\r\n\r\nDHFL.
\r\n\r\n
\r\n\r\nAxis Bank Q3: Profit surges to\r\nRs 1,680.8 crore; NII rises 18.4 percent to Rs 5,603.6 crore.Gross NPA improves\r\nto 5.75 percent.
\r\n\r\nHCL Technologies Q3: Profit\r\nrises 2.8 percent to Rs 2,611 crore,revenue jumps 5.6 percent to Rs 15,699\r\ncrore.
\r\n\r\nBank of Baroda Q3: Profit jumps\r\nto Rs 471.2 crore; NII grows 7.9 percent to Rs 4,743.2 crore . Net NPA improves\r\nto 4.26 percent.
\r\n\r\nApar Industries Q3: Profit\r\nfalls 12.2 percent to Rs 35 crore; revenue increases 41.4 percent to Rs 2,119\r\ncrore.
\r\n\r\nGodrej Consumer Q3: Profit\r\nslips 1.5 percent to Rs 424 crore; revenue increases 3.5 percent to Rs 2,721.9\r\ncrore.
\r\n\r\nGranules India Q3: Profit jumps\r\n72.3 percent to Rs 60 crore; revenue surges 53.8 percent to Rs 631.8 crore.
\r\n\r\nRamco Industries Q3: Profit\r\ndips 8 percent to Rs 10.7 crore; revenue drops 0.1 percent to Rs 181.3 crore.
\r\n\r\nDCM Shriram Q3: Consolidated\r\nprofit rises 5.7 percent to Rs 225 crore; revenue increases 18.6 percent to Rs\r\n2,115.2 crore.
\r\n\r\nBajaj FinServ Q3: Consolidated\r\nprofit jumps 16.4 percent to Rs 851 crore; revenue rises 24 percent to Rs\r\n29,611 crore.
\r\n\r\nKEC International Q3: Profit\r\nrises 0.6 percent to Rs 112.4 crore; revenue increases 10.1 percent to Rs\r\n2,646.6 crore.
\r\n\r\nKingfa Science Q3: Profit falls\r\n35 percent to Rs 530.9 crore; revenue dips 12.7 percent to Rs 16,336.7 crore.
\r\n\r\n
\r\n\r\nFor More Detail Visit\r\n-https://www.capitalpride.in/
\r\n\r\nOr Call On -- 95848-46647
\r\n\r\n
', '30-01-2019', '10:00:41AM');
-- --------------------------------------------------------
--
-- Table structure for table `business_setup`
--
CREATE TABLE `business_setup` (
`ID` int(30) NOT NULL,
`Company_Name` varchar(200) NOT NULL,
`Company_Title` varchar(2000) NOT NULL,
`Company_Logo` varchar(200) NOT NULL,
`Company_Favicon` varchar(200) NOT NULL,
`Web_URL` varchar(20000) NOT NULL,
`Date` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `business_setup`
--
INSERT INTO `business_setup` (`ID`, `Company_Name`, `Company_Title`, `Company_Logo`, `Company_Favicon`, `Web_URL`, `Date`) VALUES
(1, 'Shield Research', 'Shield Research | Best Advisory Company in Indore | Update Daily Market Tips', 'uploads/logo.png', 'uploads/logo.png', 'https://www.shieldresearch.in/', '05-03-2019');
-- --------------------------------------------------------
--
-- Table structure for table `careers_options`
--
CREATE TABLE `careers_options` (
`ID` int(30) NOT NULL,
`Career_ID` varchar(200) NOT NULL,
`Opening_For` varchar(200) NOT NULL,
`Designation` varchar(200) NOT NULL,
`Department` varchar(200) NOT NULL,
`Experience` varchar(200) NOT NULL,
`Compensation` varchar(200) NOT NULL,
`Comment` varchar(2000) NOT NULL,
`Status` int(30) NOT NULL,
`Date` varchar(200) NOT NULL,
`Time` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `careers_options`
--
INSERT INTO `careers_options` (`ID`, `Career_ID`, `Opening_For`, `Designation`, `Department`, `Experience`, `Compensation`, `Comment`, `Status`, `Date`, `Time`) VALUES
(2, 'VC-205', 'BA', 'BA', 'SALES', '1-YEAR', '2 LPA', 'BUSINESS DEVLOPMENT', 0, '05-03-2019', '03:36:21PM'),
(3, 'VC-260', 'Team Leader', 'Team Leader', 'SALES', '1-2 YEAR', '3 LPA', 'BACK OFFICE BUSINESS DEVELOPMENT CLIENT MAXIMISATION', 0, '05-03-2019', '03:36:56PM');
-- --------------------------------------------------------
--
-- Table structure for table `contact_query`
--
CREATE TABLE `contact_query` (
`ID` int(30) NOT NULL,
`Query_ID` varchar(200) NOT NULL,
`Name` varchar(200) NOT NULL,
`Email` varchar(200) NOT NULL,
`Contact` varchar(200) NOT NULL,
`Subject` varchar(200) NOT NULL,
`Message` varchar(20000) NOT NULL,
`Date` varchar(200) NOT NULL,
`Time` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `contact_query`
--
INSERT INTO `contact_query` (`ID`, `Query_ID`, `Name`, `Email`, `Contact`, `Subject`, `Message`, `Date`, `Time`) VALUES
(19, 'CQID-235', 'Nitikesh', 'jerry@gmail.com', '6565656565', 'None', 'hello please ignore, this is testing query...!', '06-03-2019', '12:39:51PM');
-- --------------------------------------------------------
--
-- Table structure for table `daily_report`
--
CREATE TABLE `daily_report` (
`ID` int(30) NOT NULL,
`Report_ID` varchar(200) NOT NULL,
`Report_Title` varchar(200) NOT NULL,
`Report_File` varchar(200) NOT NULL,
`Date` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `daily_report`
--
INSERT INTO `daily_report` (`ID`, `Report_ID`, `Report_Title`, `Report_File`, `Date`) VALUES
(2, 'DLR-382', 'test', '47-satish agriclinic.docx', '01-03-2019');
-- --------------------------------------------------------
--
-- Table structure for table `feedbcak`
--
CREATE TABLE `feedbcak` (
`ID` int(30) NOT NULL,
`Feedback_ID` varchar(200) NOT NULL,
`Customer` varchar(200) NOT NULL,
`Email` varchar(200) NOT NULL,
`Feedback` varchar(2000) NOT NULL,
`Date` varchar(200) NOT NULL,
`Time` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `feedbcak`
--
INSERT INTO `feedbcak` (`ID`, `Feedback_ID`, `Customer`, `Email`, `Feedback`, `Date`, `Time`) VALUES
(2, 'FDID-917', 'Amit Sharma', 'amit@gmail.com', 'As per my past experience with research companies the only company i see achieving more than 80% accuracy both daily and monthly,would like to continue with shield research for years.Bunch of thanks to shield research.', '06-03-2019', '12:50:53PM'),
(3, 'FDID-723', 'Poonam Vyas', 'poonam@gmail.com', 'I have been using stock future service from last two year with shield research. i would say that i gained my capital in this two years. overall I am happy. thank you shield research. you have good analyst team.', '06-03-2019', '12:51:26PM'),
(4, 'FDID-759', 'Parag Chourasiya', 'paragch45@gmail.com', 'Excellent company when it comes to research and followup,commitments they made at the time of subscription have fulfilled by their side.Thanks for being my financial advisory.', '06-03-2019', '12:51:55PM'),
(5, 'FDID-874', 'Anand Wadiya', 'anand859@gmail.com', 'I am doing trading in equity all segment and also in commodity. I am taking services from shield research. there is a person who assigned me really he provide me proper followup during the market.', '06-03-2019', '12:52:25PM');
-- --------------------------------------------------------
--
-- Table structure for table `free_trial`
--
CREATE TABLE `free_trial` (
`ID` int(30) NOT NULL,
`Client_Name` varchar(200) NOT NULL,
`Mobile_Number` varchar(200) NOT NULL,
`Email_Address` varchar(200) NOT NULL,
`Segment` varchar(200) NOT NULL,
`Date` varchar(200) NOT NULL,
`Time` varchar(200) NOT NULL,
`Status` int(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `free_trial`
--
INSERT INTO `free_trial` (`ID`, `Client_Name`, `Mobile_Number`, `Email_Address`, `Segment`, `Date`, `Time`, `Status`) VALUES
(737, 'Nitikesh', '8585858585', 'jerry@gmail.com', 'OPTIONS SUPER PACK', '06-03-2019', '12:42:51PM', 0),
(738, 'Aakash', '6969696969', 'aakash@gmail.com', 'HNI EQUITY PACK', '06-03-2019', '12:43:34PM', 0);
-- --------------------------------------------------------
--
-- Table structure for table `frontend_config`
--
CREATE TABLE `frontend_config` (
`ID` int(30) NOT NULL,
`Company_Title` varchar(200) NOT NULL,
`Company_Address` varchar(2000) NOT NULL,
`Company_Contact` varchar(200) NOT NULL,
`Company_Email` varchar(200) NOT NULL,
`Facebook` varchar(200) NOT NULL,
`Twitter` varchar(200) NOT NULL,
`Google` varchar(200) NOT NULL,
`Blog` varchar(200) NOT NULL,
`Date` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `frontend_config`
--
INSERT INTO `frontend_config` (`ID`, `Company_Title`, `Company_Address`, `Company_Contact`, `Company_Email`, `Facebook`, `Twitter`, `Google`, `Blog`, `Date`) VALUES
(1, 'Money Investment | Investment Adviser | Stock tips Provider', 'PU4 Indore Madhya Pradesh', '00000-00000', 'info@moneyinvestment.co', 'https://www.facebook.com/', 'https://twitter.com/login`', 'https://plus.google.com/discover', 'https://www.blogger.com/about/?r=1-null_user', '18-02-2019');
-- --------------------------------------------------------
--
-- Table structure for table `live_calls`
--
CREATE TABLE `live_calls` (
`ID` int(30) NOT NULL,
`Live_Call_ID` varchar(200) NOT NULL,
`Calls` varchar(2000) NOT NULL,
`Date` varchar(200) NOT NULL,
`Time` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `live_calls`
--
INSERT INTO `live_calls` (`ID`, `Live_Call_ID`, `Calls`, `Date`, `Time`) VALUES
(2, 'LC-490', 'SHIELD HNI LONG ADANI ENT ABOVE 129 TARGET 131 134 STOPLOSS 126.50 WWW.SHIELDRESEARCH.IN 9039355200', '05-03-2019', '03:19:13PM'),
(4, 'LC-153', 'SHIELD HNI UPDATE ADANIENT OUR 2ND TARGET 134 ACHIEVED BOOK FULL PROFIT WWW.SHIELDRESEARCH.IN 9039355200', '05-03-2019', '03:22:32PM'),
(5, 'LC-671', 'SHIELD PREMIUM SHORT MINDTREE FUTURES BELOW 1000 TARGET 996 990 STOPLOSS 1007 WWW.SHIELDRESEARCH.IN 9039355200', '05-03-2019', '03:22:40PM'),
(6, 'LC-533', 'SHIELD PREMIUM UPDATE MINDTREE FUTURES OUR 2ND TARGET 990 ACHIEVED BOOK FULL PROFIT WWW.SHIELDRESEARCH.IN 9039355200', '05-03-2019', '03:22:48PM'),
(7, 'LC-808', 'SHIELD PREMIUM LONG SRF 1750 PUT ABOVE 49.50 TARGET 55 62 STOPLOSS 43 WWW.SHIELDRESEARCH.IN 9039355200', '05-03-2019', '03:22:58PM'),
(8, 'LC-798', 'SHIELD PREMIUM UPDATE SRF 1750 PUT OUR 2ND TARGET 62 ACHIEVED BOOK FULL PROFIT WWW.SHIELDRESEARCH.IN 9039355200', '05-03-2019', '03:23:03PM'),
(9, 'LC-974', 'SHIELD LONG CRUDE OIL ABOVE 4500 TARGET 4525 4580 STOPLOSS 4460 WWW.SHIELDRESEARCH.IN 9039355200', '05-03-2019', '03:23:08PM'),
(10, 'LC-552', 'SHIELD UPDATE CRUDE OIL OUR 2ND TARGET 4580 ACHIEVED BOOK FULL PROFIT WWW.SHIELDRESEARCH.IN 9039355200', '05-03-2019', '03:23:13PM');
-- --------------------------------------------------------
--
-- Table structure for table `services`
--
CREATE TABLE `services` (
`ID` int(30) NOT NULL,
`Service_ID` varchar(200) NOT NULL,
`Service_Type` varchar(200) NOT NULL,
`Service_Title` varchar(200) NOT NULL,
`Idal_For` varchar(200) NOT NULL,
`Risk_Type` varchar(200) NOT NULL,
`Image` varchar(200) NOT NULL,
`Short_Description` varchar(2000) NOT NULL,
`Full_Description` varchar(20000) NOT NULL,
`Feature` varchar(2000) NOT NULL,
`Service_Sample` varchar(2000) NOT NULL,
`Follow_Ups` varchar(2000) NOT NULL,
`Note` varchar(2000) NOT NULL,
`Monthly_Price` varchar(200) NOT NULL,
`Quarterly_Price` varchar(200) NOT NULL,
`Halfyearly_Price` varchar(200) NOT NULL,
`Yearly_Price` varchar(200) NOT NULL,
`Date` varchar(200) NOT NULL,
`Time` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `services`
--
INSERT INTO `services` (`ID`, `Service_ID`, `Service_Type`, `Service_Title`, `Idal_For`, `Risk_Type`, `Image`, `Short_Description`, `Full_Description`, `Feature`, `Service_Sample`, `Follow_Ups`, `Note`, `Monthly_Price`, `Quarterly_Price`, `Halfyearly_Price`, `Yearly_Price`, `Date`, `Time`) VALUES
(10, 'SRVC-478', 'Intraday Services', 'Stock Cash IntraDay', 'IntraDay Traders', 'Medium to High', 'None', 'The Stock cash tips covers completely research based intraday calls with 3- 4 calls will be provided with two targets one stop', 'The Stock cash tips covers completely research based intraday calls with 3- 4 calls will be provided with two targets one stop loss. Calls are given through well-tested SMS the sector-wise or news based calls are also availed according to clients need. The calls accuracy can be judged in intraday basis. In this plan we expect to get return of up to 1% – 2% of invested amount on every call.', 'There will be up to 3-4 trading calls on daily basis,Combination of Intraday calls,Maximum 2 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,Investment Advice only in NSE trading shares,Important events like RBI Policy / Inflation / GDP / IIP updates', 'LONG BAJAJ ELEC CASH ABOVE 346 TARGET 349-355 STOPLOSS 342', 'BAJAJ ELEC CASH OUR 1ST TARGET 349 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', 'N.A.', '20000', '36000', '70000', '06-03-2019', '03:08:59PM'),
(11, 'SRVC-693', 'Intraday Services', 'Stock Future IntraDay', 'IntraDay Traders', 'Medium to High', 'None', 'In this service Shield provides intraday stock futures trading tips to traders. Our research team works extensively in identifying', 'In this service Shield provides intraday stock futures trading tips to traders. Our research team works extensively in identifying the movement in futures market on intraday basis and provides traders with intraday trading recommendations to enable them to earn maximum returns and at the same time reducing their risk. This package is best suited for traders who want to explore intraday movements in futures.', 'There will be up to 3-4 trading calls on daily basis,Combination of Intraday calls,Maximum 2 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,Investment Advice only in NSE trading shares,Important events like RBI Policy / Inflation / GDP / IIP updates', 'LONG UNION BANK FUTURES ABOVE 123 TARGET 124 125.50 STOPLOSS 121', 'UNION BANK FUTURES OUR 1ST TARGET 124 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', 'N.A.', '25000', '45000', '80000', '06-03-2019', '03:11:12PM'),
(12, 'SRVC-426', 'Intraday Services', 'Stock Option IntraDay', 'IntraDay Traders', 'Low to Medium', 'None', 'The Stock option tips covers completely research based intraday calls with 3- 4 calls will be provided with two targets one stop-', 'The Stock option tips covers completely research based intraday calls with 3- 4 calls will be provided with two targets one stop loss. Calls are given through well-tested SMS the sector-wise or news based calls are also availed according to clients need. The calls accuracy can be judged in intraday basis. In this plan we expect to get return of up to 1% – 2% of invested amount on every call.\r\n', 'There will be up to 3-4 trading calls on daily basis,Combination of Intraday calls,Maximum 2 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,Investment Advice only in NSE trading shares,Investment Advice only in NSE trading shares,Important events like RBI Policy/Inflation/ GDP/ IIP updates', 'LONG BAJAJ ELEC CASH ABOVE 346 TARGET 349-355 STOPLOSS 342', 'BAJAJ ELEC CASH OUR 1ST TARGET 349 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', 'N.A.', '20000', '36000', '70000', '06-03-2019', '03:18:19PM'),
(13, 'SRVC-593', 'Intraday Services', 'Index IntraDay', 'IntraDay Traders', 'Low to Medium', 'None', 'Index Intraday service is uniquely designed for Nifty traders trading in Index Future & Option. This pack consist calls of Nifty-', 'Index Intraday service is uniquely designed for Nifty traders trading in Index Future & Option. This pack consist calls of Nifty Future and Bank Nifty Future, Nifty option and Bank nifty option In Index pack we provide 1-2 calls on intraday basis with higher accuracy. Nifty Future a very volatile category of Indian stock market. No one knows where it will go in intraday basis.These calls help our clients make huge profit and minimize the risk.', 'There will be up to 1-2 trading calls on daily basis,Nifty & Bank Nifty overview with Resistances and Supports,Maximum 1 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,Important events like RBI Policy / Inflation / GDP / IIP updates,24X7 customer support', 'LONG NIFTY 10600 CALL ABOVE 240 TARGET 255 285 STOPLOSS 215,LONG NIFTY FUTURES ABOVE 10120 TARGET 10140 10170 STOPLOSS 10095', 'UPDATE NIFTY 10600 CALL OUR 2ND TARGET 285 ACHIEVED BOOK FULL PROFIT,UPDATE NIFTY FUTURES OUR 1ST TARGET 10140 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra.', 'N.A.', '17000', '32000', '60000', '06-03-2019', '03:26:54PM'),
(14, 'SRVC-503', 'Intraday Services', 'Commodity IntraDay', 'IntraDay Traders', 'Low to Medium', 'None', 'In this service we provide 3-4 intraday calls in MCX with a high level of accuracy. The calls are given in Precious Metals, Base-', 'n this service we provide 3-4 intraday calls in MCX with a high level of accuracy. The calls are given in Precious Metals, Base Metals & Energies. In this service we offer more and more calls in a day with least risk so that you can trade in multiple lots. Our team would ensure that all your investments give you the best returns hence increasing your commodities.', 'There will be up to 3-4 trading calls on daily basis,Combination of Intraday calls,Maximum 1 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,All Important Market related News & Information,24X7 customer support', 'LONG GOLD ABOVE 29150 TARGET 29210 29268 STOPLOSS 29070,SHIELD LONG NICKEL ABOVE 811.30 TARGET 816.30 822.30 STOPLOSS 804.30', 'UPDATE GOLD OUR 2ND TARGET 29268 ACHIEVED BOOK FULL PROFIT,UPDATE NICKEL OUR 2ND TARGET 822.30 ACHIEVED BOOK FULL PROFIT', 'Service Tax (As per government norms) will be extra', 'N.A.', '45000', '85000', '160000', '06-03-2019', '03:32:01PM'),
(15, 'SRVC-458', 'Intraday Services', 'Precious Metal IntraDay', 'IntraDay Traders', 'Low to Medium', 'None', 'In this service we provide 1-2 intraday calls in MCX Gold and Silver with high level-', 'In this service we provide 1-2 intraday calls in MCX Gold and Silver with high level of accuracy. The calls are given in Precious Metals. We can provide maximum benefit to traders extracting major movement in commodities in form of trading levels', 'There will be up to 1-2 trading calls on daily basis,Combination of Intraday calls,Maximum 1 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,All Important Market related News & Information,24X7 customer support', 'LONG GOLD ABOVE 29440 TARGET 29510 29580 STOPLOSS 29330', 'UPDATE GOLD 29510 OUR 1ST TARGET ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', 'N.A.', '20000', '36000', '70000', '06-03-2019', '03:33:48PM'),
(16, 'SRVC-100', 'Intraday Services', 'Energy IntraDay', 'IntraDay Traders', 'Low to Medium', 'None', 'In this service we provide 2-3 daily intraday calls in MCX with a high level of accuracy. The calls are given in Base Metals. Less', 'In this service we provide 2-3 daily intraday calls in MCX with a high level of accuracy. The calls are given in Base Metals. Less volatile traders who can not trade in precious metals. This service pack can help you to make wiser investments with a better working knowledge of the trade market.', 'There will be up to 1-2 trading calls on daily basis,Combination of Intraday calls,Maximum 1 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,All Important Market related News & Information,24X7 customer support', 'LONG CRUDE ABOVE 3615 TARGET 3635 3565 STOPLOSS 3585', 'UPDATE CRUDE OUR 1ST TARGET 3635 ACHIEVED BOOK PARTIAL PROFIT', 'Tax (As per government norms) will be extra', 'N.A.', '17000', '32000', '60000', '06-03-2019', '03:35:24PM'),
(18, 'SRVC-789', 'Intraday Services', 'Base Metal IntraDay', 'IntraDay Traders', 'Low to Medium', 'None', 'In this service we provide 2-3 daily intraday calls in MCX with a high level of accuracy. The calls are given in Base Metals. Less', 'In this service we provide 2-3 daily intraday calls in MCX with a high level of accuracy. The calls are given in Base Metals. Less volatile traders who can not trade in precious metals. This service pack can help you to make wiser investments with a better working knowledge of the trade market.', 'There will be up to 2-3 trading calls on daily basis,Combination of Intraday calls,Maximum 1 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,All Important Market related News & Information,24X7 customer support', 'NICKEL ABOVE 811.30 TARGET 816.30 822.30 STOPLOSS', 'UPDATE NICKEL OUR 2ND TARGET 822.30 ACHIEVED BOOK FULL PROFIT', 'Service Tax (As per government norms) will be extra', 'N.A.', '20000', '36000', '70000', '06-03-2019', '03:42:04PM'),
(19, 'SRVC-998', 'Intraday Services', 'BTST/STBT', 'IntraDay Traders', 'Medium to High', 'None', 'This service is for traders who do not want to invest substantial time and effort in doing intraday trading, but are very eager to', 'This service is for traders who do not want to invest substantial time and effort in doing intraday trading, but are very eager to generate returns from market by holding their positions overnight.For these type of traders the risk increases as they keep their position on hold for the next day. The highly experienced analysts at Shield Research put their heads to work full time, analyzing markets for overnight basis and also identify the scripts in which movement is expected tomorrow on buy side or sell side and provide the traders with trading tips on BTST/STBT basis so as to generate maximum returns overnight', 'We provide you around 10-12 calls in a month in Cash & Futures according to the segment,Combination of BTST & Short term positional calls,Maximum 1 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,Investment Advice only in NSE trading shares,Important events like RBI Policy/Inflation/GDP/ IIP updates,Fast and effective grievance redressal mechanism', 'BTST LONG RELIANCE FUTURES ABOVE 846 TARGET 858 866 STOPLOSS 835', 'BTST UPDATE RELIANCE FUTURES OUR 1ST TARGET 858 ACHIEVED BOOK FULL PROFIT', 'Service Tax (As per government norms) will be extra', 'N.A.', '35000', '95000', '170000', '06-03-2019', '03:49:40PM'),
(20, 'SRVC-391', 'Premium Services', 'Stock Cash Premium', 'IntraDay Traders', 'Medium to High', 'None', 'The Stock cash tips covers completely research based intraday calls with 1-2 calls (bigger targets) will be provided with two-', 'The Stock cash tips covers completely research based intraday calls with 1-2 calls (bigger targets) will be provided with two targets one stop loss. Calls are given through well-tested SMS, Sector-wise or News based calls are also availed according to clients need. The calls accuracy can be judged in intraday basis. In this plan we expect to get return of up to 2% – 3% of invested amount on every call.', 'There will be up to 1-2 trading calls on daily basis,Combination of Intraday calls,Maximum 1 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,Investment Advice only in NSE trading shares,Important events like RBI Policy/Inflation/GDP/IIP updates', 'PREMIUM LONG SUNPHARMA ABOVE 490 TARGET 496 503 STOPLOSS 483', 'PREMIUM UPDATE SUNPHARMA OUR 1ST TARGET 497ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '20000', '55000', '55000', 'N.A.', '06-03-2019', '04:02:03PM'),
(21, 'SRVC-194', 'Premium Services', 'Stock future Premium', 'IntraDay Traders', 'Medium to High', 'None', 'This service is designed for traders who want to get higher returns when compared with stock futures regular service. In this se-', 'This service is designed for traders who want to get higher returns when compared with stock futures regular service. In this service Shield analysts generate tips in futures scripts in which bigger movement is expected on intraday basis. For traders in this service, scripts are selected based on thorough technical and fundamental analysis, so as to get maximum returns out of intraday movement. For quick analysis of the product offering, please refer to the service features.', 'There will be up to 1-2 trading calls on daily basis,Important Global Market Updates,Maximum 1 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,Investment Advice only in NSE trading shares,Important events like RBI Policy/Inflation/GDP/IIP updates', 'PREMIUM LONG AXIS FUTURES ABOVE 426 TARGET 430 435 STOPLOSS 420', 'PREMIUM UPDATE AXIS BANK FUTURES OUR 1ST TARGET 430 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '25000', '70000', '100000', 'N.A.', '06-03-2019', '04:06:08PM'),
(22, 'SRVC-308', 'Premium Services', 'Stock Option Premium', 'IntraDay Traders', 'Low to Medium', 'None', '1-2 Intraday Derivative market call. Nifty trend, resistance & support.', '1-2 Intraday Derivative market call. Nifty trend, resistance & support . Proper follow ups though SMS and chat room. 24/7 Customer support. Accurate calls on consistent basis. For traders in this service, scripts are selected based on thorough technical and fundamental analysis, so as to get maximum returns out of intraday movement.', 'There will be up to 1-2 trading calls on daily basis,Combination of Intraday calls,Maximum 1 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,Investment Advice only in NSE trading shares,Important events like RBI Policy/Inflation/GDP/IIP updates', 'PREMIUM LONG ADANI PORTS 390 CALL ABOVE 16.30 TARGET 17.50-19 STOPLOSS 15', 'PREMIUM UPDATE ADANI PORTS 390 CALL OUR 2ND TARGET 19 ACHIEVED BOOK FULL PROFIT', 'Service Tax (As per government norms) will be extra', '20000', '55000', '55000', 'N.A.', '06-03-2019', '04:10:02PM'),
(23, 'SRVC-503', 'Premium Services', 'Bank Nifty Premium', 'IntraDay Traders', 'Medium ', 'None', 'This product is especially designed for traders trading only in index ( Bank Nifty). IDEAL FOR Intraday Traders as well as swing-', 'This product is especially designed for traders trading only in index ( Bank Nifty). IDEAL FOR Intraday Traders as well as swing traders with a holding of 1-2 days.', 'We provide 3-4 recommendations on weekly basis with proper entry & exit,Proper follow-ups and Market News Updates', 'LONG B IFTY FUTURES ABOVE 15050 TARGET 15150 15250 15350 STOPLOSS 14900', 'BNIFTY FUTURES OUR 1ST TARGET 15150 ACHIEVED BOOK PARTIAL PROFIT', 'Not Available', '15000', '42000', '70000', 'N.A.', '06-03-2019', '04:14:41PM'),
(24, 'SRVC-600', 'Premium Services', 'Commodity Premium', 'IntraDay Traders', 'Low to Medium', 'None', 'The premium package in MCX is for clients who want to work on intraday recommendations with bigger-', 'The premium package in MCX is for clients who want to work on intraday recommendations with bigger targets when compared with normal packages. In this service we provide 2-3 intraday calls in weekly basis in MCX with a high level of accuracy. The calls are given in Precious Metals, Base Metals & Energy. This product is best suited for traders who trade in all the commodities and trade in multiple lots.', 'There will be up to 2-3 intraday trading calls on Weekly basis,Combination of Intraday calls,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,A detailed Weekly Report Will be Provided,Important events like RBI Policy/Inflation/GDP/IIP updates,24/7 customer support,Domestic & World Market overview', 'PREMIUM LONG GOLD ABOVE 30380 TARGET 30480 30580 STOPLOSS 30280', 'PREMIUM UPDATE GOLD OUR 1ST TARGET 30480 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '35000', '80000', '150000', 'N.A.', '06-03-2019', '04:19:10PM'),
(25, 'SRVC-896', 'Premium Services', 'Precious Metal Premium', 'IntraDay Traders', 'Low to Medium', 'None', 'When we talk about the Bullion Premium, it is an obvious fact that here the targets are-', 'When we talk about the Bullion Premium, it is an obvious fact that here the targets are bigger in comparison to the normal packages .In this service we provide 8-10 intraday calls in Monthly basis in MCX GOLD AND SILVER with high level of accuracy. The calls will be in Precious Metals. You get sufficient time to enter in our calls and can maximize your profit with us.', 'There will be up to 8-10 intraday trading calls on Monthly basis,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,A detailed Weekly Report Will be Provided,Important events like RBI Policy/Inflation/GDP/IIP updates,24/7 customer support,Domestic & World Market overview', 'PREMIUM LONG GOLD ABOVE 30130 TARGET 30250 30380 STOPLOSS 30020', 'PREMIUM UPDATE GOLD OUR 1ST TARGET 30250 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '20000', '50000', '80000', 'N.A.', '06-03-2019', '04:23:52PM'),
(26, 'SRVC-637', 'Premium Services', 'Energy Premium', 'IntraDay Traders', 'Low to Medium', 'None', 'When we talk about the Energy Premium, it is an obvious fact that here the targets are bigger in comparison to the normal pa-', 'When we talk about the Energy Premium, it is an obvious fact that here the targets are bigger in comparison to the normal packages .In this service we provide 6-8 intraday calls in Monthly basis in crude oil and natural gas with high level of accuracy. The calls will be in energy. You get sufficient time to enter in our calls and can maximize your profit with us.', 'There will be up to 6-8 intarday trading calls on Monthly basis,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,A detailed Weekly Report Will be Provided,Important events like RBI Policy/Inflation/GDP/IIP updates,24/7 customer support,Domestic & World Market overview', 'PREMIUM LONG CRUDE ABOVE 3070 TARGET 3105 3140 STOPLOSS 3030', 'PREMIUM UPDATE CRUDE OUR 1ST TARGET 3105 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '20000', '50000', '80000', 'N.A.', '06-03-2019', '04:27:58PM'),
(27, 'SRVC-866', 'Premium Services', 'Base Metal Premium', 'IntraDay Traders', 'Low to Medium', 'None', 'When we talk about the Base Metal Premium, it is an obvious fact that here the targets are bigger in comparison to-', 'When we talk about the Base Metal Premium, it is an obvious fact that here the targets are bigger in comparison to the normal packages. In this service we provide 8-10 Monthly calls in MCX Copper, Nickel, Aluminium, and Zinc & Lead with high level of accuracy. The calls will be in Base Metals. You get sufficient time to enter in our calls and can maximize your profit with us.', 'There will be up to 8-10 intraday trading calls on Monthly basis,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,A detailed Weekly Report Will be Provided,Important events like RBI Policy/Inflation/GDP/IIP updates,24/7 customer support,Domestic & World Market overview', 'PREMIUM LONG LEAD ABOVE 163 TARGET 164 164.50 STOPLOSS 161.90', 'PREMIUM UPDATE LEAD OUR 1ST TARGET 164 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '20000', '50000', '80000', 'N.A.', '06-03-2019', '04:31:12PM'),
(28, 'SRVC-775', 'HNI Services', 'Stock Cash HNI', 'IntraDay Traders', 'Medium to High', 'None', 'The Stock cash tips covers completely research based intraday calls with 1-2 calls will be provided with two targets one-', 'The Stock cash tips covers completely research based intraday calls with 1-2 calls will be provided with two targets one stop loss. Calls are given through well-tested SMS the sector-wise or news based calls are also availed according to clients need. The calls accuracy can be judged in intraday basis. In this plan we expect to get return of up to 3% – 4% of invested amount on every call.', 'There will be up to 1-2 trading calls on daily basis,Combination of Intraday/BTST & Short term positional calls,Maximum 1 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,Investment Advice only in NSE trading shares,Important events like RBI Policy/Inflation/GDP/IIP updates,Fast and effective grievance redressal mechanism', 'HNI LONG BPCL ABOVE 533 TARGET 540 552 STOPLOSS 521', 'HNI UPDATE BPCL OUR 1ST TARGET 540 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '35000', '95000', '175000', 'N.A.', '06-03-2019', '04:36:03PM'),
(29, 'SRVC-369', 'HNI Services', 'Stock Future HNI', 'IntraDay Traders', 'Medium to High', 'None', 'This service is exclusively designed for HNI clients, who aim to reap higher returns when compared to normal services. We take al-', 'This service is exclusively designed for HNI clients, who aim to reap higher returns when compared to normal services. We take almost care while providing calls, profit booking, timely exit. These calls are generated after thorough study of stock market with the help of Technical Analysis and Economic Indicator.', 'There will be up to 1-2 trading calls on daily basis,Combination of Intraday/BTST & Short term positional calls,Maximum 1 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,Investment Advice only in NSE trading shares,Important events like RBI Policy/Inflation/GDP/IIP updates,Fast and effective grievance redressal mechanism', 'HNI ULTRATECH FUTURES ABOVE 4070 TARGET 4100 4150 STOPLOSS 4030', 'HNI UPDATE ULTRATECH FUTURES OUR 1ST TARGET 4100 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '40000', '105000', '180000', 'N.A.', '06-03-2019', '04:39:51PM'),
(30, 'SRVC-831', 'HNI Services', 'Stock Option HNI', 'IntraDay Trader', 'Medium to High', 'None', 'The Stock Option HNI tips covers completely research based intraday calls with 1-2 calls will be provided with two targets one st-', 'The Stock Option HNI tips covers completely research based intraday calls with 1-2 calls will be provided with two targets one stop loss. Calls are given through well-tested SMS the sector-wise or news based calls are also availed according to clients need. The calls accuracy can be judged in intraday basis.In this plan we expect to get return of up to 3% – 4% of invested amount on every call.', 'There will be up to 1-2 trading calls on daily basis,Combination of Intraday/BTST & Short term positional calls,Maximum 1 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,Investment Advice only in NSE trading shares,Important events like RBI Policy/Inflation/GDP/IIP updates,Fast and effective grievance redressal mechanism', 'HNI LONG MARUTI 9300 CALL ABOVE 100 TARGET 130 170 STOPLOSS 60', 'HNI UPDATE MARUTI CALL OUR 1ST TARGET 130 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '35000', '95000', '175000', 'N.A.', '06-03-2019', '05:14:11PM'),
(31, 'SRVC-295', 'HNI Services', 'MCX HNI', 'IntraDay Trader', 'Medium to High', 'None', 'In this service we provide calls in MCX segment with a high level of accuracy. The calls are given in Precious Metals, Base Me-', 'In this service we provide calls in MCX segment with a high level of accuracy. The calls are given in Precious Metals, Base Metals & Energy. In this services 10-12 trading calls will be provided. Calls can be intraday and positional basis .The analysts for HNI MCX possess expertise in capturing bigger movements in all commodities. The calls generated for traders go through a series of checks in terms of technical levels and are then delivered to them for trading.', 'There will be up to 10 - 12 trading calls on Monthly basis,Combination of Intraday & Short term positional calls,Maximum 1 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,Domestic & World Market overview,Fast and effective grievance redressal mechanism', 'HNI LONG CRUDE ABOVE 3600 TARGET 3650 3720 STOPLOSS 3560', 'HNI UPDATE CRUDE OUR 1ST TARGET 3650 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '75000', '190000', '350000', 'N.A.', '06-03-2019', '05:17:45PM'),
(32, 'SRVC-838', 'Platinum Services', 'Platinum MCX', 'IntraDay Trader', 'Medium to High', 'None', 'In this plan we will provide Investment Advice (calls / tips) for the MCX segment in Commodity Market. The Platinum-', 'In this plan we will provide Investment Advice (calls / tips) for the MCX segment in Commodity Market. The Platinum MCX Pack consists Precious Metals, Base Metal & Energy calls. In this services 5-6 calls will be provided in monthly basis .In this package target range from 5-7 %, all calls will be positionals with huge target.', 'There will be up to 5-6 trading calls on monthly basis,Positional calls with huge target,Maximum 1 positions can open at a time,Every call will have 1 targets and 1 proper SL,Follow up messages on every call,Domestic & World Market overview,Fast and effective grievance redressal mechanism', 'PLATINUM LONG GOLD ABOVE 29160 TARGET 29400 STOPLOSS 28957', 'PLATINUM UPDATE GOLD OUR TARGET 29400 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '170000', '450000', '750000', 'N.A.', '06-03-2019', '05:21:24PM'),
(33, 'SRVC-369', 'Platinum Services', 'Platinum Cash', 'IntraDay Trader', 'Medium to High', 'None', 'In this plan we will provide Investment Advice (calls / tips) for the Cash Market segment in Stock / Equity Market.', 'In this plan we will provide Investment Advice (calls / tips) for the Cash Market segment in Stock / Equity Market. This plan is a combination of Intraday, BTST & Positional Investment Advices, which will be provided via SMS on mobile. Platinum cash Pack consists of mostly intraday momentum calls which have potential to run up to 6% to 7% on intraday basis. These services are suitable for intraday as well as small term risky investors / traders, who want to trade on swing based momentum of stock. In this plan we expect to get return of up to 5% – 8% of invested amount on every call.', 'There will be up to 1-2 trading calls on daily basis,Maximum 1 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Important events like RBI Policy/Inflation/GDP/IIP updates,Fast and effective grievance redressal mechanism', 'PLATINUM LONG SBIN ABOVE 280 TARGET 287 STOPLOSS 272', 'PLATINUM UPDATE SBIN OUR TARGET 287 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '100000', '280000', '500000', 'N.A.', '06-03-2019', '05:24:37PM'),
(34, 'SRVC-525', 'Platinum Services', 'Platinum Future', 'IntraDay Trader', 'Medium to High', 'None', 'In this unique service we will provide single recommendation in Platinum Stock Future for those clients or-', 'In this unique service we will provide single recommendation in Platinum Stock Future for those clients or traders who want higher return against their investment with less numbers of highly accurate calls .This product is specifically designed to provide a single big target with calculated risk and reward by tracking volume , open interest , technical patterns along with fundamental studies.', 'There will be up to 8-10 trading calls on monthly basis,Combination of Intraday, BTST & Short term positional calls,Maximum 2 positions can open at a time,Every call will have 1 target and 1 proper Stoploss,Follow up messages on every call,Important events like RBI Policy/Inflation/GDP/IIP updates,Fast and effective grievance redressal mechanism', 'PLATINUM LONG BHARATFIN FUTURES ABOVE 935 TARGET 948 STOPLOSS 922', 'PLATINUM UPDATE BHARATFIN FUTURES OUR 1ST TARGET 948 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '120000', '320000', '580000', 'N.A.', '06-03-2019', '05:27:44PM'),
(35, 'SRVC-409', 'Platinum Services', 'Platinum Option', 'IntraDay Trader', 'Medium to High', 'None', 'In this plan we will provide Investment Advice (calls / tips) for the Future Market segment in Stock / Equity Market. ', 'In this plan we will provide Investment Advice (calls / tips) for the Future Market segment in Stock / Equity Market. This plan is a combination of Intraday, BTST & Positional Investment Advices, which will be provided via SMS on mobile. Platinum cash Pack consists of mostly intraday momentum calls which have potential to run up to 6% to 7% on intraday basis. These services are suitable for intraday as well as small term risky investors / traders, who want to trade on swing based momentum of stock. In this plan we expect to get return of up to 5% – 8% of invested amount on every call.', 'There will be up to 8-10 trading calls on monthly basis,Combination of Intraday/BTST & Short term positional calls,Maximum 2 positions can open at a time,Every call will have 1 target and 1 proper Stoploss,Follow up messages on every call,Important events like RBI Policy/Inflation/GDP/IIP updates,Fast and effective grievance redressal mechanism', 'PLATINUM LONG RELCAP 780 CALL ABOVE 22 TARGET 30 STOPLOSS 14', 'PLATINUM OPTION UPDATE MARUTI 780 CALL OUR 1ST TARGET 30 ACHIEVED BOOK PARTIAL', 'Service Tax (As per government norms) will be extra', '100000', '280000', '500000', 'N.A.', '06-03-2019', '05:30:57PM'),
(36, 'SRVC-167', 'Super Services', 'Super MCX', 'IntraDay Trader', 'Medium to High', 'None', 'This service is intraday as well as short term holding call, exclusively designed for the clients, who want to get good returns-', 'This service is intraday as well as short term holding call, exclusively designed for the clients, who want to get good returns apart from day trading. Our research team track indian market as well as world market before making call. We take almost care while providing calls, profit booking and timely exiting.', 'There will be up to 2-3 trading calls on Weekly basis,Combination of Intraday & Short term positional calls,Maximum 1 open positions at a time,Every call will have 1 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,Domestic & World Market overview,Fast and effective grievance redressal mechanism', 'SUPER ZINC ABOVE 207.75 TARGET 209.75 211 STOPLOSS 205', 'SUPER ZINC OUR 1ST TARGET 209.75 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '130000', '351000', '663000', 'N.A.', '06-03-2019', '05:34:10PM'),
(37, 'SRVC-448', 'Super Services', 'Super Cash', 'IntraDay Trader', 'Medium to High', 'None', 'In this plan we will provide Investment Advice (calls / tips) for the CASH Market segment in Stock / Equity Market. This plan is-', 'In this plan we will provide Investment Advice (calls / tips) for the CASH Market segment in Stock / Equity Market. This plan is a combination of Intraday, BTST & Positional Investment Advices, which will be provided via SMS on mobile. Super cash Pack consists of mostly intraday momentum calls which have potential to run up to 5% on intraday basis. These services are suitable for intraday as well as small term risky investors / traders, who want to trade on swing based momentum of stock. In this plan we expect to get return of up to 4% – 5% of invested amount on every call.', 'There will be up to 3-4 trading calls on weekly basis,Combination of Intraday/BTST & Short term positional calls,Maximum 2 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,Investment Advice only in NSE trading shares,Important events like RBI Policy/Inflation/GDP/IIP updates,Fast and effective grievance redressal mechanism', 'SUPER LONG SBIN ABOVE 280 TARGET 287 295 STOPLOSS 274', 'SUPER UPDATE SBIN OUR 1ST TARGET 287 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '60000', '170000', '310000', 'N.A.', '06-03-2019', '05:38:22PM'),
(38, 'SRVC-329', 'Super Services', 'Super Future', 'IntraDay Trader', 'Medium to High', 'None', 'In this plan we will provide highly accurate long target calls. The calls are generally high momentum scripts having good intraday', 'In this plan we will provide highly accurate long target calls. The calls are generally high momentum scripts having good intraday moment and higher volumes. We provide 12-14 calls in a month with proper follow up. These services are suitable for intraday as well as small term risky investors / traders, who want to trade on swing based momentum of stock.', 'There will be up to 3-4 trading calls on weekly basis,Combination of Intraday/BTST & Short term positional calls,Maximum 2 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW, Investment Advice only in NSE trading shares,Important events like RBI Policy/Inflation/GDP/IIP updates,Fast and effective grievance redressal mechanism', 'SUPERÂ LONG CGPOWER FUTURES ABOVE 87.50 TARGET 89.50 93 STOPLOSS 85Â', 'SUPER UPDATE CGPOWER FUTURES OUR 1ST TARGET 89.50 ACHIEVED BOOK PARTIAL PROFITÂ', 'Service Tax (As per government norms) will be extra', '65000', '180000', '320000', 'N.A.', '06-03-2019', '05:43:00PM'),
(39, 'SRVC-600', 'Super Services', 'Super Option', 'IntraDay Trader', 'Medium to High', 'None', 'In this plan we will provide Investment Advice (calls / tips) for the Future Market segment in Stock / Equity Market. This plan-', 'In this plan we will provide Investment Advice (calls / tips) for the Future Market segment in Stock / Equity Market. This plan is a combination of Intraday, BTST & Positional Investment Advices, which will be provided via SMS on mobile. Super option Pack consists of mostly intraday momentum calls which have potential to run up to 5% on intraday basis. These services are suitable for intraday as well as small term risky investors / traders, who want to trade on swing based momentum of stock. In this plan we expect to get return of up to 4% – 5% of invested amount on every call.', 'There will be up to 3-4 trading calls on weekly basis,Combination of Intraday/BTST & Short term positional,Maximum 2 open positions at a time,Every call will have 2 targets and 1 proper SL,Follow up messages on every call,Strategy will be Breakout- BUY ABOVE & SELL BELOW,Investment Advice only in NSE trading shares,Important events like RBI Policy/Inflation/GDP/IIP updates,Fast and effective grievance redressal mechanism', 'SUPER OPTION LONG MARUTI 7850 CALL ABOVE 155 TARGET 190 250 STOPLOSS 125', 'SUPER OPTION UPDATE MARUTI 7850 CALL OUR 1ST TARGET 190 ACHIEVED BOOK PARTIAL PROFIT', 'Service Tax (As per government norms) will be extra', '60000', '170000', '310000', 'N.A.', '06-03-2019', '05:48:28PM');
-- --------------------------------------------------------
--
-- Table structure for table `tracksheet`
--
CREATE TABLE `tracksheet` (
`ID` int(30) NOT NULL,
`Tracksheet_ID` varchar(200) NOT NULL,
`Title` varchar(200) NOT NULL,
`Tracksheet_File` varchar(2000) NOT NULL,
`Date` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tracksheet`
--
INSERT INTO `tracksheet` (`ID`, `Tracksheet_ID`, `Title`, `Tracksheet_File`, `Date`) VALUES
(3, 'TRK-650', 'CASH PACK', '52-CASH_PACK.xlsb', '08-01-2019'),
(4, 'TRK-554', 'FUTURE PACK', '92-FUT_PACK.xlsb', '08-01-2019'),
(5, 'TRK-592', 'OPTION PACK', '12-OPTION_PACK.xlsb', '08-01-2019'),
(6, 'TRK-717', 'CASH HNI', '98-CASH_HNI.xlsb', '08-01-2019'),
(7, 'TRK-751', 'FUTURE HNI', '84-FUTURE_HNI.xlsb', '08-01-2019'),
(8, 'TRK-209', 'OPTION HNI', '22-OPTION_HNI.xlsb', '08-01-2019'),
(9, 'TRK-158', 'CASH ATP', '44-CASH_ATP.xlsb', '08-01-2019'),
(10, 'TRK-787', 'FUTURE ATP', '89-FUTURE_ATP.xlsb', '08-01-2019'),
(11, 'TRK-685', 'OPTION ATP', '19-OPTION_ATP.xlsb', '08-01-2019');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`ID` int(30) NOT NULL,
`Security_Code` varchar(200) NOT NULL,
`Password` varchar(200) NOT NULL,
`User_Name` varchar(200) NOT NULL,
`Email` varchar(200) NOT NULL,
`Mobile_Number` varchar(200) NOT NULL,
`Balance` varchar(200) NOT NULL,
`Reg_Date` varchar(200) NOT NULL,
`Login_Status` varchar(200) NOT NULL,
`Status` int(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`ID`, `Security_Code`, `Password`, `User_Name`, `Email`, `Mobile_Number`, `Balance`, `Reg_Date`, `Login_Status`, `Status`) VALUES
(7, 'admin', 'admin', 'Shield Research', 'info@shieldresearch.in', '0000000000', '', '01-03-2019', 'Yes', 1);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `apply_for_jobs`
--
ALTER TABLE `apply_for_jobs`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `blog`
--
ALTER TABLE `blog`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `business_setup`
--
ALTER TABLE `business_setup`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `careers_options`
--
ALTER TABLE `careers_options`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `contact_query`
--
ALTER TABLE `contact_query`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `daily_report`
--
ALTER TABLE `daily_report`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `feedbcak`
--
ALTER TABLE `feedbcak`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `free_trial`
--
ALTER TABLE `free_trial`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `frontend_config`
--
ALTER TABLE `frontend_config`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `live_calls`
--
ALTER TABLE `live_calls`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `services`
--
ALTER TABLE `services`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `tracksheet`
--
ALTER TABLE `tracksheet`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`ID`),
ADD UNIQUE KEY `Email` (`Email`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `apply_for_jobs`
--
ALTER TABLE `apply_for_jobs`
MODIFY `ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `blog`
--
ALTER TABLE `blog`
MODIFY `ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `business_setup`
--
ALTER TABLE `business_setup`
MODIFY `ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `careers_options`
--
ALTER TABLE `careers_options`
MODIFY `ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `contact_query`
--
ALTER TABLE `contact_query`
MODIFY `ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `daily_report`
--
ALTER TABLE `daily_report`
MODIFY `ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `feedbcak`
--
ALTER TABLE `feedbcak`
MODIFY `ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `free_trial`
--
ALTER TABLE `free_trial`
MODIFY `ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=739;
--
-- AUTO_INCREMENT for table `frontend_config`
--
ALTER TABLE `frontend_config`
MODIFY `ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `live_calls`
--
ALTER TABLE `live_calls`
MODIFY `ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
MODIFY `ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;
--
-- AUTO_INCREMENT for table `tracksheet`
--
ALTER TABLE `tracksheet`
MODIFY `ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `ID` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;