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

[Metastockusers] Re: importing COTR data into Metastock



PureBytes Links

Trading Reference Links


http://www.softwarenorth.com/trading/commitmentscurrent/

This site has the COT zipped, downloadable to excel. I created the
following wkly chart of Soybean Oil in MS. Histogram is Commercials in
red, Large Specs in green, white line is OI:

http://www.streamload.com/hcour/SO_COT2.GIF

You could write/record a macro in excel to manipulate the data so the
chart comes out like this or your own particular style. I believe you
could make an OEM link so the data would automatically update in MS
when you update the COT excel file.

Harold



--- In Metastockusers@xxxxxxxxxxxxxxx, "mattheim" <subscribe@xxxx>
wrote:
> 
> As a futures trader I collect and analyze the CFTC Commitment of 
> Traders data on a weekly basis using Excel...is there an easy way
to 
> import this data in Metastock ? I have played around with importing 
> Excel files into Metastock but have found it too cumbersome to be 
> practical...





------------------------ Yahoo! Groups Sponsor --------------------~--> 
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/zMEolB/TM
--------------------------------------------------------------------~-> 

 
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:
    http://docs.yahoo.com/info/terms/