|
PureBytes Links
Trading Reference Links
|
Dear Markumansky,
Step 1.
I assume that you are familiar with Excel. If not, then you need to learn to use Excel first.
Open an Excel spreadsheet and go to: Data | Import External Data | New Web Query
If you have Excel 2002 or later version, then in the Address input box you should see: http://www.msn.com/
Change this to the URL of whatever you want to use as your data source, for example www.finance.yahoo.com
and then click "Go". If you are connected to the Internet, you will then see the web page on the small screen.
Whatever you see on that small window, you can then import directly to Excel.
So, if you went to Yahoo Finance Home, enter a stock symbol & "Get Quotes" and see the stock data in the small window.
When the web page has been downloaded, just click the "Import" button.
Excel asks what cell in the spreadsheet you want the data imported into.
Select somewhere (e.g. "A1") and click OK.
The spreadsheet now contains, in text format, all of the text data from the web page that you were looking at. Very nice.
You now have the main building block for a downloader for anything you want
... prices, fundamental data, whatever.... all for free !! The only thing you have to do now is to automate it so don't have to keep pressing buttons each time for each stock.
Step 2.
Once you have Step 1 working OK, then:
Excel | Tools | Macro | Record New Macro ... OK.
Now repeat Step 1, but this time you are recording everything as an Excel macro.
When the download from Step 1 is complete, stop the Excel macro recorder.
Go to Excel Tool | Macro Visual Basic Editor
You can now see the Excel VBA code that was used to perform everything from Step 1. The code is very short.
In the line that starts "URL; you will see the URL that you chose, and also the symbol of the stock that you chose.
If you are using Yahoo, this will be (for example):
"URL;http://finance.yahoo.com/q?s=mot"; (if, for example the stock you were looking at was MOT).
Now you can either change the stock symbol if you want more of the same sort of data, or change the URL if
you want data from somewhere else. With some simple programming (DO loops) you can now set this up.
Step 3.
If you can already write VBA code for Excel, the next part is straightforward programming (even for me, and I am not a programmer). And if you don't know VBA, its easy to learn - either use the online tutorials from the Microsoft website, or get a beginners book on Visual Basic for Applications. (Note that you do NOT need to learn the full version of Visual Basic, but only VBA for Excel). If you can already do some simple programming, then one of your friends who knows VBA should be able to show you enough in about an hour so that you can get started with the rest of this step).
Replace the stock symbol with a variable, and then write VBA code to create a (DO or FOR or WHILE) loop containing a list of whatever stock symbols you want, use the variable to successively input the items from your stock symbol list one by one, and add instructions of where you want to write the results out to. And basically that's your downloader. It runs like any other macro in Excel.
Tip: If I remember correctly, I think that when you try to download stock
price data from Yahoo and you want to do it in blocks of a number of
stocks at a time, there is a limit of about 200 stock symbols per
block. It's not much of a problem, but useful to know about it in
advance so that you don't get frustrated when your block of 220 stock
symbols won't download properly!
I made and used a downloader like this for a few years before I bought Metastock. (THat was when I tried to do everythingin Excel). Nowadays I prefer to get good quality price data for Metastock from a daily data subscription service, but I still use my Excel "free downloader" for automated downloading of a whole range of other sharemarket data, fundamentals of all kinds, etc. Very useful.
The only thing it costs is the time to learn to write a couple of DO loops in VBA for Excel. And that's a great investment for anyone serious about trading ! Getting data is easy. Figuring out what to do with it after that is the harder part :-))
Best wishes,
Tony M.
==================================
----- Original Message ----
From: markumansky <no_reply@xxxxxxxxxxxxxxx>
To: equismetastock@xxxxxxxxxxxxxxx
Sent: Tuesday, June 5, 2007 1:56:08 AM
Subject: [EquisMetaStock Group] Re: Yahoo Prices
How??
--- In equismetastock@ yahoogroups. com, Tony M <t4tonym@xxx > wrote:
>
>
> You can download stock prices & other data fairly easily into Excel
for free,
> and then from Excel to Metastock, if that is a useful alternative
for you.
>
> Tony M
>
> ----- Original Message ----
> From: ptc_man3 <ptc_man3@xx .>
> To: equismetastock@ yahoogroups. com
> Sent: Monday, June 4, 2007 10:27:21 PM
> Subject: [EquisMetaStock Group] Re: Yahoo Prices for free?
>
>
>
> I'm sure that there are some free programs that do that but the only
>
> one I know and use is MLDownloader but you need to pay for it. It's
>
> not expensive, I think it's around $50. I bought mine a couple of
>
> years ago so I really can't be sure.
>
>
>
> regards
>
>
>
> --- In equismetastock@ yahoogroups. com, markumansky <no_reply@ .>
wrote:
>
> >
>
> > Does anyone know how to download yahoo stock prices into MS9 for free?
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a {
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc {
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
-->
____________________________________________________________________________________
Pinpoint customers who are looking for what you sell.
http://searchmarketing.yahoo.com/
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/equismetastock/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/equismetastock/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:equismetastock-digest@xxxxxxxxxxxxxxx
mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|