Skip to main content

Posts

Scrip or Instrument Scanner App Diagram

|| श्री ||  Scanner App Diagram Long time back I have a plan to execute the scanner for finding the right stock utilizing OHLC information. I couldn't make sense of how I should process the information on various stocks as numerous stocks should sweep and discover a chance to exchange. I attempted various methodologies however somehow it couldn't function. While executing application I was confronting issue to telling if any open door is found. On the off chance that any open door discovered, at that point, my scanner simply tells UI and proceeds with the pending checking. Past I couldn't make it approximately coupled things yet I just went over where they utilizing arbiter design which helps me to break tight coupling. TradingDB - SQL database to store OHLC information. Data Access Layer - This layer is going to operate on DB using Dapper Library. As we have multiple entities like OHLC, Instruments, Watcher List, etc.  Data Services - Multip
Recent posts

Process Tick data to form One minute OHCLV Using SQL

|| श्री || Ticks to usable Time Frame Tick data is raw data that we need to process into the usable time frame. As I am using Zerodha ticker service it gives me data every tick. If we need to find an opportunity for trading, required to process the data to make it usable. Here I am saving data into mssql data base to store tick data. Below is my table structure.         You can use below script to use table. I am storing only current day data for Nifty50 stock and Nifty50Index. In my table End of the day will move this data into my historical table which store 1 min data. and truncate table. CREATE TABLE [dbo].[TickerData]( [TimeStamp] [datetime] NULL, [Open] [decimal](9, 2) NULL, [High] [decimal](9, 2) NULL, [Low] [decimal](9, 2) NULL, [Close] [decimal](9, 2) NULL, [Volume] [bigint] NULL, [InstrumentID] [bigint] NULL, [recordid] [bigint] IDENTITY(1,1) NOT NULL,  CONSTRAINT [PK_TickerData] PRIMARY KEY CLUSTERED ( [reco

How to fetch data using c# code and get last x day candle and Save DB

|| श्री ||  Zerodha Historical Data.      Here we are going to look into how to get historical data from Zerodha Kite API and manipulate it.     Historical data is important to make decision on the basis of support and resistance level . If we need to find these important levels then we may need data from previous days. We required to get data and manipulate it.  Prerequisite :- you required to subscribe for historical api.  Please have look at below image. Here my intention is when we login to system in background my application should check when my db last updated historical data and from there onward it start fetching data.  Historical Data Service In above code have check limit number of days we can request data is maximum 60 days.  So i tried such way if we request more than 60 days it will fetch record in 60 days batch.  Kite Api Response - Kite respond us data using List of Historical   object but it not having instrument i

How to Fetch Data Tick from Kite Connect API (Nifty50)

Get Nifty50 data from Zerodha API In Last blog we discuss about how to generate request token and now we are going to look how to get data from Kite Connect. Here we will subscribe Nifty50. We will go step by step If you have code from zerodha official  git hub we can start further if not you get it from my previous blog "Getting Started with Zerodha " 1) We need list of Nifty50 stock which below Can verify this list on NSE India site. Below is json which you can use you code. if need we can key value pair using it. var stocks= [{"instrumenttoken" :3861249, "tradingsymbol" : "ADANIPORTS"}, {"instrumenttoken" :60417, "tradingsymbol" : "ASIANPAINT"}, {"instrumenttoken" :1510401, "tradingsymbol" : "AXISBANK"}, {"instrumenttoken" :4267265, "tradingsymbol" : "BAJAJ-AUTO"}, {"instrumenttoken" :4268801, "tradingsymbol" : "BAJA

Getting Started with Zerodha API using C#

Getting Started with Zerodha API    In today's era, every thing is automated. now day's technology changing things rapidly. Many of us might have started imagination of automating the trades. This will be very interesting if you automate your trading action using your computer. If you planing to automate your trading, then here is some important information you may get.   Zerodha offering API for trading purpose, with the help of  API you can place order, cancel, modify. Zerodha Kite API V3 is very useful for automating trades. API is available in two forms one is Ticker which will give you tick data in market hours, another is historical API which will allow you to get old data.      To subscribe Kite API you must have Zerodha Dmat Account. Once you got your account with Zerodha login/Signup to  Kite Connect . You need to create app for API . Refer below image to create app. Fill the details. It will ask you to login your Kite Dmat account to link. So you can see this

How to generate the request_token for zerodha api using C#

Zerodha Kite Api How login Zerodha api using C# application? Hi Friends, recently i have started create application for zerodha api to make my own client for trading. Many of us have question how to login and trade using our custom C# application. I also face same problem i was looking solution for the same but  i was not able to fine exact way of doing it. I have gone through zerodha api document  According to them we need web view to make us to work this. Please follow be steps to get login token for API. Steps : 1) Creaet your login URL which is kite login + API key  eg.   var kiteURL="https://kite.trade/connect/login?v=3&api_key="    var apiKey="xpma3rmciorheitb"     2) Add web Browser to you web form set below properties             webBrowser1.AllowNavigation = true;             webBrowser1.ScriptErrorsSuppressed = true;             webBrowser1.Navigate(new Uri(kiteURL+apiKey)); 3) Now you need to register event "webBrowser1_