16 New Messages
Digest #2395
Messages
Wed Nov 7, 2012 7:45 am (PST) . Posted by:
"bradk8605" bradk8605
I tried finding the smfgetCSVfile template, do you know what file folder it is in?
Thank you,
Brad
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It looks like Morningstar has made another web page dynamic, so there's no
> data to extract from the source code of the web page.
>
> What I've been suggesting is to load the CSV version of the into a
> worksheet with:
>
> =smfGetCSVFile("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM ")
>
> ...and then get the data you want from there.
>
> On Tue, Nov 6, 2012 at 3:42 PM, bradk8605 <bradk8605@...> wrote:
>
> > I have a spreadsheet that has the Morningstar Key ratio's and it has
> > worked for years but now all of a sudden it doesn't work. Any help would be
> > great.
> >
>
Thank you,
Brad
--- In smf_addin@yahoogrou
>
> It looks like Morningstar has made another web page dynamic, so there's no
> data to extract from the source code of the web page.
>
> What I've been suggesting is to load the CSV version of the into a
> worksheet with:
>
> =smfGetCSVFile(
> http://financials.
>
> ...and then get the data you want from there.
>
> On Tue, Nov 6, 2012 at 3:42 PM, bradk8605 <bradk8605@.
>
> > I have a spreadsheet that has the Morningstar Key ratio's and it has
> > worked for years but now all of a sudden it doesn't work. Any help would be
> > great.
> >
>
Wed Nov 7, 2012 1:18 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It's not a template. I cited a formula.
On Wed, Nov 7, 2012 at 8:45 AM, bradk8605 <bradk8605@yahoo.com > wrote:
> I tried finding the smfgetCSVfile template, do you know what file folder
> it is in?
>
> Thank you,
>
> Brad
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > It looks like Morningstar has made another web page dynamic, so there's
> no
> > data to extract from the source code of the web page.
> >
> > What I've been suggesting is to load the CSV version of the into a
> > worksheet with:
> >
> > =smfGetCSVFile("
> > http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM ")
> >
> > ...and then get the data you want from there.
>
On Wed, Nov 7, 2012 at 8:45 AM, bradk8605 <bradk8605@yahoo.
> I tried finding the smfgetCSVfile template, do you know what file folder
> it is in?
>
> Thank you,
>
> Brad
>
> --- In smf_addin@yahoogrou
> >
> > It looks like Morningstar has made another web page dynamic, so there's
> no
> > data to extract from the source code of the web page.
> >
> > What I've been suggesting is to load the CSV version of the into a
> > worksheet with:
> >
> > =smfGetCSVFile(
> > http://financials.
> >
> > ...and then get the data you want from there.
>
Wed Nov 7, 2012 1:40 pm (PST) . Posted by:
"bradk8605" bradk8605
Thank you for the reply. i tried using the formula and it didn't work for me, I dont know if I did it correctly though. Any help would be much appreciated.
Brad
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It's not a template. I cited a formula.
>
> On Wed, Nov 7, 2012 at 8:45 AM, bradk8605 <bradk8605@...> wrote:
>
> > I tried finding the smfgetCSVfile template, do you know what file folder
> > it is in?
> >
> > Thank you,
> >
> > Brad
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > It looks like Morningstar has made another web page dynamic, so there's
> > no
> > > data to extract from the source code of the web page.
> > >
> > > What I've been suggesting is to load the CSV version of the into a
> > > worksheet with:
> > >
> > > =smfGetCSVFile("
> > > http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM ")
> > >
> > > ...and then get the data you want from there.
> >
>
Brad
--- In smf_addin@yahoogrou
>
> It's not a template. I cited a formula.
>
> On Wed, Nov 7, 2012 at 8:45 AM, bradk8605 <bradk8605@.
>
> > I tried finding the smfgetCSVfile template, do you know what file folder
> > it is in?
> >
> > Thank you,
> >
> > Brad
> >
> > --- In smf_addin@yahoogrou
> > >
> > > It looks like Morningstar has made another web page dynamic, so there's
> > no
> > > data to extract from the source code of the web page.
> > >
> > > What I've been suggesting is to load the CSV version of the into a
> > > worksheet with:
> > >
> > > =smfGetCSVFile(
> > > http://financials.
> > >
> > > ...and then get the data you want from there.
> >
>
Wed Nov 7, 2012 9:15 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Without a description of what "didn't work" means, it's hard to tell you
what to do.
However, I suspect you didn't array-enter it over a range?
On Wed, Nov 7, 2012 at 2:40 PM, bradk8605 <bradk8605@yahoo.com > wrote:
> Thank you for the reply. i tried using the formula and it didn't work for
> me, I dont know if I did it correctly though. Any help would be much
> appreciated.
>
what to do.
However, I suspect you didn't array-enter it over a range?
On Wed, Nov 7, 2012 at 2:40 PM, bradk8605 <bradk8605@yahoo.
> Thank you for the reply. i tried using the formula and it didn't work for
> me, I dont know if I did it correctly though. Any help would be much
> appreciated.
>
Wed Nov 7, 2012 10:02 am (PST) . Posted by:
"lexstar" lexstar
You are correct about SHIFT+F9, manually calculating the Active Worksheet.
What I meant in my previous post was that if I pressed enough times SHIFT+F9, if I'm lucky, I could get the worksheet to download the data. But most of the time, I just get blanks for the date field and 0.0 for the price data fields.
I do not use smfForceRecalc because I have several worksheets and lots of symbols and formulas, and it would take a long long time to go through each worksheet.
--- In smf_addin@yahoogroups.com , Ron Spruell <hashky@...> wrote:
>
> As I understand it <Shift-F9> only recalculates the Active Worksheet. If you already have the needed data stored in Excel, it will NOT retrieve new data from the Internet.
>
> If you have a Worksheet with a single ticker and you change the ticker <Shift-F9> will retrieve the new data from the Internet.
>
>
> I can't double check that right now, because the market is closed.Â
>
>
> SMFForceRecalculation retrieves new data for all open Workbooks.Â
>
>
> I am sure if this is wrong, Randy will correct me.
>
> Ron Spruell
>
>
>
>
>
> >________________________________
> > From: lexstar <lexstar@...>
> >To: smf_addin@yahoogroups.com
> >Sent: Saturday, November 3, 2012 9:17 AM
> >Subject: [smf_addin] Re: smfPricesBetween()
> >
> >
> >Â
> >I haven't tried the immediate smfForceRecalculation yet. But, if I try enough times (many many times) at manual calculation (SHIFT+F9), sometimes it'll work, but then I can't save the file (due to some error msgs).
> >
> >All links are resolved as far as I know.
> >
> >--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >>
> >> Have you tried an immediate smfForceRecalculation? Same results, or does it
> >> then update?
> >>
> >> No unresolved links, right?
> >>
> >> On Fri, Nov 2, 2012 at 8:31 PM, lexstar <lexstar@> wrote:
> >>
> >> > Didn't matter what time of the day it is. I've tried at various times,
> >> > and it still doesn't work.
> >> >
> >> > I just don't get it.
> >> >
> >>
> >
> >
> >
> >
> >
>
What I meant in my previous post was that if I pressed enough times SHIFT+F9, if I'm lucky, I could get the worksheet to download the data. But most of the time, I just get blanks for the date field and 0.0 for the price data fields.
I do not use smfForceRecalc because I have several worksheets and lots of symbols and formulas, and it would take a long long time to go through each worksheet.
--- In smf_addin@yahoogrou
>
> As I understand it <Shift-F9> only recalculates the Active Worksheet. If you already have the needed data stored in Excel, it will NOT retrieve new data from the Internet.
>
> If you have a Worksheet with a single ticker and you change the ticker <Shift-F9> will retrieve the new data from the Internet.
>
>
> I can't double check that right now, because the market is closed.Â
>
>
> SMFForceRecalculati
>
>
> I am sure if this is wrong, Randy will correct me.
>
> Ron Spruell
>
>
>
>
>
> >___________
> > From: lexstar <lexstar@...
> >To: smf_addin@yahoogrou
> >Sent: Saturday, November 3, 2012 9:17 AM
> >Subject: [smf_addin] Re: smfPricesBetween(
> >
> >
> >Â
> >I haven't tried the immediate smfForceRecalculati
> >
> >All links are resolved as far as I know.
> >
> >--- In smf_addin@yahoogrou
> >>
> >> Have you tried an immediate smfForceRecalculati
> >> then update?
> >>
> >> No unresolved links, right?
> >>
> >> On Fri, Nov 2, 2012 at 8:31 PM, lexstar <lexstar@> wrote:
> >>
> >> > Didn't matter what time of the day it is. I've tried at various times,
> >> > and it still doesn't work.
> >> >
> >> > I just don't get it.
> >> >
> >>
> >
> >
> >
> >
> >
>
Wed Nov 7, 2012 10:05 am (PST) . Posted by:
"rex" bios007a
corbanbates <corbanbates@yahoo.com > [2012-11-05 13:11]:
>
>Thank you so much for trying. I have no idea what a VBA process is or anything like that haha so I'll just keep typing everything in manually.
Hello Corban,
The data you want is available as a single 47MB zip file download for
all ~7,000 FDIC banks, or you can create custom reports with only
selected data items (4, in your case) and download as a CSV file which
can be imported into Excel.
If you email me the FDIC #s of the ~500 banks you want, and the data
items you want, I'll look into extracting the desired data and send
you a csv file that you can import into Excel. (CSV because I use
Linux, and don't use any M$ software at all.)
I looked into web scraping the individual reports with R, but for
some reason I've been able to identify, the site:
http://www2.fdic.gov/idasp/StruReportNew.asp?inCert1=31286
drops the connection immediately. Perhaps someone here can spot why
from the dialog:
myurl = "http://www2.fdic.gov/idasp/StruReportNew.asp?inCert1=31286 "
x = getURL(myurl, curl = curl)
* Couldn't find host www2.fdic.gov in the .netrc file; using defaults
* About to connect() to www2.fdic.gov port 80 (#0)
* Trying 192.147.69.44...
* connected
* Connected to www2.fdic.gov (192.147.69.44) port 80 (#0)
GET /idasp/StruReportNew.asp?inCert1=31286 HTTP/1.1
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en - US; rv:1.8.1.6) Gecko/20070725 Firefox/16.0.0.0
Host: www2.fdic.gov
Accept: */*
* additional stuff not fine transfer.c:1037: 0 0
* HTTP 1.1 or later with persistent connection, pipelining supported
< HTTP/1.1 200 OK
< Connection: close
< Date: Tue, 06 Nov 2012 17:43:28 GMT
< Server: Microsoft-IIS/6.0
< X-Powered-By: ASP.NET
< Content-Type: text/html
* Added cookie SetCookie="OK" for domain www2.fdic.gov, path /idasp, expire 0
< Set-Cookie: SetCookie=OK; path=/idasp
* Added cookie ASPSESSIONIDSCSTRRAR="LAEACJGAMAIICEOPCPCDPOOK" for domain www2.fdic.gov, path /, expire 0
< Set-Cookie: ASPSESSIONIDSCSTRRAR=LAEACJGAMAIICEOPCPCDPOOK; path=/
< Cache-control: private
< * nread <= 0, server closed connection, bailing
* Closing connection #0
The text that is returned is:
x
"\r\n\r\n<!-- Security Remediation Project -->\r\n \r\n\t<html>\r\n\t<head>\r\n\t<title>FDIC: Institution Directory<
+/title>\r\n\t</head>\r\n\t<frameset id='myFrameset' frameborder='0' border='0' framespacing='0'
+rows='162,*'>\r\n\t\r\n\t\r\n\t <frame name=\"header\" id=\"Global Navigation Bar\" scrolling=\"no\" noresize
+marginwidth=\"0\" marginheight=\"5\" target=\"content\"
+src=\"Header-report.asp?ReportName=10&ReportDate1=6/30/2012&ReportDate2=6/30/2011&ReportFunction=Inst\">\r\n\t
+<frame name=\"content\" id=\"Financial Report Page\" marginwidth=\"0\" marginheight=\"0\"
+src=\"strureport_blank.asp\">\r\n\t<noframes>\r\n\t <body BGCOLOR=\"white\" text=\"black\">\r\n\t\r\n\t <p>This
+page uses frames, but your browser doesn't support them.</p>\r\n\t\r\n\t <!--</body>-->\r\n\t
+</noframes>\r\n\t</frameset>\r\n\t\r\n\t</body>\r\n</html>\r\n"
So, is the remote server closing the connection because it thinks my
"browser" (R) doesn't support frames? It does, but my best guess is
that the site is expecting something R is not sending that will tell
it my "browser" supports frames.
Any guesses as to what that might be? How do sites determine whether
a visitor's browser supports frames? Does javascript have to be enabled
to support frames?
>
>Thank you so much for trying. I have no idea what a VBA process is or anything like that haha so I'll just keep typing everything in manually.
Hello Corban,
The data you want is available as a single 47MB zip file download for
all ~7,000 FDIC banks, or you can create custom reports with only
selected data items (4, in your case) and download as a CSV file which
can be imported into Excel.
If you email me the FDIC #s of the ~500 banks you want, and the data
items you want, I'll look into extracting the desired data and send
you a csv file that you can import into Excel. (CSV because I use
Linux, and don't use any M$ software at all.)
I looked into web scraping the individual reports with R, but for
some reason I've been able to identify, the site:
http://www2.
drops the connection immediately. Perhaps someone here can spot why
from the dialog:
myurl = "http://www2.
x = getURL(myurl, curl = curl)
* Couldn't find host www2.fdic.gov in the .netrc file; using defaults
* About to connect() to www2.fdic.gov port 80 (#0)
* Trying 192.147.69.44.
* connected
* Connected to www2.fdic.gov (192.147.69.
GET /idasp/StruReportNe
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en - US; rv:1.8.1.6) Gecko/20070725 Firefox/16.0.
Host: www2.fdic.gov
Accept: */*
* additional stuff not fine transfer.c:1037: 0 0
* HTTP 1.1 or later with persistent connection, pipelining supported
< HTTP/1.1 200 OK
< Connection: close
< Date: Tue, 06 Nov 2012 17:43:28 GMT
< Server: Microsoft-IIS/
< X-Powered-By: ASP.NET
< Content-Type: text/html
* Added cookie SetCookie="OK" for domain www2.fdic.gov, path /idasp, expire 0
< Set-Cookie: SetCookie=OK; path=/idasp
* Added cookie ASPSESSIONIDSCSTRRA
< Set-Cookie: ASPSESSIONIDSCSTRRA
< Cache-control: private
< * nread <= 0, server closed connection, bailing
* Closing connection #0
The text that is returned is:
x
"\r\n\r\n<!-
+/title>\r\n\
+rows='162,*
+marginwidth=
+src=\"Header-
+<frame name=\"content\
+src=\"strureport_
+page uses frames, but your browser doesn't support them.</p>\r\
+</noframes>
So, is the remote server closing the connection because it thinks my
"browser" (R) doesn't support frames? It does, but my best guess is
that the site is expecting something R is not sending that will tell
it my "browser" supports frames.
Any guesses as to what that might be? How do sites determine whether
a visitor's browser supports frames? Does javascript have to be enabled
to support frames?
Wed Nov 7, 2012 1:13 pm (PST) . Posted by:
"bozo" calhandon
From what I can tell, using Developer Tools in Firefox to view several
different versions of the page source, yes, the page requires Javascript to
be active in order for the page to be displayed, because this is a
dynamically generated (scripted) page.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of rex
Sent: Wednesday, November 07, 2012 11:04 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: FDIC Data
corbanbates <corbanbates@yahoo.com <mailto:corbanbates%40yahoo.com> >
[2012-11-05 13:11]:
>
>Thank you so much for trying. I have no idea what a VBA process is or
anything like that haha so I'll just keep typing everything in manually.
Hello Corban,
The data you want is available as a single 47MB zip file download for
all ~7,000 FDIC banks, or you can create custom reports with only
selected data items (4, in your case) and download as a CSV file which
can be imported into Excel.
If you email me the FDIC #s of the ~500 banks you want, and the data
items you want, I'll look into extracting the desired data and send
you a csv file that you can import into Excel. (CSV because I use
Linux, and don't use any M$ software at all.)
I looked into web scraping the individual reports with R, but for
some reason I've been able to identify, the site:
http://www2.fdic.gov/idasp/StruReportNew.asp?inCert1=31286
drops the connection immediately. Perhaps someone here can spot why
from the dialog:
myurl = "http://www2.fdic.gov/idasp/StruReportNew.asp?inCert1=31286 "
x = getURL(myurl, curl = curl)
* Couldn't find host www2.fdic.gov in the .netrc file; using defaults
* About to connect() to www2.fdic.gov port 80 (#0)
* Trying 192.147.69.44...
* connected
* Connected to www2.fdic.gov (192.147.69.44) port 80 (#0)
GET /idasp/StruReportNew.asp?inCert1=31286 HTTP/1.1
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en - US; rv:1.8.1.6)
Gecko/20070725 Firefox/16.0.0.0
Host: www2.fdic.gov
Accept: */*
* additional stuff not fine transfer.c:1037: 0 0
* HTTP 1.1 or later with persistent connection, pipelining supported
< HTTP/1.1 200 OK
< Connection: close
< Date: Tue, 06 Nov 2012 17:43:28 GMT
< Server: Microsoft-IIS/6.0
< X-Powered-By: ASP.NET
< Content-Type: text/html
* Added cookie SetCookie="OK" for domain www2.fdic.gov, path /idasp, expire
0
< Set-Cookie: SetCookie=OK; path=/idasp
* Added cookie ASPSESSIONIDSCSTRRAR="LAEACJGAMAIICEOPCPCDPOOK" for domain
www2.fdic.gov, path /, expire 0
< Set-Cookie: ASPSESSIONIDSCSTRRAR=LAEACJGAMAIICEOPCPCDPOOK; path=/
< Cache-control: private
< * nread <= 0, server closed connection, bailing
* Closing connection #0
The text that is returned is:
x
"\r\n\r\n<!-- Security Remediation Project -->\r\n
\r\n\t<html>\r\n\t<head>\r\n\t<title>FDIC: Institution Directory<
+/title>\r\n\t</head>\r\n\t<frameset id='myFrameset' frameborder='0'
border='0' framespacing='0'
+rows='162,*'>\r\n\t\r\n\t\r\n\t <frame name=\"header\" id=\"Global
Navigation Bar\" scrolling=\"no\" noresize
+marginwidth=\"0\" marginheight=\"5\" target=\"content\"
+src=\"Header-report.asp?ReportName=10&ReportDate1=6/30/2012&ReportDate2=6/3
0/2011&ReportFunction=Inst\">\r\n\t
+<frame name=\"content\" id=\"Financial Report Page\" marginwidth=\"0\"
marginheight=\"0\"
+src=\"strureport_blank.asp\">\r\n\t<noframes>\r\n\t <body BGCOLOR=\"white\"
text=\"black\">\r\n\t\r\n\t <p>This
+page uses frames, but your browser doesn't support them.</p>\r\n\t\r\n\t
<!--</body>-->\r\n\t
+</noframes>\r\n\t</frameset>\r\n\t\r\n\t</body>\r\n</html>\r\n"
So, is the remote server closing the connection because it thinks my
"browser" (R) doesn't support frames? It does, but my best guess is
that the site is expecting something R is not sending that will tell
it my "browser" supports frames.
Any guesses as to what that might be? How do sites determine whether
a visitor's browser supports frames? Does javascript have to be enabled
to support frames?
different versions of the page source, yes, the page requires Javascript to
be active in order for the page to be displayed, because this is a
dynamically generated (scripted) page.
From: smf_addin@yahoogrou
Of rex
Sent: Wednesday, November 07, 2012 11:04 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Re: FDIC Data
corbanbates <corbanbates@
[2012-11-05 13:11]:
>
>Thank you so much for trying. I have no idea what a VBA process is or
anything like that haha so I'll just keep typing everything in manually.
Hello Corban,
The data you want is available as a single 47MB zip file download for
all ~7,000 FDIC banks, or you can create custom reports with only
selected data items (4, in your case) and download as a CSV file which
can be imported into Excel.
If you email me the FDIC #s of the ~500 banks you want, and the data
items you want, I'll look into extracting the desired data and send
you a csv file that you can import into Excel. (CSV because I use
Linux, and don't use any M$ software at all.)
I looked into web scraping the individual reports with R, but for
some reason I've been able to identify, the site:
http://www2.
drops the connection immediately. Perhaps someone here can spot why
from the dialog:
myurl = "http://www2.
x = getURL(myurl, curl = curl)
* Couldn't find host www2.fdic.gov in the .netrc file; using defaults
* About to connect() to www2.fdic.gov port 80 (#0)
* Trying 192.147.69.44.
* connected
* Connected to www2.fdic.gov (192.147.69.
GET /idasp/StruReportNe
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en - US; rv:1.8.1.6)
Gecko/20070725 Firefox/16.0.
Host: www2.fdic.gov
Accept: */*
* additional stuff not fine transfer.c:1037: 0 0
* HTTP 1.1 or later with persistent connection, pipelining supported
< HTTP/1.1 200 OK
< Connection: close
< Date: Tue, 06 Nov 2012 17:43:28 GMT
< Server: Microsoft-IIS/
< X-Powered-By: ASP.NET
< Content-Type: text/html
* Added cookie SetCookie="OK" for domain www2.fdic.gov, path /idasp, expire
0
< Set-Cookie: SetCookie=OK; path=/idasp
* Added cookie ASPSESSIONIDSCSTRRA
www2.fdic.gov, path /, expire 0
< Set-Cookie: ASPSESSIONIDSCSTRRA
< Cache-control: private
< * nread <= 0, server closed connection, bailing
* Closing connection #0
The text that is returned is:
x
"\r\n\r\n<!-
\r\n\t<html>
+/title>\r\n\
border='0' framespacing=
+rows='162,*
Navigation Bar\" scrolling=\"
+marginwidth=
+src=\"Header-
0/2011&ReportFuncti
+<frame name=\"content\
marginheight=
+src=\"strureport_
text=\"black\
+page uses frames, but your browser doesn't support them.</p>\r\
<!--</body>-
+</noframes>
So, is the remote server closing the connection because it thinks my
"browser" (R) doesn't support frames? It does, but my best guess is
that the site is expecting something R is not sending that will tell
it my "browser" supports frames.
Any guesses as to what that might be? How do sites determine whether
a visitor's browser supports frames? Does javascript have to be enabled
to support frames?
Wed Nov 7, 2012 1:02 pm (PST) . Posted by:
"José Azevedo" jma_resende
I try and return 13.68
Some one correct them?
Tue Nov 6, 2012 10:22 am (PST) . Posted by: "Thomas Hjort Christensen"
thomas.hjort<thomas.hjort@yahoo.com ?subject=Re%3A%20Incorrect%2052-week%20low%20using%20RCHGetYahooQuotes>
I've noticed that RCHGetYahooQuotes no longer returns the correct 52-week
low stock price.
For instance, RCHGetYahooQuotes(**"HPQ","j"**,,,) returns 16.77 even though
the correct value is 13.68.
If I get the 52-week range using RCHGetYahooQuotes(**"HPQ","w"**,,,) it
returns 16.77-30.00, i.e. the 52-week high is fine.
This used to work. Installing the latest add-in did not fix it. Am I doing
something wrong?
Some one correct them?
Tue Nov 6, 2012 10:22 am (PST) . Posted by: "Thomas Hjort Christensen"
thomas.hjort<thomas.hjort@
I've noticed that RCHGetYahooQuotes no longer returns the correct 52-week
low stock price.
For instance, RCHGetYahooQuotes(
the correct value is 13.68.
If I get the 52-week range using RCHGetYahooQuotes(
returns 16.77-30.00, i.e. the 52-week high is fine.
This used to work. Installing the latest add-in did not fix it. Am I doing
something wrong?
Thu Nov 8, 2012 5:41 am (PST) . Posted by:
"Ron Spruell" hashky
Doug Gerlach wrote a spreadsheet to pull this and a lot of other data (P/E, P/D, FCF) from an .ssg file. You get the .ssg file from betterinvesting.org.
It is a 2-step process, AND you have to subscribe to the betterinvesting.org. The subscription is about $80 per year. It depends on what you are willing to do.
You could also use an array (2 x 2600) and find the max and min for each "calendar" year. It would be close if you used the Adjusted Closing price. To get it accurate, you would have to pull in the Hi and Lo price.
Ron Spruell
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Tuesday, November 6, 2012 12:27 PM
>Subject: Re: [smf_addin] Annual Highs and Lows......
>
>
>
>I think you'd have to use the smfPricesBetween() function for each year..which would be slow going.
>
>I'm not aware of a site that show high and low prices for 10 years. Dividend adjustments might make it problematic.
>
>
>On Tue, Nov 6, 2012 at 8:48 AM, ctouchberry@ymail.com <ctouchberry@ymail.com > wrote:
>
>Is there a way to get the annual high and low for a stock using this add-in? I am currently unable to find a Element Definition that will do this for me. I am looking for historical data that goes back 10 yrs.
>>
>>Thanks in advance for your help.
>>
>
>
>
>
It is a 2-step process, AND you have to subscribe to the betterinvesting.
You could also use an array (2 x 2600) and find the max and min for each "calendar" year. It would be close if you used the Adjusted Closing price. To get it accurate, you would have to pull in the Hi and Lo price.
Ron Spruell
>___________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Tuesday, November 6, 2012 12:27 PM
>Subject: Re: [smf_addin] Annual Highs and Lows......
>
>
>
>I think you'd have to use the smfPricesBetween(
>
>I'm not aware of a site that show high and low prices for 10 years. Dividend adjustments might make it problematic.
>
>
>On Tue, Nov 6, 2012 at 8:48 AM, ctouchberry@
>
>Is there a way to get the annual high and low for a stock using this add-in? I am currently unable to find a Element Definition that will do this for me. I am looking for historical data that goes back 10 yrs.
>>
>>Thanks in advance for your help.
>>
>
>
>
>
Thu Nov 8, 2012 5:48 am (PST) . Posted by:
"Randy Harmelink" rharmelink
At one point, I was considering using the add-in capabilities to create the
SSG files, or expansions of them, instead of querying the Internet directly.
Another option is to get AAII's Stock Investor Pro screening software. Each
weekly update has updated SSG files available.
On Thu, Nov 8, 2012 at 6:41 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
> Doug Gerlach wrote a spreadsheet to pull this and a lot of other data (P/E,
> P/D, FCF) from an .ssg file. You get the .ssg file from
> betterinvesting.org.
>
> It is a 2-step process, AND you have to subscribe to the
> betterinvesting.org. The subscription is about $80 per year. It
> depends on what you are willing to do.
>
> You could also use an array (2 x 2600) and find the max and min for each
> "calendar" year. It would be close if you used the Adjusted Closing
> price. To get it accurate, you would have to pull in the Hi and Lo price.
>
SSG files, or expansions of them, instead of querying the Internet directly.
Another option is to get AAII's Stock Investor Pro screening software. Each
weekly update has updated SSG files available.
On Thu, Nov 8, 2012 at 6:41 AM, Ron Spruell <hashky@yahoo.
>
> Doug Gerlach wrote a spreadsheet to pull this and a lot of other data (P/E,
> P/D, FCF) from an .ssg file. You get the .ssg file from
> betterinvesting.
>
> It is a 2-step process, AND you have to subscribe to the
> betterinvesting.
> depends on what you are willing to do.
>
> You could also use an array (2 x 2600) and find the max and min for each
> "calendar" year. It would be close if you used the Adjusted Closing
> price. To get it accurate, you would have to pull in the Hi and Lo price.
>
Thu Nov 8, 2012 6:44 am (PST) . Posted by:
"Ron Spruell" hashky
The daily high and low prices are also available from marketbrowser (free) software. Marketbrowser.com. It is quick, but it is a cut and paste.
The latest software Toolkit6, from IClub (stockcentral.com), is a quick way to look at fundamental data and charts. I use it regularly. I have never used the Stock Investor Pro, but I have heard it is very good and more versatile, and slightly more expensive.
Randy, you must be a masochist if you want to duplicate something that is available for a reasonable price for a bunch of freeloaders (me included).
What I like about the addin is that if I can get my initial screen to less than 200 stocks, then I can slice it and dice it in Excel to my hart's content.
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Thursday, November 8, 2012 7:48 AM
>Subject: Re: [smf_addin] Annual Highs and Lows......
>
>
>
>At one point, I was considering using the add-in capabilities to create the SSG files, or expansions of them, instead of querying the Internet directly.
>
>Another option is to get AAII's Stock Investor Pro screening software. Each weekly update has updated SSG files available.
>
>
>On Thu, Nov 8, 2012 at 6:41 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
>
>>
>>Doug Gerlach wrote a spreadsheet to pull this and a lot of other data (P/E, P/D, FCF) from an .ssg file. You get the .ssg file from betterinvesting.org.
>>
>>
>>
>>It is a 2-step process, AND you have to subscribe to the betterinvesting.org. The subscription is about $80 per year. It depends on what you are willing to do.
>>
>>
>>You could also use an array (2 x 2600) and find the max and min for each "calendar" year. It would be close if you used the Adjusted Closing price. To get it accurate, you would have to pull in the Hi and Lo price.
>>
>
>
>
>
The latest software Toolkit6, from IClub (stockcentral.
Randy, you must be a masochist if you want to duplicate something that is available for a reasonable price for a bunch of freeloaders (me included).
What I like about the addin is that if I can get my initial screen to less than 200 stocks, then I can slice it and dice it in Excel to my hart's content.
>___________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Thursday, November 8, 2012 7:48 AM
>Subject: Re: [smf_addin] Annual Highs and Lows......
>
>
>
>At one point, I was considering using the add-in capabilities to create the SSG files, or expansions of them, instead of querying the Internet directly.
>
>Another option is to get AAII's Stock Investor Pro screening software. Each weekly update has updated SSG files available.
>
>
>On Thu, Nov 8, 2012 at 6:41 AM, Ron Spruell <hashky@yahoo.
>
>
>>
>>Doug Gerlach wrote a spreadsheet to pull this and a lot of other data (P/E, P/D, FCF) from an .ssg file. You get the .ssg file from betterinvesting.
>>
>>
>>
>>It is a 2-step process, AND you have to subscribe to the betterinvesting.
>>
>>
>>You could also use an array (2 x 2600) and find the max and min for each "calendar" year. It would be close if you used the Adjusted Closing price. To get it accurate, you would have to pull in the Hi and Lo price.
>>
>
>
>
>
Thu Nov 8, 2012 8:34 pm (PST) . Posted by:
"excelforfun" excelforfun
Hi! I got serious problem with functionality of add-in. I just add this tool and tried to use =RCHGetYahooHistory("msft") with Shift & Ctrl & Enter as matrix. But instead of appropriate data set it uploaded this:
Date Open High Low Close Volume Adj Close
41220
According to this result I see, that function is recognized by Excel and it works but the output is not relevant. Has anyone ever fixed that kind of problem?
Thx for advices!
Peter
Date Open High Low Close Volume Adj Close
41220
According to this result I see, that function is recognized by Excel and it works but the output is not relevant. Has anyone ever fixed that kind of problem?
Thx for advices!
Peter
Fri Nov 9, 2012 2:44 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Do you have your regional settings set to United States?
On Thu, Nov 8, 2012 at 3:41 PM, excelforfun <pheo@azet.sk> wrote:
> Hi! I got serious problem with functionality of add-in. I just add this
> tool and tried to use =RCHGetYahooHistory("msft") with Shift & Ctrl & Enter
> as matrix. But instead of appropriate data set it uploaded this:
>
> Date Open High Low Close Volume Adj Close
> 41220
>
>
> According to this result I see, that function is recognized by Excel and
> it works but the output is not relevant. Has anyone ever fixed that kind of
> problem?
>
On Thu, Nov 8, 2012 at 3:41 PM, excelforfun <pheo@azet.sk> wrote:
> Hi! I got serious problem with functionality of add-in. I just add this
> tool and tried to use =RCHGetYahooHistory
> as matrix. But instead of appropriate data set it uploaded this:
>
> Date Open High Low Close Volume Adj Close
> 41220
>
>
> According to this result I see, that function is recognized by Excel and
> it works but the output is not relevant. Has anyone ever fixed that kind of
> problem?
>
Fri Nov 9, 2012 12:51 pm (PST) . Posted by:
"excelforfun" excelforfun
How can I find out that information? I just downloaded .RAR folder, created special SMF add in folder and place content from RAR into that folder and searched that by options- (tick Stock market functions) in Excel.
Fri Nov 9, 2012 8:28 am (PST) . Posted by:
"KailuaKid" garyhartling
I'm using datacode "r1" to retrieve the "Dividend Pay Date" with RCHGetYahooQuotes but, in most cases, it displays "N/A". Anyone know what happened?
Thx,
Gary
Thx,
Gary
Fri Nov 9, 2012 8:43 am (PST) . Posted by:
"Randy Harmelink" rharmelink
"N/A" is what Yahoo is populating the field with. Hopefully, temporarily.
On Fri, Nov 9, 2012 at 9:28 AM, KailuaKid <Gary.Hartling@gmail.com > wrote:
> I'm using datacode "r1" to retrieve the "Dividend Pay Date" with
> RCHGetYahooQuotes but, in most cases, it displays "N/A". Anyone know what
> happened?
>
On Fri, Nov 9, 2012 at 9:28 AM, KailuaKid <Gary.Hartling@
> I'm using datacode "r1" to retrieve the "Dividend Pay Date" with
> RCHGetYahooQuotes but, in most cases, it displays "N/A". Anyone know what
> happened?
>
Tidak ada komentar:
Posting Komentar