4 Messages
Digest #3001
Messages
Mon Mar 10, 2014 7:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can do something like:
Set wb1 = ActiveWorkbook
For Each oCell In Range("A1:A4")
sTicker = oCell.Value
If sTicker = "" Then Exit For
Workbooks.Open Filename:="
http://www.gurufocus.com/download_dataset.php?symbol=" & sTicker
Sheets("Historical Finacial").Name = sTicker & "-Financial"
Sheets(sTicker & "-Financial").Copy Before:=wb1.Sheets(1)
Windows("download_dataset.php").Close False
Next oCell
On Mon, Mar 10, 2014 at 6:44 PM, <zefiro401k@yahoo.com> wrote:
>
> Thanks Randy but I should have been more specific. Is there a way to make
> the Ticker on the URL change by linking it to a cell in the worksheet?
>
> Example: If Cell A1 is GOOG, then the symbol in the URL automatically
> changes to what ever is in cell A1.
>
Set wb1 = ActiveWorkbook
For Each oCell In Range("A1:A4")
sTicker = oCell.Value
If sTicker = "" Then Exit For
Workbooks.Open Filename:="
http://www.gurufocus.com/download_dataset.php?symbol=" & sTicker
Sheets("Historical Finacial").Name = sTicker & "-Financial"
Sheets(sTicker & "-Financial").Copy Before:=wb1.Sheets(1)
Windows("download_dataset.php").Close False
Next oCell
On Mon, Mar 10, 2014 at 6:44 PM, <zefiro401k@yahoo.com> wrote:
>
> Thanks Randy but I should have been more specific. Is there a way to make
> the Ticker on the URL change by linking it to a cell in the worksheet?
>
> Example: If Cell A1 is GOOG, then the symbol in the URL automatically
> changes to what ever is in cell A1.
>
Mon Mar 10, 2014 10:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Oops...RCHGetYahooQuotes() can grab ex-dividend dates in bulk. Up to 200
per function invocation. However, Yahoo is relatively slow in updating the
ex-dividend dates. But I think it will match element #992 results.
On Mon, Mar 10, 2014 at 3:08 PM, <eric.frahm2@gmail.com> wrote:
>
> I'm monitoring a series of stocks using a smfgetcsvfile function that
> downloads almost everything I need with a single hit off of FinViz.
> Unfortunately, FinViz doesn't seem to provide ex-dividend dates. The only
> method I've found to download ex-dividend dates is to use
> RCHGetElementNumber 992, but that is a very slow process as it downloads
> each item individually. Is there a better solution that I'm missing?
>
>
per function invocation. However, Yahoo is relatively slow in updating the
ex-dividend dates. But I think it will match element #992 results.
On Mon, Mar 10, 2014 at 3:08 PM, <eric.frahm2@gmail.com> wrote:
>
> I'm monitoring a series of stocks using a smfgetcsvfile function that
> downloads almost everything I need with a single hit off of FinViz.
> Unfortunately, FinViz doesn't seem to provide ex-dividend dates. The only
> method I've found to download ex-dividend dates is to use
> RCHGetElementNumber 992, but that is a very slow process as it downloads
> each item individually. Is there a better solution that I'm missing?
>
>
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Templates and Examples/RCHGetTableCell/0-READ-ME.html
Uploaded by : rharmelink <rharmelink@gmail.com>
Description :
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Templates%20and%20Examples/RCHGetTableCell/0-READ-ME.html
To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398
Regards,
rharmelink <rharmelink@gmail.com>
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Templates and Examples/RCHGetTableCell/0-READ-ME.html
Uploaded by : rharmelink <rharmelink@gmail.com>
Description :
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Templates%20and%20Examples/RCHGetTableCell/0-READ-ME.html
To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398
Regards,
rharmelink <rharmelink@gmail.com>
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Templates and Examples/smfGetTagContent/0-READ-ME.html
Uploaded by : rharmelink <rharmelink@gmail.com>
Description :
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Templates%20and%20Examples/smfGetTagContent/0-READ-ME.html
To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398
Regards,
rharmelink <rharmelink@gmail.com>
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Templates and Examples/smfGetTagContent/0-READ-ME.html
Uploaded by : rharmelink <rharmelink@gmail.com>
Description :
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Templates%20and%20Examples/smfGetTagContent/0-READ-ME.html
To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398
Regards,
rharmelink <rharmelink@gmail.com>
Tidak ada komentar:
Posting Komentar