Time stamp in a live streaming excel sheet (Stock Market)
₹600-1500 INR
Κλειστή
Αναρτήθηκε περίπου 5 χρόνια πριν
₹600-1500 INR
Πληρωμή κατά την παράδοση
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.
========>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 adding additional charges. If you are looking for data entry or search work, i am the right person for you. available 24/7.a trusted Freelancer.
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.
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.
Regards
Thari
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; creation of innovative, engaging & impactful presentations; managing team; formulating business plans; conducting market research and developing budgets.
In MS-Excel, I worked on projects like Data Visualization, Dynamic Dashboards, Macro, Complex Formula, Formatting, Excel to Powerpoint/Word conversion, PDF report creation, User Forms etc.
I believe my skills would be ideal for your project.
I would be happy to set up a convenient time to discuss the work.
Regards,
Gagan
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.