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

Re: [EquisMetaStock Group] Data Import in MS (newbie question)



PureBytes Links

Trading Reference Links

Eduardo,

Thank you very much for your help...

kindest regards
Alex






On 3/23/06, Eduardo Gontan Pulgarin <con051204@xxxxxxxxxxx> wrote:
>
> This is how I have created the chart:
>
>   1.    Copy & paste data into spreadsheet.
>
>     In Exel go to Data-Text to Column.
>     In the Wizard click on "Fixed Width" and on to "Next".
>    Click under "20" and on to "Next".
>    On the first column "Date" click on "Date" on the "Column data format"
> and set it up to "MDY" and click on "Finish".
>    Highlight the "Value" column and set it up on 2 decimals by clicking on
> the "Increase/Decrease" decimal arrows.
>    There are lots of gaps missing in the data; to get rid of them, create
> a new column on the left of  the "Date" column, type on cells A2, A3 and A4
> the numbers 1-2-3,
>   highligth  them, then drag the dot on the bottom right (the pointer
> should become a cross) all the way to the final cell on which the data end
> (which should be on the 03-21-06).
>   8.  Go back to the beginning of the page, highlight the whole thing, all
> the way to
>   the bottom, go to Data-Sort and choose the "Value" column; click on
> "OK".
>
>    Delete the gaps and repeat step 8., but this time choose the column
> "A", then
>   delete it.
>
>    You should now have  the "Date" and "Value" columns; highlight the data
> in the
>   "Value" column and copy it in the columns C, D and E; this is so that
> the Downloader "High", "Low" and "Close" columns are filled when you copy
> the data into it; otherwise you'll only get a flat line on your chart .
>          11. Now highlight the whole thing, create a new security in the
> Downloader and copy
>    it into it.
>
>   I hope this'll help you.
>
>
>   Eduardo.
>
>
>
>
> Alex Spiroglou <a.spiroglou@xxxxxxxxx> wrote:  Dear Listmembers,
>
> I would like to import the followwing data in Metastock
> ( http://research.stlouisfed.org/fred2/data/DGS10.txt )
>
> How is this possible ?
> Please keep all responses as analytical as possible... (newbie)
>
> rgds
> Alex Spiroglou
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ---------------------------------
>   YAHOO! GROUPS LINKS
>
>
>     Visit your group "equismetastock" on the web.
>
>     To unsubscribe from this group, send an email to:
> equismetastock-unsubscribe@xxxxxxxxxxxxxxx
>
>     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
> ---------------------------------
>
>
>
>
>
> ---------------------------------
> Yahoo! Photos – NEW, now offering a quality print service from just 8p a
> photo.
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> SPONSORED LINKS
>   Business finance course<http://groups.yahoo.com/gads?t=ms&k=Business+finance+course&w1=Business+finance+course&w2=Business+to+business+finance&w3=Small+business+finance&w4=Business+finance+consultant&w5=Business+finance+magazine&w6=Business+finance+schools&c=6&s=185&.sig=I8jDsORmsaYn0BeqghcJ2w> Business
> to business finance<http://groups.yahoo.com/gads?t=ms&k=Business+to+business+finance&w1=Business+finance+course&w2=Business+to+business+finance&w3=Small+business+finance&w4=Business+finance+consultant&w5=Business+finance+magazine&w6=Business+finance+schools&c=6&s=185&.sig=fCzze7cxm1K7TVKkzAaOrA> Small
> business finance<http://groups.yahoo.com/gads?t=ms&k=Small+business+finance&w1=Business+finance+course&w2=Business+to+business+finance&w3=Small+business+finance&w4=Business+finance+consultant&w5=Business+finance+magazine&w6=Business+finance+schools&c=6&s=185&.sig=v9sWAno7Kz4WuL8Tadcdhw>  Business
> finance consultant<http://groups.yahoo.com/gads?t=ms&k=Business+finance+consultant&w1=Business+finance+course&w2=Business+to+business+finance&w3=Small+business+finance&w4=Business+finance+consultant&w5=Business+finance+magazine&w6=Business+finance+schools&c=6&s=185&.sig=d1xwT3WL0E6XBf6cAV5BXA> Business
> finance magazine<http://groups.yahoo.com/gads?t=ms&k=Business+finance+magazine&w1=Business+finance+course&w2=Business+to+business+finance&w3=Small+business+finance&w4=Business+finance+consultant&w5=Business+finance+magazine&w6=Business+finance+schools&c=6&s=185&.sig=qphRINaNuVm_6bwoQxgUmg> Business
> finance schools<http://groups.yahoo.com/gads?t=ms&k=Business+finance+schools&w1=Business+finance+course&w2=Business+to+business+finance&w3=Small+business+finance&w4=Business+finance+consultant&w5=Business+finance+magazine&w6=Business+finance+schools&c=6&s=185&.sig=1RfnhYZpV99RKWRZzSH4gA>
>  ------------------------------
> YAHOO! GROUPS LINKS
>
>
>    -  Visit your group "equismetastock<http://groups.yahoo.com/group/equismetastock>"
>    on the web.
>
>    -  To unsubscribe from this group, send an email to:
>     equismetastock-unsubscribe@xxxxxxxxxxxxxxx<equismetastock-unsubscribe@xxxxxxxxxxxxxxx?subject=Unsubscribe>
>
>    -  Your use of Yahoo! Groups is subject to the Yahoo! Terms of
>    Service <http://docs.yahoo.com/info/terms/>.
>
>
>  ------------------------------
>



--
Alex Spiroglou


[Non-text portions of this message have been removed]



------------------------ Yahoo! Groups Sponsor --------------------~--> 
Try Online Currency Trading with GFT. Free 50K Demo. Trade 
24 Hours. Commission-Free. 
http://us.click.yahoo.com/RvFikB/9M2KAA/U1CZAA/BefplB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/