Messages In This Digest (14 Messages)
- 1a.
- SMFForceRecalculation From: Ron Spruell
- 1b.
- Re: SMFForceRecalculation From: adam pilz
- 1c.
- Re: SMFForceRecalculation From: Randy Harmelink
- 1d.
- Re: SMFForceRecalculation From: Randy Harmelink
- 2a.
- IPO Date information From: curls07
- 2b.
- Re: IPO Date information From: Ron Spruell
- 2c.
- Re: IPO Date information From: Randy Harmelink
- 3a.
- Re: Why isn't it signed in? From: chaim422
- 3b.
- Re: Why isn't it signed in? From: Randy Harmelink
- 3c.
- Re: Why isn't it signed in? From: chaim422
- 3d.
- Re: Why isn't it signed in? From: Randy Harmelink
- 3e.
- Re: Why isn't it signed in? From: chaim422
- 4a.
- Investors.com From: Thomas S
- 4b.
- Re: Investors.com From: Randy Harmelink
Messages
- 1a.
-
SMFForceRecalculation
Posted by: "Ron Spruell" hashky@yahoo.com hashky
Thu Oct 27, 2011 7:01 am (PDT)
Randy -
I added this macro to my Quick Access Toolbar. My question is how do you use it? Do you make it part of your Personal.xls, or do you apply it on a workbook by workbook basis?
Is there a way to have it either/or? Calculate all open workbooks or calculate just the active workbook? How do you use it?
Ron
- 1b.
-
Re: SMFForceRecalculation
Posted by: "adam pilz" adampilz.2326@gmail.com pilzadam
Thu Oct 27, 2011 8:11 am (PDT)
Randy,
Yes I am have questions about this also. When trying to update the element
numbers I did the "Alt-F8" step and typed in "smfForceRecalculation." I
seemed like something was working but the new element numbers did not
update and the google spreadsheets are still reporting "error" in the
cells. Any info? (of course please answer Ron's questions first)
Thanks so much
Adam
On Thu, Oct 27, 2011 at 10:01 AM, Ron Spruell <hashky@yahoo.com > wrote:
> **
>
>
> Randy -
>
> I added this macro to my Quick Access Toolbar. My question is how do you
> use it? Do you make it part of your Personal.xls, or do you apply it on a
> workbook by workbook basis?
>
> Is there a way to have it either/or? Calculate all open workbooks or
> calculate just the active workbook? How do you use it?
>
> Ron
>
>
>
- 1c.
-
Re: SMFForceRecalculation
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Oct 27, 2011 8:42 am (PDT)
I just click on the button whenever I want to "reset" the add-in, and get
rid of all saved web pages. It's part of the add-in, so it should always be
available. I rarely have more than one workbook open, so I almost always run
it in between closing one workbook and opening the next.
It would do all workbooks, since all add-in web pages are purged. There's
nothing in them to indicate which workbook they are part of.
On Thu, Oct 27, 2011 at 7:01 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
> I added this macro to my Quick Access Toolbar. My question is how do you
> use it? Do you make it part of your Personal.xls, or do you apply it on a
> workbook by workbook basis?
>
> Is there a way to have it either/or? Calculate all open workbooks or
> calculate just the active workbook? How do you use it?
>
>
- 1d.
-
Re: SMFForceRecalculation
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Oct 27, 2011 8:48 am (PDT)
For the Google issue, you may need the new element definitions from the
"Works in Progress" folder. Otherwise, the errors may be caused by the
ticker symbols you're going after. Without more details, it's impossible for
me to say.
One diagnostic function I have is:
=smfGetAParms(951)
...which would tell you the definition of element #951, so you could check
to see what is loaded. In my case:
YahooKS;Most Recent Quarter;
http://finance.yahoo.com/ HIGHLIGHTS;MOST RECENTq/ks?s=~~ ~~~;1;FINANCIAL
QUARTER; ; ;0;0;0;0
On Thu, Oct 27, 2011 at 8:11 AM, adam pilz <adampilz.2326@gmail.com > wrote:
>
> Yes I am have questions about this also. When trying to update the element
> numbers I did the "Alt-F8" step and typed in "smfForceRecalculation." I
> seemed like something was working but the new element numbers did not update
> and the google spreadsheets are still reporting "error" in the cells. Any
> info? (of course please answer Ron's questions first)
>
- 2a.
-
IPO Date information
Posted by: "curls07" agc11d@gmail.com curls07
Thu Oct 27, 2011 7:43 am (PDT)
Hi,
I'm doing some IPO research and I'm looking to get the first day of trading from some companies that don't easily list their IPO date. Does anyone have any ideas on how I could turn a url like this into my own element; http://finance.yahoo.com/ q/hp?s=HSOL& d=9&e=27& f=2011&g= d&a=11&b= 20&c=2006& z=66&y=1188
so that i can extract the first date of trading as the IPO date.
or Does anyone have any better ideas on how to get the job done?
Im all ears!
Also, I have looked through edgar and edgar's ipo online search, but it is not an efficent way to gather information for a large sample size.
Thanks in advance guys!
- 2b.
-
Re: IPO Date information
Posted by: "Ron Spruell" hashky@yahoo.com hashky
Thu Oct 27, 2011 7:54 am (PDT)
=RCHGetYahooHistory($A$6,YEAR( Main!$G$2- 4565),MONTH( Main!$G$2- 4565),DAY( Main!$G$2- 4565),YEAR( Main!$G$2) ,MONTH(Main! $G$2),DAY( Main!$G$2) ,"w","DA" ,,,1)
$A$6 = Ticker Symbol
Main!$G$2 = Date of Previous Close (or you could use TODAY())
For Date of the Previous Close I use =RCHGetYahooHistory("SPY",,, ,,,,,,0)
Change the 4562 to the number of days you want, say 2. That should give you the first entry in Yahoo History (with labels).
Ron
>____________________ _________ ___
>From: curls07 <agc11d@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Thursday, October 27, 2011 9:43 AM
>Subject: [smf_addin] IPO Date information
>
>
>
>Hi,
>
>I'm doing some IPO research and I'm looking to get the first day of trading from some companies that don't easily list their IPO date. Does anyone have any ideas on how I could turn a url like this into my own element; http://finance.yahoo.com/ q/hp?s=HSOL& d=9&e=27& f=2011&g= d&a=11&b= 20&c=2006& z=66&y=1188
>
>so that i can extract the first date of trading as the IPO date.
>
>or Does anyone have any better ideas on how to get the job done?
>
>Im all ears!
>
>Also, I have looked through edgar and edgar's ipo online search, but it is not an efficent way to gather information for a large sample size.
>
>Thanks in advance guys!
>
>
>
>
> - 2c.
-
Re: IPO Date information
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Oct 27, 2011 8:55 am (PDT)
I think this would get you the date of the first trading date from Yahoo's
historical quotes:
=RCHGetYahooHistory("MMM",,, ,,,,"m"," D",0,,1,600, 1)
On Thu, Oct 27, 2011 at 7:43 AM, curls07 <agc11d@gmail.com > wrote:
>
> I'm doing some IPO research and I'm looking to get the first day of trading
> from some companies that don't easily list their IPO date. Does anyone have
> any ideas on how I could turn a url like this into my own element;
> http://finance.yahoo.com/ q/hp?s=HSOL& d=9&e=27& f=2011&g= d&a=11&b= 20&c=2006& z=66&y=1188
>
> so that i can extract the first date of trading as the IPO date.
>
> or Does anyone have any better ideas on how to get the job done?
>
- 3a.
-
Re: Why isn't it signed in?
Posted by: "chaim422" chaim422@gmail.com chaim422
Thu Oct 27, 2011 11:04 am (PDT)
Thanks Randy. I don't know how I overlooked such an obvious solution. I'm sorry if my next question has an obvious answer too but I am trying for hours to make it work without success yet.
RCHGetTableCell(A7,0,"LOG: ") returns Error. (I am trying to get the cell starting with "LOG:") The table in the HTML source is as follows:
<table>
<tr>
<td>
<img src="/images/tmp/366066_ 8132.png" width=500 height=500 style="border: none">
</td>
</tr>
<tr>
<td>
<br/>
NOTE: Dividends and transaction costs are not included. The positions in each 'bucket' are equally weighted regardless of market cap.
</td>
</tr>
<tr><td> </td></tr>
<tr>
<td style="font-size:11px; color:#999"> <br/><br/ >LOG: Processing 10/23/2010 11/20/2010 12/18/2010 01/15/2011 02/12/2011 03/12/2011 04/09/2011 05/07/2011 06/04/2011 07/02/2011 07/30/2011 08/27/2011 09/24/2011
RETURNS: 4.8 -11.6 -1.8 -6.4 -0.9 -4.2 5.3 -1.1 3.1 -2.1 1.9 0.6 2.7 4.5 7.0 5.0 1.4 0.3 10.1 7.3 6.5
</td>
</tr>
</table>
Thanks for your help!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> See the "Links" area of the group for information on the macro...
>
> On Thu, Oct 27, 2011 at 2:56 AM, savantllc <savantllc@...> wrote:
>
> >
> > How di I run smfForceRecalculation?
> >
>
- 3b.
-
Re: Why isn't it signed in?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Oct 27, 2011 11:12 am (PDT)
The first thing I would look for is to see if "Log:" shows up earlier on the
web page somewhere. Secondly, to see if it's actually delivered within the
source code of the web page, or placed there dynamically.
On Thu, Oct 27, 2011 at 11:04 AM, chaim422 <chaim422@gmail.com > wrote:
> Thanks Randy. I don't know how I overlooked such an obvious solution. I'm
> sorry if my next question has an obvious answer too but I am trying for
> hours to make it work without success yet.
>
> RCHGetTableCell(A7,0,"LOG: ") returns Error. (I am trying to get the cell
> starting with "LOG:") The table in the HTML source is as follows:
>
> <table>
>
> <tr>
> <td>
> <img
> src="/images/tmp/366066_ 8132.png" width=500 height=500 style="border: none">
> </td>
> </tr>
> <tr>
> <td>
> <br/>
> NOTE: Dividends and
> transaction costs are not included. The positions in each 'bucket' are
> equally weighted regardless of market cap.
>
> </td>
>
> </tr>
> <tr><td> </td></tr>
> <tr>
> <td style="font-size:11px;
> color:#999"><br/><br/ >LOG: Processing 10/23/2010 11/20/2010 12/18/2010
> 01/15/2011 02/12/2011 03/12/2011 04/09/2011 05/07/2011 06/04/2011
> 07/02/2011 07/30/2011 08/27/2011 09/24/2011
> RETURNS: 4.8 -11.6 -1.8 -6.4 -0.9
> -4.2 5.3 -1.1 3.1 -2.1 1.9 0.6 2.7 4.5 7.0 5.0 1.4 0.3 10.1 7.3 6.5
> </td>
> </tr>
> </table>
>
> Thanks for your help!
>
- 3c.
-
Re: Why isn't it signed in?
Posted by: "chaim422" chaim422@gmail.com chaim422
Thu Oct 27, 2011 11:13 am (PDT)
I think that I might have found the problem. This page does a calculation which takes about 10 seconds. During this process it shows a status bar that keeps changing. It seems that the functions return the web page during the first few seconds of the calculation before it's finished. Does that make sense? Is there a workaround?
Thanks!
--- In smf_addin@yahoogroups.com , "chaim422" <chaim422@...> wrote:
>
> Thanks Randy. I don't know how I overlooked such an obvious solution. I'm sorry if my next question has an obvious answer too but I am trying for hours to make it work without success yet.
>
> RCHGetTableCell(A7,0,"LOG: ") returns Error. (I am trying to get the cell starting with "LOG:") The table in the HTML source is as follows:
>
> <table>
>
> <tr>
> <td>
> <img src="/images/tmp/366066_ 8132.png" width=500 height=500 style="border: none">
> </td>
> </tr>
> <tr>
> <td>
> <br/>
> NOTE: Dividends and transaction costs are not included. The positions in each 'bucket' are equally weighted regardless of market cap.
>
> </td>
>
> </tr>
> <tr><td> </td></tr>
> <tr>
> <td style="font-size:11px; color:#999"> <br/><br/ >LOG: Processing 10/23/2010 11/20/2010 12/18/2010 01/15/2011 02/12/2011 03/12/2011 04/09/2011 05/07/2011 06/04/2011 07/02/2011 07/30/2011 08/27/2011 09/24/2011
> RETURNS: 4.8 -11.6 -1.8 -6.4 -0.9 -4.2 5.3 -1.1 3.1 -2.1 1.9 0.6 2.7 4.5 7.0 5.0 1.4 0.3 10.1 7.3 6.5
> </td>
> </tr>
> </table>
>
> Thanks for your help!
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > See the "Links" area of the group for information on the macro...
> >
> > On Thu, Oct 27, 2011 at 2:56 AM, savantllc <savantllc@> wrote:
> >
> > >
> > > How di I run smfForceRecalculation?
> > >
> >
>
- 3d.
-
Re: Why isn't it signed in?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Oct 27, 2011 11:20 am (PDT)
Sounds like it is dynamically filling in the data -- if so, the data
probably isn't available to the add-in, since it extract data from the
source code of the originally delivered web page. Sometimes, a workaround is
that the data is available within some JavaScript used by the page, but that
probably won't be the case if it is doing calculations instead of simply
building the page.
I sometimes use an exploratory function to see what is there, something
like:
=smfGetTagContent(...URL... ,"table", 1)
...and simply increment the 1 in successive functions. That will get me the
source code within each HTML table on the page. Or, I can use "tr" instead
of "table" to get each successive HTML table row. Then, simply see if the
data you want is there.
On Thu, Oct 27, 2011 at 11:13 AM, chaim422 <chaim422@gmail.com > wrote:
> I think that I might have found the problem. This page does a calculation
> which takes about 10 seconds. During this process it shows a status bar that
> keeps changing. It seems that the functions return the web page during the
> first few seconds of the calculation before it's finished. Does that make
> sense? Is there a workaround?
>
- 3e.
-
Re: Why isn't it signed in?
Posted by: "chaim422" chaim422@gmail.com chaim422
Thu Oct 27, 2011 11:44 am (PDT)
That's right Randy. I checked in Excel and the data is not there yet. Also, when I pressed Control+U in FireFox after the calculation was finished the table showed up, but when I pressed Control+U while it was in progress the table wasn't there. I guess that means that it is dynamically filling in the data. Is there any workaround that I could do? If there is no other way I may even be desperate enough to try to write the code myself. What do you think?
Thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Sounds like it is dynamically filling in the data -- if so, the data
> probably isn't available to the add-in, since it extract data from the
> source code of the originally delivered web page. Sometimes, a workaround is
> that the data is available within some JavaScript used by the page, but that
> probably won't be the case if it is doing calculations instead of simply
> building the page.
>
> I sometimes use an exploratory function to see what is there, something
> like:
>
> =smfGetTagContent(...URL... ,"table", 1)
>
> ...and simply increment the 1 in successive functions. That will get me the
> source code within each HTML table on the page. Or, I can use "tr" instead
> of "table" to get each successive HTML table row. Then, simply see if the
> data you want is there.
>
> On Thu, Oct 27, 2011 at 11:13 AM, chaim422 <chaim422@...> wrote:
>
> > I think that I might have found the problem. This page does a calculation
> > which takes about 10 seconds. During this process it shows a status bar that
> > keeps changing. It seems that the functions return the web page during the
> > first few seconds of the calculation before it's finished. Does that make
> > sense? Is there a workaround?
> >
>
- 4a.
-
Investors.com
Posted by: "Thomas S" mrtomschu@gmail.com mrtomschu
Thu Oct 27, 2011 6:38 pm (PDT)
I have the SMF add-in on three different and seperate computers and I am unable to get data from IBD on any of them. I didn't have this problem yesterday. I've tried Force Recalc to no avail. Any ideas???
- 4b.
-
Re: Investors.com
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Oct 27, 2011 6:50 pm (PDT)
Two issues:
1. They currently have a pop-up ad and a redirection on your first visit
to the web site, so you'll need to use IE or the EXCEL Web Query process to
visit the site and create cookies that will clear out that processing.
2. They've changed the URL structure, from:
http://www.investors.com/StockResea rch/StockCheckup .aspx?symbol=
http://www.investors.com/StockResea rch/Quote. aspx?symbol=
...to:
http://research.investors. com/StockCheckup .aspx?symbol=
http://research.investors. com/Quote. aspx?symbol=
On Thu, Oct 27, 2011 at 6:38 PM, Thomas S <mrtomschu@gmail.com > wrote:
> I have the SMF add-in on three different and seperate computers and I am
> unable to get data from IBD on any of them. I didn't have this problem
> yesterday. I've tried Force Recalc to no avail. Any ideas???
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar