logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
lurker192  
#1 Posted : Wednesday, October 6, 2010 3:42:23 AM(UTC)
lurker192

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 5/15/2009(UTC)
Posts: 59

I've created a text file in the following format to input with MS: <ticker>,<NAME>,<PER>,<date>,<TIME>,<OPEN>,<HIGH>,<lOW>,<CLOSE>,<VOL>,<OPENINT> AAC,Australian Agricultural C Food Beverage &,D,07/01/2010,,1.51,1.51,1.465,1.5,2823.22,0 AAD,Ardent Leisure Group Real Estate,D,07/01/2010,,0.98,0.99,0.94,0.94,7683.89,0 AAG,Aragon Resources Ltd Materials,D,07/01/2010,,0.19,0.19,0.18,0.18,449.75,0 AAK,Australia China Holdings Real Estate,D,07/01/2010,,0.003,0.003,0.003,0.003,2000,0 AAM,A1 Minerals Ltd Materials,D,07/01/2010,,0.22,0.22,0.21,0.21,3322.18,0 AAX,Ausenco Ltd Capital Goods,D,07/01/2010,,1.8,1.835,1.71,1.795,16177.87,0 etc, which updates fine but doesn't insert the company name. Can any one tell me what I'm doing wrong here please? Note: The first line says TICKER, NAME, etc between angled brackets but for some reason it doesn't appear properly in this message.
haddison  
#2 Posted : Wednesday, October 6, 2010 9:41:33 AM(UTC)
haddison

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 3/6/2010(UTC)
Posts: 113
Location: London

You have two commas after the date - was that intended?
lurker192  
#3 Posted : Wednesday, October 6, 2010 4:15:30 PM(UTC)
lurker192

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 5/15/2009(UTC)
Posts: 59

Yes, that's needed for the TIME field. It's "(TICKER),(NAME),(PER),(DATE),(TIME),(OPEN),(HIGH),(LOW),(CLOSE),(VOL),(OPENINT)" I'm trying to change the stock name in the Title Bar, but can't seem to do so.
haddison  
#4 Posted : Wednesday, October 6, 2010 5:05:08 PM(UTC)
haddison

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 3/6/2010(UTC)
Posts: 113
Location: London

Are you using MS EOD or MS Pro? If you're using EOD, try removing the Time field - its not compulsory. This is what it says in The Downloader help file:

<time>. The time of the data contained on the line of the ASCII file. This field should only be used if the ASCII file contains intraday price data (i.e., the periodicity is intraday). The time should be entered using a 24 hour clock (e.g., 3:30 PM = 15:30).
lurker192  
#5 Posted : Wednesday, October 6, 2010 5:36:17 PM(UTC)
lurker192

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 5/15/2009(UTC)
Posts: 59

No I get error messages if I leave that out. As is it updates correctly but doesn't insert the name in the title bar, unless it's a new stock.
wabbit  
#6 Posted : Wednesday, October 6, 2010 6:07:01 PM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
You need to include a proper header row.

Code:

<ticker>,<name>,<per>,<date>,<open>,<high>,<low>,<close>,<vol>,<oi>
AAC,Australian Agricultural C Food Beverage &,D,07/01/2010,,1.51,1.51,1.465,1.5,2823.22,0
AAD,Ardent Leisure Group Real Estate,D,07/01/2010,,0.98,0.99,0.94,0.94,7683.89,0
AAG,Aragon Resources Ltd Materials,D,07/01/2010,,0.19,0.19,0.18,0.18,449.75,0
AAK,Australia China Holdings Real Estate,D,07/01/2010,,0.003,0.003,0.003,0.003,2000,0
AAM,A1 Minerals Ltd Materials,D,07/01/2010,,0.22,0.22,0.21,0.21,3322.18,0
AAX,Ausenco Ltd Capital Goods,D,07/01/2010,,1.8,1.835,1.71,1.795,16177.87,0 



wabbit [:D]

lurker192  
#7 Posted : Wednesday, October 6, 2010 7:36:42 PM(UTC)
lurker192

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 5/15/2009(UTC)
Posts: 59

I did. Like I said in my first message, if I type in those angled brackets they only appear as commas on this forum for some reason. How do you include that code section btw?
wabbit  
#8 Posted : Wednesday, October 6, 2010 8:11:29 PM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
lurker192  
#9 Posted : Wednesday, October 6, 2010 9:15:20 PM(UTC)
lurker192

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 5/15/2009(UTC)
Posts: 59

Ok thanks Wabbit, this is what I have:
Code:


<ticker>,<NAME>,<PER>,<date>,<TIME>,<OPEN>,<HIGH>,<lOW>,<CLOSE>,<VOL>,<OPENINT>
AAC,Australian Agricultural C Food Beverage &,D,09/10/2010,,1.61,1.62,1.6,1.61,1338.17,0
AAD,Ardent Leisure Group Real Estate,D,09/10/2010,,1.03,1.03,1.01,1.01,4291.76,0
AAE,Agri Energy Ltd Energy,D,09/10/2010,,0.011,0.011,0.011,0.011,1000,0
AAG,Aragon Resources Ltd Materials,D,09/10/2010,,0.18,0.185,0.17,0.17,3781.88,0
AAJ,Aruma Resources Ltd Materials,D,09/10/2010,,0.175,0.175,0.165,0.165,235.44,0
AAM,A1 Minerals Ltd Materials,D,09/10/2010,,0.14,0.14,0.135,0.135,2919.28,0
AAO,Australasia Consolidated Materials,D,09/10/2010,,0.064,0.064,0.06,0.06,1633.85,0


TICKER,NAME,PER,DATE,TIME,OPEN,HIGH,LOW,CLOSE,VOL,OPENINT Ok that still doesn't work. The above (without the angled brackets) is my first line.
haddison  
#10 Posted : Thursday, October 7, 2010 1:00:21 AM(UTC)
haddison

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 3/6/2010(UTC)
Posts: 113
Location: London

I don't know if this will work, but try putting a time of 00:00.

You said you get an error message if you remove the time field, but I forgot to tell you that you could try removing both the periodicity and the time fields to see if it works. They're both optional unless you have intraday data.
lurker192  
#11 Posted : Thursday, October 7, 2010 4:06:25 AM(UTC)
lurker192

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 5/15/2009(UTC)
Posts: 59

Ok I could add and subtract fields, but I doubt it's going to change the name in the Title Bar. I'm pretty sure I did this about 18 months ago, but sadly I've forgotten how.
wabbit  
#12 Posted : Thursday, October 7, 2010 8:10:14 AM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
Are you meaning "Chart Window Properties > Title" ??


wabbit [:D]

lurker192  
#13 Posted : Thursday, October 7, 2010 12:14:07 PM(UTC)
lurker192

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 5/15/2009(UTC)
Posts: 59

wabbit wrote:
Are you meaning "Chart Window Properties > Title" ??


wabbit [:D]

I think that't the one. There's the menu line, then the icons, then the title bar I'm referring to. The data file I've shown will insert the name if the file doesn't already exist.
wabbit  
#14 Posted : Thursday, October 7, 2010 5:06:09 PM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
Chart Window Properties > Chart Options > Show Chart Title Bar
Chart Window Properties > Chart Options > Show Inner Window Title Bars

???


wabbit [:D]

lurker192  
#15 Posted : Thursday, October 7, 2010 5:30:48 PM(UTC)
lurker192

Rank: Advanced Member

Groups: Registered, Registered Users, Unverified Users
Joined: 5/15/2009(UTC)
Posts: 59

Yes they're all checked and I can see the Ticker symbol and prices. I'm just wondering how you can enter or change the name of the stock as viewed on that same line?
Users browsing this topic
Guest (Hidden)
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.