Discussions
 » 
Product and Service Development
 » 
MetaStock
 » 
How to display for example Dow Jones / Gold both in USD
 
        
            
            
    | 
Rank: Member
 Groups: Registered, Registered Users, SubscribersJoined: 5/31/2007(UTC)
 Posts: 14
 
 Thanks: 1 times
 |  | 
    | 
             | 
            
         | 
    |  | 
        
        
        
            
        
            
            
    | 
Rank: Advanced Member
 Groups: Moderators, Registered, Registered Users, SubscribersJoined: 10/8/2010(UTC)
 Posts: 1,999
 
 Thanks: 96 timesWas thanked: 159 time(s) in 154 post(s)
 
 | 
            
	      
                This would depend on the source of the data, but generally speaking you should be able to use the "Security" function to divide one into the other. This would display as an indicator in a chart, not as a base security in a chart.
You can also use the DownLoader to create a Composite of 2 local security files (File->New->Composite). The primary and secondary security must be in the same local data folder, and the composite security will also reside in this same folder. | 
    | 
             | 
            
         | 
    |  | 
        
        
        
    
        
            
            
    | 
Rank: Member
 Groups: Registered, Registered Users, SubscribersJoined: 5/31/2007(UTC)
 Posts: 14
 
 Thanks: 1 times
 | 
            
	      
                Thanks, I followed the  DownLoader route Used default Metastock EOD installation sample data Folder: C:\MetaStock Data\SampleName: DJIG/GOLD
 Primary: .DJI
 Secondary: GCc1#1
 
 How do I convert GCc1#1 to grams of gold cant add divide / 31103.4768 to Secondary
 (Dow Jones Ind Symbol .DJI) / ((Gold Comx Continuous Symbol:@:GCc1#1) / 31103.4768) = in grams of gold   | 
    | 
             | 
            
         | 
    |  | 
        
        
        
            
        
            
            
    | 
Rank: Advanced Member
 Groups: Moderators, Registered, Registered Users, SubscribersJoined: 10/8/2010(UTC)
 Posts: 1,999
 
 Thanks: 96 timesWas thanked: 159 time(s) in 154 post(s)
 
 | 
            
	      
                Unfortunately there isn't a way to do that via the Composite building. It is possible you could do the mathematical adjustment via Tools-->Adjust-->Data in The DownLoader to adjust the data that way. Our current real-time data feed (XENITH) does allow currency and unit conversions directly within a chart but this would otherwise have to be done manually. Edited by user Wednesday, March 23, 2016 5:23:11 PM(UTC)
 | Reason: Not specified | 
    | 
              1 user thanked MS Support for this useful post. |  | 
    |  | 
        
        
        
    
        
            
            
    | 
Rank: Member
 Groups: Registered, Registered Users, SubscribersJoined: 5/31/2007(UTC)
 Posts: 14
 
 Thanks: 1 times
 | 
            
	      
                Thank you for assisting, please add to suggested new functionality | 
    | 
             | 
            
         | 
    |  | 
        
        
        
            
        
            
            
    | 
Rank: Member
 Groups: Registered, Registered Users, SubscribersJoined: 5/31/2007(UTC)
 Posts: 14
 
 Thanks: 1 times
 | 
            
	      
                Hi is it possible to do the following using Indicator Builder, and then display it in an inner window
(Symbol 1 / Symbol 2) / 31103.4768
Example
(Dow Jones Ind Symbol .DJI) / ((Gold Comx Continuous Symbol:@:GCc1#1) / 31103.4768) | 
    | 
             | 
            
         | 
    |  | 
        
        
        
    
        
            
            
    | 
Rank: Advanced Member
 Groups: Moderators, Registered, Registered Users, SubscribersJoined: 10/8/2010(UTC)
 Posts: 1,999
 
 Thanks: 96 timesWas thanked: 159 time(s) in 154 post(s)
 
 | 
            
	      
                FYI, that is probably the letter i on the end of the @:GCc1 symbol, which just means it is reporting specific contract volume/open interest vs. total outstanding contracts. Format should work as below.
Security("C:\MetaStock Data\Sample\.DJI",C) / (Security("C:\MetaStock Data\Sample\@:GCc1#I",C) / 31103.4768) | 
    | 
             | 
            
         | 
    |  | 
        
        
        
            
        
            
            
    | 
Rank: Member
 Groups: Registered, Registered Users, SubscribersJoined: 5/31/2007(UTC)
 Posts: 14
 
 Thanks: 1 times
 | 
            
	      
                Thank you for assisting, exactly what I needed. | 
    | 
             | 
            
         | 
    |  | 
        
        
        
    
                           
    
| Users browsing this topic | 
| 
Guest (Hidden) | 
Discussions
 » 
Product and Service Development
 » 
MetaStock
 » 
How to display for example Dow Jones / Gold both in USD
 
    
        Forum Jump
         
    
    You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.