SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : Metastock 6.0 for Window
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: Michael Olds who wrote (3710)12/4/2000 10:32:25 PM
From: Bob Anderton  Read Replies (1) of 4056
 
I wanted to follow up on a question I asked a couple of weeks ago about why I couldn't get a price series to export as a link into Excel and update itself. I know what I was doing wrong now and I thought I would post it in the hopes that it may help someone else. I was highlighting a price series in Metastock, then going to Excel, clicking on a cell, then going to paste special, clicking "paste link" and "csv". This would paste the data set into the spreadsheet but it wouldn't update with the next day's data. The key is (seems obvious in retrospect) is that you have to highlight a block of cells that is larger than the data set (like >2000 cells if you have 2000 days of data)then do the paste special, paste link, csv.

If you do what I was doing wrong and just highlight the first cell and paste special the link will only paste a block of cells that is as big as the number of days of data you have at that point. The next day, the data set will be 1 cell bigger but your block of linked cells isn't so it won't look like it updated.

This is really basic I guess but I bet a lot of people haven't realized this yet.

By the way, thanks to Michael Olds for trying to help even though I didn't have my question spelled out well enough.

Bob
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  

HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2025 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News