Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stock query can't pull more than 10 years of data
Hello!
I'm not sure where I should ask this, but thought I'd try here to see if anyone knows what's up. My spreadsheet has always been able to pull down 30 years of monthly data (if available) using MSN's stock quote addin. Just recently, I started getting errors and the spreadsheet would bomb on the query itself. So I went to MSN to verify that the data was there and, lo and behold, no you can no longer retrieve more than 10 years of data. Does anyone know if this is a permanent change from MSN or if they have a problem? It's been about 2 weeks at least now. When you're on one of those chart pages, at the bottom there's a contact us link that really is a little questionnaire. I've filled it out 2x and asked about this in the comments section and given my email address, but nobody's gotten back to me and I'm doubting they will. So ... anybody? Or if you know of a better place to post this question, I'd be happy to take it there. I'd like to know if it's permanent before recoding my spreadsheet! Thanks! Kathy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stock query can't pull more than 10 years of data
Hello Don!
I have been there! Randy Harmelink told me about it at the Motley Fool. I believe MSN's data is not dividend ajusted while Yahoo's is. Actually, I wouldn't mind having both, but I don't want to play with the sheet right now if I don't have to because I'm in the middle of another project and don't have a lot of time. If I have to change over I will, but I'd rather have MSN give us back access to a longer history! Thanks, Kathy On Mar 17, 6:07 pm, "Don Guillett" wrote: You can goto the yahoo xltraders group and download my free file or ask me, OFF LIST, and I will send a copy. It does what you want using Yahoo and even graphs it. GetYahooMultipleHistory97a -- Don Guillett SalesAid Software "KathyC" wrote in message ups.com... Hello! I'm not sure where I should ask this, but thought I'd try here to see if anyone knows what's up. My spreadsheet has always been able to pull down 30 years of monthly data (if available) using MSN's stock quote addin. Just recently, I started getting errors and the spreadsheet would bomb on the query itself. So I went to MSN to verify that the data was there and, lo and behold, no you can no longer retrieve more than 10 years of data. Does anyone know if this is a permanent change from MSN or if they have a problem? It's been about 2 weeks at least now. When you're on one of those chart pages, at the bottom there's a contact us link that really is a little questionnaire. I've filled it out 2x and asked about this in the comments section and given my email address, but nobody's gotten back to me and I'm doubting they will. So ... anybody? Or if you know of a better place to post this question, I'd be happy to take it there. I'd like to know if it's permanent before recoding my spreadsheet! Thanks! Kathy |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stock query can't pull more than 10 years of data
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stock query can't pull more than 10 years of data
Thanks for trying Don......
Kathy On Mar 17, 8:14 pm, "Don Guillett" wrote: I tried to send it direct to you but got the "added to list" which I DON'T do. -- Don Guillett SalesAid Software "KathyC" wrote in message |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull parameter from worksheet for External Data Query to SQL Datab | Excel Discussion (Misc queries) | |||
Web query to create historical stock data | New Users to Excel | |||
Query to MSN Stock Scouter | Excel Worksheet Functions | |||
Web Query With Multiple Stock Symbols & Stock Scouter | Excel Worksheet Functions | |||
Overlay 4 years of data as a line on 4 years of columns for several x category labels | Charts and Charting in Excel |