Ditutup

Time stamp in a live streaming excel sheet (Stock Market)

Let us say I have Columns A to G in the excel sheet and the columns heading reading as below for stock market :

Symbol, Lot Size, Open, High, Low, LTP and the Signal Column (which gives Buy or Sell based on a strategy).

The last column which is the Signal Column (and which happens to be Column G) contains the “Buy”or “Sell” or Ëmpty when there is no signal. This column is dynamic, in the sense, as and when the data across A-F changes, I get new signals like Buy or Sell or Empty, depending upon the strategy.

My expectation is, as and when I get a Buy or a Sell or an empty in Column G (in the event of a Buy and Sell that has changed to an empty cell), I want to timestamp, let us say, Column H with the exact time the change happened (regardless of Buy or Sell or empty (post a buy or sell). And this timestamp should not change the time, unless any change happens in Column G. For e.g. a buy changing to a sell or a sell changing to a buy or a buy/sell changing to an empty cell.

The challenge I have with the available solution on the net is, my Excel sheet refreshes every 1 minute pulling data off the net, and as and when it does, the timestamp changes to the current time as against the time the signal came.

For e.g. a BUY or SELL that came at say 11:15 AM, should remain static unless the signal changes from a buy to sell or a sell to buy, but everytime my excel refreshes it updates with the current time in this column. What I am looking for is to understand what time a buy or sell came

Data Sheet snapshot : My excel sheet, where Column F contains live signals (Buy or Sell) and Column T should contain the Trigger time (timestamp) as and when there is a change in Column F

Jackpot : The sheet snapshot that was available on the internet, and which is precisely I want in my excel sheet.

Kemahiran: Excel

Lihat lagi: india stock market excel real time, time keeping calculation excel sheet, excel sheet time management, real time stock quotes excel 2017, import real time stock quotes in excel, excel clout stock quotes, get stock quotes in excel from google finance, indian stock market excel sheet, excel stock quotes 2018, real time stock quotes excel 2016, excel vba stock quotes, feed excel sheet stock price, stock market live data api asx, stock market feed spead sheet, excel sheet real time stock bloomberg, warehouse stock control excel sheet, read real time data currently opened excel sheet, stock control excel sheet, bombay stock exchange automatic update excel sheet, real time stock market simulation mysql

Tentang Majikan:
( 0 ulasan ) Pune, India

ID Projek: #18990298

7 pekerja bebas membida secara purata ₹7993 untuk pekerjaan ini

Farhinzaffar1

========>Your satisfaction is our career<======= i am Farhin. Data processing expert who knows the value of time, very hard working and always delivers the work on time .my motive is to make my employer happy without Lagi

₹600 INR dalam sehari
(8 Ulasan)
2.9
wmwale24

I am a proficient typist with great accuracy and speed level. I believe i can be a plus one to your company success if given the opportunity to work on this project.

₹1300 INR dalam sehari
(0 Ulasan)
0.0
anwastar

Hi, I understand your requirement very well and I will suggest you to have a bot instead of excel, that provides you messages to buy or sell depending on the trading strategy. please ping me we can discuss in detail. Lagi

₹27777 INR dalam 2 hari
(0 Ulasan)
0.0
₹1300 INR dalam sehari
(0 Ulasan)
0.0
gagankalra22

Hi, I am an expert with Excel, Analysis, Data Visualization and Data Management. I have worked in a reputed MNC, my 10 years of professional experience includes analyzing & interpreting large amounts of data; Lagi

₹1250 INR dalam sehari
(0 Ulasan)
0.0
mahios

Thank you so much for giving me this opportunity to give the proposal. I am Mahendran from india and 11+ years of experience in web application development using various tools and technologies. i am smart and hard wor Lagi

₹22222 INR dalam 15 hari
(0 Ulasan)
0.0
herryhs

Give me 15 minute to present my professional services, and then you free to decided what I can deliver to solve your needs. Simply visit my profile for further information.

₹1500 INR dalam sehari
(0 Ulasan)
0.0