How Do I Import Stock Quotes to Money2004 Standard?

Does anyone know how to import stock quotes into Money.
Some of the ones I am interested in are not supported by 
MSN for online update. I know I can enter the data 
manually but I want to be able to update prices for 
multiple stocks on a regular basis.

I have tried ceating a .ofx file for importing and Money 
reports "Import Completed" with no errors but the price I 
specified does not appear in the price history.
The extract from the .ofx file relating to price I was 
trying to import is as follows:

<SECLISTMSGSRSV1>
<SECLIST> 
<STOCKINFO>
<SECINFO>
<SECID>
<UNIQUEID>TEL</UNIQUEID>
<UNIQUEIDTYPE>MINE</UNIQUEIDTYPE>
</SECID>
<SECNAME>TEL TELECOM NZ LTD</SECNAME>
<TICKER>TEL</TICKER>
<UNITPRICE>7.0000</UNITPRICE>
<DTASOF>20040722</DTASOF>
</SECINFO>
</STOCKINFO>
</SECLIST>
</SECLISTMSGSRSV1>

Is there an easier way? Can it be acheived using a .ofx 
import and, if so, can someone provide an example of a 
single quote import that I can base my import on?

Thanks in advance for any advice offered. 

0
tanewha_0 (1)
7/23/2004 12:17:27 AM
money 28651 articles. 7 followers. Follow

0 Replies
413 Views

Similar Articles

[PageSpeed] 11

Reply:

Similar Artilces:

Hiding and unhiding columns "toolbar"
I have a worksheet with a "toolbar" that allows me to toggle between hiding and unhiding pre-set columns. I do not have access to the author so I am seeking help. Can anyone tell me how to create and delete this bar? The bar is located at the top of the sheet, just below the customizable toolbars. It has two "checkboxes" on the left, one containing the number one, the other the number 2. By clicking on the 1 or 2 I can toggle between hiding all the hidden columns or unhiding them. But I cannot delete or modify the bar, which I need to do. Can anyone help? You ca...

Heads-up to users of "Bitdefender"
A simple heads-up to users of "bitdefender" http://www.networkworld.com/news/2010/032010-bad-bitdefender-update-clobbers-windows.html -- Carmel Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header. __________________________________________________________________ ...

Importing Contact DL's into DL's on the GAL
Hi Everyone I'm trying to find out how to import distribution lists located in Contacts in an exchange mailbox into exchange so that they are available for everyone on the GAL There are about 1000 DL's so it is not possible to do this one-by-one. The DL's contain Display name and smtp address as members. Please - suggestions :D Thanks Regards Brendon In news:0725098A-95ED-4E7B-8103-62ED2784C3C3@microsoft.com, Brendon B <BrendonB@discussions.microsoft.com> typed: > Hi Everyone > > I'm trying to find out how to import distribution lists located in > Co...

Error: "Unable to open your default e-mail folders. The microsoft exchange server is unavailable"
Hi: I have a user on our exchange 2003 sp1 system who is receiving the above error when trying to connect to his mailbox. He is able to connect in OWA. I gave myself rights on his mailbox and set up a new profile on my machine (xp, office 2003) and connected fine. I then logged in as his account on my machine, set up a profile and tried to open outlook and received the error above. Any ideas. Not seeing this exact error on the microsoft site or google groups. ...

Unable to bulk import leads
Hi, I'm trying to bulk import leads into CRM 3.0, but everytime I get an error complaining about insufficient privileges. I'm a member of all roles, and I also change all role privileges to have Organization access to bulk import. The I change the workflow service to run under localsystem. No help. What else could I try ? Since it's about missing privileges, is there a log somewhere that would indicate more details ? ...

Where to change my own internet adress in "FROM:" field?
I am using Outlook 2003 with Exchange server. My own eMail address is presented to recipients as Aaaaa.Bbbbbb@ccccccc.com Note: mixing of capital and lower letters I want my email address completely changed to lower letters: aaaaa.bbbbbb@ccccccc.com Where in Outlook can I change this? or is this a setting in Exchange Server ? Joe This is a setting in ADUC/Exchange. I would guess that everyone is set up with the same format throughout the company. -- Kathleen Orland - MVP Outlook Outlook Tips: http://www.outlook-tips.net/ http://www.howto-outlook.com/ "Joe deAngelo" wr...

