Import Historical Stock Data from Yahoo-Finance

For a long time I thought this was not possible, but I just read a post 
recently that makes me think that this probably IS possible.  Is there a way 
to import data from, into a table, if you store all stock 
symbols in a table, and put beginning and ending date in a form (in a couple 
of TextBoxes)?

I know how to do this in Excel, with all stock tickers in a row, like row 4 
(or whatever), and all the dates going in descending order in Column A, and 
each security’s historical prices under the symbols (which are in row 4, for 
instance).  The problem in Access is that this would need to have three 
fields, such as Date, Symbol, and Price, and the list would get very long 
(rather than wide, like the way it would be done in Excel).  I know the 
format would be similar to this:
3/19/2010, MSFT , 25.59
3/19/2010, SBUX, 24.97
3/19/2010, S, 3.76

Is there an easy way to get VBA to import this from the 


If this information was helpful, please indicate this by clicking ''Yes''.
3/19/2010 9:36:06 PM
access.modulesdaovba 1670 articles. 0 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 11


Similar Artilces:

WM_QUERYENDSESSION and saving data through a worker thread
Hello I have an application that uses a worker thread to save/load data. I'm wondering what is the best reaction to WM_QUERYENDSESSION in my case. I have to possible scenarios: 1. When WM_QUERYENDSESSION comes fire the thread and wait for it to end. Only then return TRUE from WM_QUERYENDSESSION handler. The problem is that I will get nusty dialog that my application "is not responding". 2. When WM_QUERYENDSESSION comes fire the thread and return FALSE from the handler. When thread is done force application to end. But this way I will probably prevent Windows from closing,...

Copying data from one chart to another
I have many graphs - all plotting on similar scales but using different data. Is there any way I can simply copy one set of data from one graph and paste it into another graph so that I can avoind going through all the hassle plotting each curve again? I want to have graphs showing different combinations of the same data and have hundreds of curves to plot so this could be a huge timesaver... Cheers. -- Alan_Partridge ------------------------------------------------------------------------ Alan_Partridge's Profile: V...

Need to import EDI file
Hello. I have an EDI TS-130 file (academic transcript) that I would like to import into Access 2003. Is this possible to do for free? If so, how? ...

Can I abbreviate one value in a data series?
I've got a chart where one value (8,300) greatly exceeds all the others. Is there a way to abbreviate this value so the other data points show better in the graph? Hi, One way is to break the Y axis, have a look at these examples of how to Cheers Andy CMEknit wrote: > I've got a chart where one value (8,300) greatly exceeds all the others. Is > there a way to abbreviate this value so the other da...

How can I clear the last Data->Text to columns to formatting
I've noticed in Excel 2000 that if I paste text into various worksheets within a workbook each paste will assume the Text->Column formatting that I applied in the previous. How can I prevent it from happening ? Thanks Steve Just run another data|Text to columns against a dummy cell. Specify delimited, but remove all the check marks from all the possible delimiters. (alternatively, you can close excel and reopen it.) svaardt wrote: > > I've noticed in Excel 2000 that if I paste text into various worksheets > within a workbook each paste will assume the Text->Col...

I want to upgrade from Microsoft Money Financial Suite OEM Edition Version 11.0 to latest version but on trying to open the money file in Microsoft Money 2007 I get the following error message: File was created by an incompatible version Question 1: As the old version was pre-loaded into the Computer when I bought it in India, I don't know which country US/Canada/UK/Australia this software belongs to. So how can I confirm which country is it for? Question 2: And, how can I upgrade it to a version of Money from US or UK. -- Kapil ...

Accounts Payable Unapply should allow Unapply of historical trans.
The Unapply button on the Apply Payables Document is really just an unmark all button. Please rename this button and add the functionality to unapply historical payments, credit memos and returns. I believe this functionality exists for SOP and should be there for AP. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and th...

Importing Messages From Another Mail Program
I just set up outlook express 6.00.2900.2180 for XP SP2 and wish to import my messages and folders from Netscape 7.0 mail and when I follow the instructions and click on the netscape Local Folder inbox file, I get a message from outlook that says there aren't any messages in the file. I tried to mail the files as attachments but that didn't work. Is there some other way to export these messages .to outlook express. Ask in an Outlook Express forum. This is an Microsoft Office Outlook forum. Outlook Express is family of Internet Explorer and Outlook of the Office family. Here is...

