Thank you Gentlemen.
Peter : Streaming Stock Watch is a live streaming from Sharekhan (Broker) using the Excel RTD feature. This Streaming sheet is on Sheet 1, while we are working on Sheet 2 which is referenced (Data) from Sheet 1 by Vlookup. I downloaded the excel sheet, chose Buy and I...
Hi Peter, Attaching the snapshot of the sheet.
As you may see, I have the signals appearing in Column F (Buy or Sell), and the whole sheet refreshes every one minute interval. I need the trigger time in Column T, whenever there is a Buy or Sell, OR a Buy changing to Sell OR Sell changing to...
Thank you Grah - Guido for assisting me on this.
Can you clarify me which are the columns A2, B2 and G2 references. The reason I ask you this is, because, assuming that my signal Column where I get Buy/Sell is Column F, and needing the Time Stamp in Column G, there are only two columns that...
Thank you Peter. I checked the Sample sheet provided, but the time keeps changing every minute. Attaching a few images which I hope will help you understand what I mean.
Thanks for your kind response Peter.
As stated before, the command (last line) does produce the required result, but upon refresh the time stamp changes to the current time. For e.g. if the signal time was 9:15 hrs in the morning and if the current time is 14:30 hours, it displays 14:30 hrs and...
Dear Mr Chandoo and all gentlemen who are selflessly assisting others both in their learning and solving problems,
I have a stock trading work sheet, and there are two things I am trying to accomplish and stuggling a lot :
(1) In my trading sheet, I have Buy/Sell signal appearing in a certain...