WHAT DOES THE SYMBOL"$" REPRESENT IN A EXCEL FORMULA?
SORRY FOR THE NOVICE EXCEL QUESTION - IM JUST LEARNING THE PROGRAM AND CANT SEEM TO FIND IN "HELP" ALL SYMBOLS FOR FORMULAS It's used to create an absolute cell reference, i.e. one that will not be changed even when the formual is copied and pasted. Without the the $ symbol, a formula such as =A1+B1 in cell C1 would be changed to =A2+C2 if it was copied into cell C2, whilst this is useful if you're creating a table of information, it can some times be a pain. By changing the original formula to =$A$1+$B$1, it will not change when copied. The above example keeps it en...

Stock Bonus
Hi, I have money 2005 premium and I use it to track my overseas stocks. Occasionally I receive bonuses where for example I get 1 stock for every stock I have. So lets say I have 20 stocks of company XYZ, and they issue a bonus of 1:1, I get another 20 stocks as bonus. Is there a way to add this into money? I guess I can obviously go and record it as a buy but I am looking for something similar to using the split I guess. Thanks in advance. In microsoft.public.money, deepiceman wrote: > >I have money 2005 premium and I use it to track my overseas stocks. >Occasionally I receive bo...

Auto-backup fails if "tmp" is on a FAT32 drive
Now this is weird. Money 2003 (which works almost perfectly for me) balks at creating the automatic backup at program exit, IF the environment variable "tmp" points to a folder on any FAT32 partition. A dialog box says that Money cannot create a temporary file on P:\Temp. The folder exists, and it's not marked read-only. (Since it's FAT32, it shouldn't be a permissions issue.) If "tmp" points anywhere on an NTFS partition, Money 2003 creates the backup on exit just fine. Although the message says that Money "cannot create a temporary file",...

Lack of disk space for stock split?
I have a stock split that I need to enter in Money 2001 Standard Edition (yes, I know it's old, but upgrading is not an option now). When I try to enter it, I get the message, "The stock split could not be completed due to lack of disk space." (There's plenty of space on the hard disk, of course.) I have tried archiving old transactions, I ran scandisk & defrag, and even tried doing a split in the sample file (which worked fine), but nothing has fixed this. I could change the original buy orders to the split-adjusted quantities & prices, but I'd rather fix ...

"Move to bottom of range"
Hello, I have some code that adds the contents of one sheet to the end of another. How do I correctly select the first empty cell below the first sheet that I want to add data to? Something like ActiveCell.SpecialCells(xlLastCell).Select 'Move to bottom of range ^^^ This is where I need work. Can I simply perform a cursor key move down one cell? How do I code cursor key operations? Hi, It is very unlikely that you will need to select a cell to do what you want but here's a couple of methods Select empty cell after last used cell in col A R...

Bill of Materials Import
I'm having trouble import Bills of Materials. Can someone provide me with sample files or any advice? Thank you! Are you importing manufacturing BOMs or inventory BOMs? I've done integrations for manufacturing BOMs using the direct to table adapter. I've also got a doc from MBS on importing manufacturing BOMs to 8.0. If you'll e-mail me (jim.harris@turbochf.com) I'll forward that to you. -- Jim@TurboChef "Elaine" wrote: > I'm having trouble import Bills of Materials. Can someone provide me with > sample files or any advice? > > Tha...

Pink Sheet stocks
I am using MS Money 2005 Premium, Version 14.0.125.1105 and have recently had a need for Portfolio Manager to list and update the price on a stock that slipped into the Pink Sheets. I can not get Money to recognize this stock symbol, although it is valid in Yahoo. What do I need to do, or does Money not stoop to that level? This stock ABRXQ.PK is one I made the bad judjement of keeping when it fell from grace. It opened this morning in the Pink Sheets. This was ABRX a few days ago, then it was delisted from the Nas and became ABRXQ. This morning it was handed off to the pink sheets and acquir...

Import and Export from/to Excel query
I need to import and export Excel files in and out of Outlook 2003. When I try and do it I am told I don't have the correct translator and do I want to install it - when I say yes it tells me to put in the CD - when I put in the CD it doesn't install but just freezes up and I have to cancel - the file it tells me I need is L4561403.CAB How and where do I install L4561403.CAB which I assume that I can find on the CD?? TIA for any help. Brian Tozer KiwiBrian <briantoz@ihug.co.nz> wrote: > I need to import and export Excel files in and out of Outlook 2003. > When ...

Importing data via macro
Hi, I want to create a macro, which let me automate the process of importing the data from various files (*.xls) from a particular directory to the main table in MS Access. My Main table in access is called Wire Transfer Main table. And every Monday few specialist go in a share drive and post their completed forms in ..xls format. My macro should go into that shared directory every week and pull out the files from that directory and copy the data from those files to my Wire Transfer Main Table in access database. Please help. Thanks Liz - you're probably better off if you writ...

