[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [Metastockusers] Massive Renaming



PureBytes Links

Trading Reference Links




Sorry folks . . 
.  ignore the post below; it won't work because you can only merge 
identical tickers.
<SPAN 
class=826394417-09072004> 
Must be the hot 
weather!!
<SPAN 
class=826394417-09072004> 
<SPAN 
class=826394417-09072004>Regards,
<SPAN 
class=826394417-09072004>Mike
 
 
 
<BLOCKQUOTE dir=ltr 
>
  
  <FONT 
  face=Tahoma size=2>-----Original Message-----From: Mike Sloane 
  [mailto:mfsloane@xxxxxxxxxxxxxx] Sent: Saturday, 10 July 2004 3:43 
  AMTo: Metastockusers@xxxxxxxxxxxxxxxSubject: RE: 
  [Metastockusers] Massive Renaming
  I haven't tested 
  this procedure, however logic says that it should do what you 
  want:
  <SPAN 
  class=837413417-09072004> 
  <SPAN 
  class=837413417-09072004>1.0    Export a single day of data 
  from your existing data file(s) to Excel format
  <SPAN 
  class=837413417-09072004>2.0    Use Excel's Find and Replace 
  function and wildcards (**) to add whatever you want at the end of each 
  ticker
  <SPAN 
  class=837413417-09072004>3.0    Save the data file and Convert 
  it using the Downloader to a new folder; this will create a new data file with 
  all of your tickers and only one day's data
  <SPAN 
  class=837413417-09072004>4.0    Use the Merge function of the 
  Downloader to merge the old data file with the new and select the correct 
  option to Keep the source data
  <SPAN 
  class=837413417-09072004> 
  You may run into 
  problems with date formats between your original Excel file and the file that 
  the Downloader expects to see; personally, I would add an additional step of 
  formatting the date as yyyymmdd in Excel, saving it as a .csv file, opening it 
  in Word and saving as a .txt file. I have found this to be a fairly 
  bulletproof way of avoiding some of the date format issues, but it is a little 
  long-winded.
  <SPAN 
  class=837413417-09072004> 
  Good luck and good 
  trading,
  <SPAN 
  class=837413417-09072004>Mike
  <FONT face=Arial color=#0000ff 
  size=2> 
   
  <BLOCKQUOTE 
  >
    
    <FONT 
    face=Tahoma size=2>-----Original Message-----From: ÐÝôñïò ËÜæïò 
    [mailto:peterl@xxxxxxxxx] Sent: Friday, 9 July 2004 5:07 
    PMTo: Metastockusers@xxxxxxxxxxxxxxxSubject: 
    [Metastockusers] Massive Renaming
    <FONT face=Arial color=#0000ff 
    size=2>Does anyone know, if it's possible to change the symbols' tickers, 
    adding at the of eachone a spesific ending(the same for all) with one 
    procedure and not one by one??
    <FONT face=Arial color=#0000ff 
    size=2>TiA
    <FONT face=Arial color=#0000ff 
    size=2>P.







Yahoo! Groups Sponsor


  ADVERTISEMENT 












Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/Metastockusers/ 
To unsubscribe from this group, send an email to:Metastockusers-unsubscribe@xxxxxxxxxxxxxxx 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.