• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Updated cells copied with date time stamp to another workbook.

P

pucha

Member
Hi everybody,


I want to copy data(values only) from the cells which are updating regularly from a source into another workbook.


These are stock values. I already got help on this issue before on this forum "http://chandoo.org/forums/topic/auto-refresh-stock-value-copied-to-next-row" But that was through refresh method.


As here I am getting the updated data directly from the stock trading software without refresh into a excel file.


The data cells are -

Last_traded_price, Open, High, Low, Close, Volume


Please help me with a code to copy these data(row) into another workbook_sheet1 along with time stamp, only when if any one of the 6(six) cells get changed or trigger along with the trigger time in (hh:mm:ss) format into next row below in the new workbook sheet1.


Thankyou,


With Regards


Pucha
 
Hi Pucha,


Can you please upload a sample file with output as you want.


Refer : http://chandoo.org/forums/topic/posting-a-sample-workbook


Regards,

Deb
 
Hello Debraj


here is the sample xls


http://www.2shared.com/document/LqP7RCDk/sample.html


Thanks

pucha
 
Hi, pucha!


When you say "I want whenever any cell values in the above cells changes the whole row will be copied to a new (blank) workbook", do you mean that if you import/retrieve/get/copy two consecutive equal values for all cells in range you don't want it to be copied?


If volume is accumulated Ok, it's right, but if it's per operation then you'll be missing repeated equal operations.


Regards!
 
Hi SirJB7,


Due to my bad English I couldn't explain it correctly.

I have Six columns. Here values for "Open" & "Close" column will remain same as for the day trading. Only "Last Traded Price, High, Low & volume" will be changing.


I want when the "Last traded price" trigger/change, the whole row will be copy/paste to a new (blank) workbook (every time to next row) along with time (hh:mm:ss). I want to make a stock chart with volume with this live datas.


thanks

regards

pucha
 
Hi, pucha!


For what I understood you're going to "obtain" the data from another source, so there are 2 posibilities:

a) you're going to copy and paste the whole range D4:I4

b) you're going to copy and paste or input each cell manually


I assumed option a).


Give a look at these 2 files:

https://dl.dropbox.com/u/60558749/Updated%20cells%20copied%20with%20date%20%26%20time%20stamp%20to%20another%20workbook.%20-%20sample%20%28for%20pucha%20at%20chandoo.org%29.xlsm

https://dl.dropbox.com/u/60558749/Updated%20cells%20copied%20with%20date%20%26%20time%20stamp%20to%20another%20workbook.%20-%20sample%20%28for%20pucha%20at%20chandoo.org%29.xlsx


If it were option b) or any other else, please advise.


Regards!
 
Yes SirJB7,


For what I understood you're going to "obtain" the data from another source, so there are 2 posibilities:

a) you're going to copy and paste the whole range D4:I4


-----------

I want the part "a" only. It will copy automatically these range every time when any one or both the cell -"last traded price" & "Volume" changes. There will be no copy/paste if there is no change in values.


thanks

pucha
 
Hi, pucha!

Ok, but what I intended to precise is how and when were you going to update the D4:I4 in your uploaded workbook. Specifically the method, manual, automatic, the whole range, cell by cell...

Regards!
 
Hi SirJB7


Well, from my trading software there is live data export system. The stock live data s are directly open in a excel file.


From these excel file I want to collect the above cells range to another workbook to plot a live stock chart.


Hope you got it. As there is no last traded time column so I want a extra column of data paste time along with the range copy/paste.


Thanks

pucha
 
Hello SirBJ7,


I am using excel 2003 version. Will please upload in the same version & tell the procedure please.


Thanks

Regards

pucha
 
Hello SirBJ7,


I am using excel 2003 version. Will you please upload in the same version & tell me the procedure please.


Thanks

Regards

pucha
 
Hi, pucha!


Here's the unchecked 2003 version:

https://dl.dropbox.com/u/60558749/Updated%20cells%20copied%20with%20date%20%26%20time%20stamp%20to%20another%20workbook.%20-%20sample%20%28for%20pucha%20at%20chandoo.org%29%20master.xls

https://dl.dropbox.com/u/60558749/Updated%20cells%20copied%20with%20date%20%26%20time%20stamp%20to%20another%20workbook.%20-%20sample%20%28for%20pucha%20at%20chandoo.org%29.xls


First file (master) is the one you uploaded.

Second file is the one where the records get copied.


The procedure?


Open master, use your software for fill range D4-I4, and just do nothing: each time data changes a copy will be written to 2nd file.


Regards!
 
Hello, SirJB7


Sorry I couldn't reply as I was out of station.


I have downloaded the two files. I opened both files and linked (master file) with my software. But no change of data found in the second file.


When master file is open it showing target error!

"Updated cells copied with date & time stamp to another workbook. - sample (for pucha at chandoo.org)" not found. Check and qualify path if required.


What may be the problem.


Thanks

pucha
 
Hi, pucha!


There was a missing path qualification in Dir and Open instructions: if opened from Excel it worked fine as it assumed the last opened file path as default path, so if you opened first the .xlsm or master.xls it'd have found seldom .xlsx or sample.xls. But if opened from the Windows Explorer, the default path remained as your default open folder, so it wouldn't have found them.


Please download the updated files from same previous links, in either both versions 2007/10 and 2003 as you need.


I apologize for the inconvenience.


Regards!
 
You must log in or register to reply here.
Back
Top