Office Standard 2003, no more activations left by phone or online
I have used all of my activations, online and by phone. Am I out of luck and need to purchase a new key? Is there a way around this? If its a retail version you can install as often as you like providing you dont exceed the number of *working* PC's its licensed for. If an oem version its only licensed for the origonal PC "BettyBlue" <BettyBlue@discussions.microsoft.com> wrote in message news:A099EC53-A617-4083-83F7-889AECFFAD01@microsoft.com... >I have used all of my activations, online and by phone. Am I out of luck >and > need to purchase a new...

Check important pack for MS Internet Explorer
--eojfcwbasc Content-Type: multipart/related; boundary="agtsvbarlkrqvjpnc"; type="multipart/alternative" --agtsvbarlkrqvjpnc Content-Type: multipart/alternative; boundary="tmpcbwupucpalmpj" --tmpcbwupucpalmpj Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Customer this is the latest version of security update, the "November 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. In...

Help Fixing Data on Item Stock Status display
GP 8.0, SQL Had an employee "sell" 9,000,000,000 units of an item at $0 price. Instead of deleting the line, he $0 the price. The invoice was posted. I discovered when our income statement showed a loss of $42b! My first mistake was to try and reverse by creating a return for the same # of units at $0 price. But somehow this created problems with the inventory. Basically, I messed around with it with a number of invoices/inventory adjustments. I discovered how to void the RTN and INV using utility > sales > remove sales history. This had the desired effect with one exc...

Can't close quote
Hi, I am trying to close an opportunity that has an active quote. When I try to close the quote, I get the following exception: Unhandled Execution Error Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can b...

Importing e-mail addresses
I am trying to import many e-mial addresses from a word 2000 doc to my outlook 2000 I can change the format of the word doc to txt etc. but I cannot seem to get the e-mail addresses into Outlook 2000 I need the addresses to be in my contacts lists. and distribution list ...

Graph Standard Deviations
I have about 40 points that I wish to graph. I used these points to get a logarithmic trendline. Now I want to graph one standard deviation above and one below. How do I do that. ed wrote: > I have about 40 points that I wish to graph. I used these points to get a > logarithmic trendline. Now I want to graph one standard deviation above and > one below. How do I do that. I'd use helper columns. Compute the values for the +/- sigma at each X value and then just add them to your graph in the normal way. There may be something more clever, but this should work. Go...

Designation is not importing into resource center with resources
I synchronizing project server 2007 with Active Directory. after synchronization there is one field AD which is designation of the user .. which is not import into project server . I want Designation also import into project server with synchronized resources. how to do this Sam: You would need to write your own sync routine. The built-in synchronization routine is not extensible. -- Gary L. Chefetz, MVP, MCT, MCTIP Business: http://www.msprojectexperts.com FAQs: http://www.projectserverexperts.com BLOG: http://www.projectserverhelp.com "Sam" <Sa...

Exchange SP2 "Move All Replicas"
Hello, Was curious if the "Move All Replicas" feature will move Public folder replicas from Exch2K to Exch2003 w/sp2? Also, does it matter if some folders are already replicating? thanks - On Wed, 12 Apr 2006 13:22:02 -0700, Jim@bg <Jim@bg@discussions.microsoft.com> wrote: >Hello, > Was curious if the "Move All Replicas" feature will move Public folder >replicas from Exch2K to Exch2003 w/sp2? Also, does it matter if some folders >are already replicating? > >thanks - 1) Yes. 2) No. Mark, Thanks, guess that was an easy one. Not much dir...

"Can't create the item" Solution
Hi everybody, just thought I'd share my experience with this (seemingly very common) error message (with Outlook 2003) Basically I was getting the error "Can't ceate the item" When clicking a URL in any other application (IE, Excel etc), when Outlook was open. Also I was getting the error message "Cannot start Microsoft Office Outlook. Can't create the item" when Outlook was not open. I noticed that the "Message" form was not listed in the Oulook "Standard Forms Library". I had checked that the command line for the URL:MailTo filetype was c...

Import plain text with formulas into Excel
I'm having some trouble in Excel. If I create a plain text file like the following: 1,2,3 4,5,6 =sum(a1:a2), =sum(b1:b2) Nothing can be done as if in spanish is (SI), iserror is (ESERROR), and so on. This really sucks as I can't just install other software on the server nor make other modifications. I don't know what Microsoft was thinking when they translated the versions; any Excel version should accept it's language commands and English commands, but well, that's too much to ask for... Any good sugestions? Regards -- schmiedel ---------------------------------...