Most important file won't open
The only file I can't get into is my most important one. Each time I try to open it I get a "This program has performed an illegal operation and will be shut down." In the details it says, "Excel caused an invalid page fault in module MS097.dll at 0167:306eef2e." How do I fix the problem? Jim, "The only file I can't get into is my most important one" why is it always this file! Just a couple of things to try, have you rebooted the computer? this will sometime solve a world of problems, try opening it on another computer, was anything added to the file...

How do I import data from lotus123 & maintain formulas/worksheets
I am trying to convert several complex Lotus 123 workbooks with formulas into Excel 2003. How do I do this and maintain my formulas and the individual tabs (worksheets). hi, if the lotus file is a wks version or earlier, xl should open it and let you save it as an xl file. if the lotus file is a 123 version or higher, you can open the file in lotus and save it as an xl file. if you don't have lotus, find someone who does. "Ineluctable" wrote: > I am trying to convert several complex Lotus 123 workbooks with formulas into > Excel 2003. How do I do this and maintai...

importing schema
Hello, If I have a nice schema, created with xml spy. Can I import to visio. creating a nice visio diagram? thanks visio (and the other office products) each has their own schemas. However, that does not preclude your creating an xslt transform to map to what is appropriate to what visio requires. Chris Roth one of the MVPs has a nice presentation on some of the basics. al "greg" <> wrote in message news:u0WkWPtIHHA.780@TK2MSFTNGP03.phx.gbl... > Hello, > If I have a nice schem...

obtaining data in text form from a table
Hi all, I like to be able to obtain the dates in a text format from the table below. ie Test2 8-Feb Test5 4-Feb,8-Feb Test6 4-Feb,5-Feb, 9-Feb Do I need to do this by macros and if so, any help would be appreciated. Table Care Recipient Surname 4-Feb 5-Feb 8-Feb 9-Feb Test1 Test2 8-Feb Test3 Test4 Test5 4-Feb 8-Feb Test6 4-Feb 5-Feb 9-Feb Vlookup should do what you want, as in: =vlookup(a2,Table,2,false) Adjust the ranges t...

Determine number of rows with data
Hi I am using the macro below to pull some data from an external workbook. The 2 issues I need to sort are: 1. The number of rows in the external workbook can vary. How do I amend this code to pull all of the rows with data? 2. The number of rows in the autofill also may vary. How do I autofill only the number of rows required? i.e the number of rows in column A that contain data. 'Lookup Previous Month Sales Columns("K:K").Select Selection.NumberFormat = "General" Range("K4").Select Selection.FormulaArray = _ "=S...

Delete contents deletes all data and formulas
When I hit delete contents all data and formulas are deleted. How can I delete data without deleting formulas? Hi, You could try this tap F5 - Special - Constants - OK and if that selects the data you want to delete then tap the delete key -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "tdhcrr" wrote: > When I hit delete contents all data and formulas are deleted. How can I > delete data without deleting formulas? First use Find...

Importing #3
I had a previous version of Money and just got a new computer with Money 2004. I have a backup disk made with the info from the previous version. How can I import that into the new version? File|Restore?!? <> wrote in message news:075a01c3d169$a360b0a0$a001280a@phx.gbl... > I had a previous version of Money and just got a new > computer with Money 2004. I have a backup disk made with > the info from the previous version. How can I import that > into the new version? ...

Add data to cell w/o loosing initial data
I would like to know if there is a way to add data to data without retyping. For example I have a colum of 18015555555 and I want to add [rfax:(cell #)@/fn=(phone number)] So I would like to add the brackets - copy from a cell - @/fn= and not loose the data already in the spread sheet. Example 2. Add [rfax:company name@fn/=(saved data here) then close bracket. So I want to add data to cells without loosing the data already in the cells. I have about 600 of them to do and I really don't want to do each one by hand. Please let me know if anyone knows how to accomplish this. Tha...

Removing filters from data
Hi. I have recorded a macro to remove filters from data lasts in advance of performing other actions. However if the data is unfiltered the macro falls over with the message Run time error '1004' ShowAllData method of Worksheet class failed. I think I need some sort of if error continue code or something to check filtering first. I would be grateful if someone could point me in the right direction please. Hi Philip Try If Activesheet.Filtermode Then ActiveSheet.ShowAllData -- Jacob "Philip J Smith" wrote: > Hi. > > I have re...

Looking up and matching data
I have two sets of data with the same information but not in the same order and am trying to match the data. In each data set I have 10 pools containing 100 loans. Each pool has a unique ID and each loan within the applicable pool has an ID of 1 to 100. I need to look up the Pool ID, then look up the loan ID so that I can extract the property type information from a third column. The Pool ID and property type is text but the loan ID is a number. I am struggling to put together the right combination of formulas to give the property type for each loan within each pool. Any suggestion...

invisible listbox data
I have developed software in Acces XP that is distributed to two different locations and I have noticed some odd behaviour at one of the locations. Sometimes the data in listboxes or combo boxes is invisible. The data IS PRESENT because you can select and use the records as before (although you can't see which ones you're selecting). The combo boxes are poplulated and have the correct dropdown length for the records one would expect. The listboxes have scroll bars where one would expect a scrollbar and multiselcetion is possible where apropriate. I have played around with th...

create a letter with the data fron work sheet
i have a data sheet for the people order staff lik tea,coffee...etc,i ve data including date,name,department,.....etc. when i put the data i want a letter format which picks up the data fro the sheet then i can send it to the person who made the order as confirmatino letter. like it the letter starts dear "......"(it could pick the name fro c1) also how can i create this letter? does it have to be in excel ?? help pleaseeeeeeeeeeeeeeeeeeee!!!!!!!!!!:( :( :( : -- Message posted from As answered in microsoft.public.excel and microsoft.public....

excel 2007
I have data that looks something like this account#, invoice amount 1, 50 1, 70 1, 80 2, 10 2, 50 2, 52 2, 50 3, 10 4, 30 I need a way to combine all the invoice totals for each account so I have results like this 1, 200 2, 162 3, 10 4, 30 Any suggestions on how to go about doing this? I thought I had done something similar to this with filters before in Excel 2003, but I can't figure out how I did it. Thanks! You can use subtotal or a pivot table in the pivot put the account numbers in the row field and the invoice amount in the data, in subtotal use at each change in account numb...

Moving certain data to different sheet
I need to move data that meets a certain criteria, to another sheet within a workbook. For instance, if a column of data is for a certain ZIP code area, I need it to automatically copy to a sheet for that city. Say, 40202 would go to the Louisville, KY sheet. Because Louisville has multiple ZIPs, I would need only the data that begins with 402 to go to that sheet. Lexington KY's data, which begins with ZIP code 405, would go to its own sheet. Macro? Formula? Thanks! This can definitely not be created with a formula. I suggest that you make use of the macros. Rgrds, Kris...

HTML Table import
Hi, I have a HTML document which contains a large data of data. When this html file is imported into excel some of the columns get out of whack. eg. Some columns are removed completely. This html renders ok in IE but get corrupted or misread when imported into excel, mainly when the table gets big. eg. It generally happens after the 10000 row mark. Any suggestions? Do you import it through data>import external data>new web query? -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions "Ryan Hafey" <Ryan Hafey@discussion...

Copying of non-consecutive, columnar data into consecutive-columnar cells
Hi: I have data located at a1:a9, then a:10 is blank; then, I have 9 more lines of data from a11:a19, and a20 is blank... a1, a11, a21...are all the texts/numbers that I want printed on a different page. But here's the catch: I'd like to print it at locations a1, a2, a3... Specifically, the data that I have appears like this on THIS IS ON SHEET 1: A1: prefix: Mr A2: emailAddress: A3: firstName: John A4: lastName: Smith A5: company: ABC Company A6: A7: prefix: Mrs A8: emailAddress: A9: firstName: Kim A10: lastName: Davids A11: company: X...

Export Data from MS-CRM
Is there a way to export all of the data from MS-CRM? Thats a rather general question, mean export to another CRM system or just export into another medium? For the most part, most areas have that little excel icon so that you can export into excel...... or you can go into the SQL server and use the export wizard, although I don't think its going to be what you want,....for the most part it will be raw data and you'll have to recreate the relationships and primary fields to see how the objects relate.......... -Gary "John O'Keefe" <