Minggu, 05 Februari 2012

[smf_addin] Digest Number 2105

Messages In This Digest (25 Messages)

Messages

1a.

Historical Market Cap

Posted by: "prabhakar_karri" prabhakar_karri@yahoo.com   prabhakar_karri

Sun Feb 5, 2012 6:05 am (PST)



Hi,
Is there a way to get historical market cap for a given ticker? For instance, market cap of MMM on Jan 1 2012; Jan 1, 2011; etc.

Appreciate any pointers on this.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.

Re: Historical Market Cap

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Sun Feb 5, 2012 6:35 am (PST)



AdvFN has historical financial statements (GetAdvFNelement). Yahoo has
historical pricing (GetYahooHistory).

Use the share total from the quarterly financial multiplied by the price for
that period and you'll have a pretty good approximation.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of prabhakar_karri
Sent: Sunday, February 05, 2012 8:31 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Historical Market Cap

Hi,
Is there a way to get historical market cap for a given ticker? For
instance, market cap of MMM on Jan 1 2012; Jan 1, 2011; etc.

Appreciate any pointers on this.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

Re: hi

Posted by: "leif_85" gondoliere2@web.de   leif_85

Sun Feb 5, 2012 8:48 am (PST)



Hi Randy, Don and all,

I downloaded the latest patches for my immemoreal Excel 97, SR 2a and two minor ones and tried to run smf-addin then, to no avail. It seems it gets loaded, as it shows up in the list and is ticked off. Yet after a restart it is gone. When loading it in VB for a test, errors are coming up concerning the „Split" function for instance.

Don advised me to buy Office version 2003, as this being most similar to mine. Randy mentioned compatibility problems with foreign language versions relating to number format and - I bet - also date format.. ( BTW I have to use a foreign version XP operation system.)

I read, that versions 2003 and 2010 got a MUI (multilingual user interface). Does someone know, if those compatibility problems are showing up when using an interface other than English also ? (I would like to do so but could also use the English MUI settings – in this case I fear compatibility issues with other language addins and worksheets). I guess, that one could switch back and forth MUIs at will ?

I have found MS tutorials for transition from versions 2003 to 2007 and got the impression, that this could be feasible? Given this is true I could also buy versions 2010 or 2012 (in the shops now). And of course Home or Professional. Basically, I would not mind to be up to the current version, even if under MS XP service pack 3.

Which version would you suggest ?

Regards,

leif_85

--- In smf_addin@yahoogroups.com, "dguillett1" <dguillett1@...> wrote:
>
> In my opinion you would be well served to obtain a legal copy of xl2003 which is the last version that is styled as yours.
>
> Don Guillett
> SalesAid Software
> dguillett1@...
>
> From: leif_85
> Sent: Monday, January 30, 2012 11:30 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] hi
>
>
> Hi all,
>
> I suffer from the demise of "Quotes Plus" data provider, whose price and fundamental data I used in Metastock 6.52 and Excel '97.
> Prices/stock quotes and history I get fairly conveniently via MLdownloader, a rather affordable prog, which works OK.
>
> What I do not get is fundamental data for my customized application in Excel'97 where I could plot them after having screened them in "Quotes Plus".
>
> Hence I am interested in an Excel functionality, which is able to download fundamental data, screen and plot them.
>
> Can your application do something like that ?
>
> Regards,
>
> leif_85
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
2b.

Re: hi

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Feb 5, 2012 11:26 am (PST)



The only time I've ever update my versions of the operating system or EXCEL
is when I get a new computer system. I always get the latest version of
EXCEL when I do. So I don't put much thought into the decision. :)

On Sun, Feb 5, 2012 at 9:48 AM, leif_85 <gondoliere2@web.de> wrote:

> Hi Randy, Don and all,
>
> I downloaded the latest patches for my immemoreal Excel 97, SR 2a and two
> minor ones and tried to run smf-addin then, to no avail. It seems it gets
> loaded, as it shows up in the list and is ticked off. Yet after a restart
> it is gone. When loading it in VB for a test, errors are coming up
> concerning the „Split" function for instance.
>
> Don advised me to buy Office version 2003, as this being most similar to
> mine. Randy mentioned compatibility problems with foreign language versions
> relating to number format and - I bet - also date format.. ( BTW I have to
> use a foreign version XP operation system.)
>
> I read, that versions 2003 and 2010 got a MUI (multilingual user
> interface). Does someone know, if those compatibility problems are showing
> up when using an interface other than English also ? (I would like to do so
> but could also use the English MUI settings â€" in this case I fear
> compatibility issues with other language addins and worksheets). I guess,
> that one could switch back and forth MUIs at will ?
>
> I have found MS tutorials for transition from versions 2003 to 2007 and
> got the impression, that this could be feasible? Given this is true I could
> also buy versions 2010 or 2012 (in the shops now). And of course Home or
> Professional. Basically, I would not mind to be up to the current version,
> even if under MS XP service pack 3.
>
> Which version would you suggest ?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
3a.

Stockcharts - Custom Charts - Issue with getting update with new tic

Posted by: "jmkbfitz12" jmkbfitz12@yahoo.com   jmkbfitz12

Sun Feb 5, 2012 11:09 am (PST)



The SMF_Add-in is a great tool.

I've created spreadsheet to keep update charts weekly. I have been using the formula below:

=RCHCreateComment("http://stockcharts.com/h-sc/ui?s=ACN&p=D&b=5&g=0&id=p95576936993",,550,400,1)

This works well and will update with new data with the ctl-shift-R update.

The problem that I've had is if I want to copy this formula to make more charts on a new page, I end up with the same "original" stock chart even if I updated the ticker to something new in the hard-coded formula. I've found that I have to copy the "old" URL from the excel formula into browser which takes me to stockcharts, I then have to change the ticker to get the new chart, click linkable version and then paste back into excel. The new chart will then show up in excel.

For some reason, if I try to change the ticker in excel, the original chart comes up. I was hoping to be able to use "concatenate" to make it easier to just update the chart linking to a cell with ticker in it but for some reason it won't work for me.

It doesn't look like stockcharts is changing the URL except for changing the ticker. Not sure what the issue is.

Any thoughts?

Thx

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.

Re: Stockcharts - Custom Charts - Issue with getting update with new

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Feb 5, 2012 11:23 am (PST)



When I copied your formula in to EXCEL, I get a chart for FBGRX.

The problem is that you are using the URL for the web page. You need to use
the URL for the image. When I use the image URL, everything works fine --
including concatenating in the ticker symbol.

On Sun, Feb 5, 2012 at 12:05 PM, jmkbfitz12 <jmkbfitz12@yahoo.com> wrote:

>
> I've created spreadsheet to keep update charts weekly. I have been using
> the formula below:
>
> =RCHCreateComment("
> http://stockcharts.com/h-sc/ui?s=ACN&p=D&b=5&g=0&id=p95576936993
> ",,550,400,1)
>
> This works well and will update with new data with the ctl-shift-R update.
>
> The problem that I've had is if I want to copy this formula to make more
> charts on a new page, I end up with the same "original" stock chart even if
> I updated the ticker to something new in the hard-coded formula. I've
> found that I have to copy the "old" URL from the excel formula into browser
> which takes me to stockcharts, I then have to change the ticker to get the
> new chart, click linkable version and then paste back into excel. The new
> chart will then show up in excel.
>
> For some reason, if I try to change the ticker in excel, the original
> chart comes up. I was hoping to be able to use "concatenate" to make it
> easier to just update the chart linking to a cell with ticker in it but for
> some reason it won't work for me.
>
> It doesn't look like stockcharts is changing the URL except for changing
> the ticker. Not sure what the issue is.
>
> Any thoughts?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

Currency Quotes, Historical Prices, Daily and Year to Date Change.

Posted by: "curls07" agc11d@gmail.com   curls07

Sun Feb 5, 2012 11:57 am (PST)



Hey guys,

I realized there was no built in function that explicitly gets currency quotes. So, I figured out a cool little way to get historical and current currency closing prices, daily and year to date change in both direct and in direct quotations from the wall street journal.com

=RCHGetTableCell("http://online.wsj.com/mdc/public/page/2_3021-forex-" & AQ2 &".html?mod=mdc_pastcalendar",1,"Asia-Pacific","China yuan")

The inputs needed are as follows;

Date in YYYYDDMM format as a cell reference so you can do several dates at once for easy comparisons. It's the -" & AQ2 &" part in the URL, you can make it reference to any cell you want. If you leave the cell value blank it will return that days quotation

The HTML cell reference number (1-6) where;
1 = that days adjusted close in direct quotation,
2 = the previous days adjusted close in direct quotation,
3 = that days change,
4 = year to date change,
5 = that days adjusted close in indirect quotation,
6 = the previous days adjusted close in indirect quotation

Then you need to put the super category of the currency, Americas, Asian-Pacific, Europe, ect. You can find what value your looking for by going to WSJ.com and checking the currency quotes. The value your looking for are the table headers.

Then finally, the name of the currency your looking for.

This will work just as well in a custom element form but I put in the rchgettablecell form so you guys can adjust it to your own personal needs.

I hope this helps anyone else looking for currency quotes too

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
4b.

Re: Currency Quotes, Historical Prices, Daily and Year to Date Chang

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Feb 5, 2012 12:32 pm (PST)



Have you looked at this template in the files area:

RCHGetTableCell-Template-Pacific-Exchange-Rate.xls

On Sun, Feb 5, 2012 at 12:57 PM, curls07 <agc11d@gmail.com> wrote:

> Hey guys,
>
> I realized there was no built in function that explicitly gets currency
> quotes. So, I figured out a cool little way to get historical and current
> currency closing prices, daily and year to date change in both direct and
> in direct quotations from the wall street journal.com
>
> =RCHGetTableCell("http://online.wsj.com/mdc/public/page/2_3021-forex-" &
> AQ2 &".html?mod=mdc_pastcalendar",1,"Asia-Pacific","China yuan")
>
> The inputs needed are as follows;
>
> Date in YYYYDDMM format as a cell reference so you can do several dates at
> once for easy comparisons. It's the -" & AQ2 &" part in the URL, you can
> make it reference to any cell you want. If you leave the cell value blank
> it will return that days quotation
>
> The HTML cell reference number (1-6) where;
> 1 = that days adjusted close in direct quotation,
> 2 = the previous days adjusted close in direct quotation,
> 3 = that days change,
> 4 = year to date change,
> 5 = that days adjusted close in indirect quotation,
> 6 = the previous days adjusted close in indirect quotation
>
> Then you need to put the super category of the currency, Americas,
> Asian-Pacific, Europe, ect. You can find what value your looking for by
> going to WSJ.com and checking the currency quotes. The value your looking
> for are the table headers.
>
> Then finally, the name of the currency your looking for.
>
> This will work just as well in a custom element form but I put in the
> rchgettablecell form so you guys can adjust it to your own personal needs.
>
> I hope this helps anyone else looking for currency quotes too
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
4c.

Re: Currency Quotes, Historical Prices, Daily and Year to Date Chang

Posted by: "curls07" agc11d@gmail.com   curls07

Sun Feb 5, 2012 1:07 pm (PST)




No I didn't see that sheet, so I just downloaded it and it works extremely well. Thank you for showing me.

In using yours and my method, you cant search for historical prices, older than 2007. Do you know of any other websites that may have older historical data?

thanks for your help.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Have you looked at this template in the files area:
>
> RCHGetTableCell-Template-Pacific-Exchange-Rate.xls
>
> On Sun, Feb 5, 2012 at 12:57 PM, curls07 <agc11d@...> wrote:
>
> > Hey guys,
> >
> > I realized there was no built in function that explicitly gets currency
> > quotes. So, I figured out a cool little way to get historical and current
> > currency closing prices, daily and year to date change in both direct and
> > in direct quotations from the wall street journal.com
> >
> > =RCHGetTableCell("http://online.wsj.com/mdc/public/page/2_3021-forex-" &
> > AQ2 &".html?mod=mdc_pastcalendar",1,"Asia-Pacific","China yuan")
> >
> > The inputs needed are as follows;
> >
> > Date in YYYYDDMM format as a cell reference so you can do several dates at
> > once for easy comparisons. It's the -" & AQ2 &" part in the URL, you can
> > make it reference to any cell you want. If you leave the cell value blank
> > it will return that days quotation
> >
> > The HTML cell reference number (1-6) where;
> > 1 = that days adjusted close in direct quotation,
> > 2 = the previous days adjusted close in direct quotation,
> > 3 = that days change,
> > 4 = year to date change,
> > 5 = that days adjusted close in indirect quotation,
> > 6 = the previous days adjusted close in indirect quotation
> >
> > Then you need to put the super category of the currency, Americas,
> > Asian-Pacific, Europe, ect. You can find what value your looking for by
> > going to WSJ.com and checking the currency quotes. The value your looking
> > for are the table headers.
> >
> > Then finally, the name of the currency your looking for.
> >
> > This will work just as well in a custom element form but I put in the
> > rchgettablecell form so you guys can adjust it to your own personal needs.
> >
> > I hope this helps anyone else looking for currency quotes too
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
4d.

SMF Template

Posted by: "ken" kab777@optonline.net   mustang66.7599

Sun Feb 5, 2012 1:09 pm (PST)



Hi Randy

Absolutely LOVE the smf_addin - it has allowed me to analyze more stocks in
a week than I ever thought possible!

I downloaded the February update to the add_in and the Misc Technical
Indicators template but it does not work when I type in a symbol - nothing
happens - the original add_in works fine. But I cannot get the StockScores
item 824 and 826 to work - all I get is ERROR.

So I presume I did something wrong when I downloaded the new add_in file?

I might know a lot about stocks but little about Excel !

Help!

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
4e.

Re: Currency Quotes, Historical Prices, Daily and Year to Date Chang

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Feb 5, 2012 2:55 pm (PST)



Sorry, no. I don't do anything with currencies, so I'm not familiar with
its online resources.

On Sun, Feb 5, 2012 at 2:07 PM, curls07 <agc11d@gmail.com> wrote:

>
> No I didn't see that sheet, so I just downloaded it and it works extremely
> well. Thank you for showing me.
>
> In using yours and my method, you cant search for historical prices, older
> than 2007. Do you know of any other websites that may have older historical
> data?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
4f.

Re: SMF Template

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Feb 5, 2012 2:58 pm (PST)



I just tried 824 and 826 with ticker symbols MMM and IBM, and they both
worked fine for me...

What ticker symbols are you trying?

Have you tried the smfForceRecalculation macro? Maybe the website was down
and sent a few bad web pages that are saved in the add-in now...?

On Sun, Feb 5, 2012 at 2:09 PM, ken <kab777@optonline.net> wrote:

>
>
> I downloaded the February update to the add_in and the Misc Technical
> Indicators template but it does not work when I type in a symbol â€" nothing
> happens - the original add_in works fine. But I cannot get the StockScores
> item 824 and 826 to work â€" all I get is ERROR. ****
>
> ** **
>
> So I presume I did something wrong when I downloaded the new add_in file?*
> ***
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
4g.

Re: SMF Template

Posted by: "ken" kab777@optonline.net   mustang66.7599

Sun Feb 5, 2012 4:01 pm (PST)



It is very strange - this is the error message when I take the option to
update the page

I see that the Add-In is saved as an XLAM file not an XLA

Does this have something to do with my problem?

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Randy Harmelink
Sent: Sunday, February 05, 2012 5:59 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Template

I just tried 824 and 826 with ticker symbols MMM and IBM, and they both
worked fine for me...

What ticker symbols are you trying?

Have you tried the smfForceRecalculation macro? Maybe the website was down
and sent a few bad web pages that are saved in the add-in now...?

On Sun, Feb 5, 2012 at 2:09 PM, ken <kab777@optonline.net> wrote:

I downloaded the February update to the add_in and the Misc Technical
Indicators template but it does not work when I type in a symbol - nothing
happens - the original add_in works fine. But I cannot get the StockScores
item 824 and 826 to work - all I get is ERROR.

So I presume I did something wrong when I downloaded the new add_in file?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
4h.

Re: SMF Template

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Feb 5, 2012 4:13 pm (PST)



Those are just location errors -- check the "Links" area for a link to a
message on how to resolve them.

On Sun, Feb 5, 2012 at 5:01 PM, ken <kab777@optonline.net> wrote:

>
> It is very strange â€" this is the error message when I take the option to
> update the page****
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
4i.

Re: SMF Template

Posted by: "ken" kab777@optonline.net   mustang66.7599

Sun Feb 5, 2012 4:32 pm (PST)



I went to the Links area - the fix lists a different cell description

The fix says to Replace All

'C:\User Name\Application
Data\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!

With nothing

That didn't work - it said it couldn't find anything by that name - the cell
lists

='C:\Program Files\SMF
Add-In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber(Ticker, 826)

Also I had to unprotect the sheet before I could even use Ctrl H

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Randy Harmelink
Sent: Sunday, February 05, 2012 7:14 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Template

Those are just location errors -- check the "Links" area for a link to a
message on how to resolve them.

On Sun, Feb 5, 2012 at 5:01 PM, ken <kab777@optonline.net> wrote:

It is very strange - this is the error message when I take the option to
update the page

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
4j.

Re: SMF Template

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Feb 5, 2012 5:14 pm (PST)



The fix is just an example. You need to use whatever the location path is
in your formula...

On Sun, Feb 5, 2012 at 5:32 PM, ken <kab777@optonline.net> wrote:

>
> I went to the Links area â€" the fix lists a different cell description****
>
> ** **
>
> The fix says to Replace All ****
>
> ** **
>
> 'C:\User Name\Application
> Data\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!****
>
> ** **
>
> With nothing ****
>
> ** **
>
> That didn’t work â€" it said it couldn’t find anything by that name â€" the
> cell lists ****
>
> ** **
>
> ='C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber(Ticker, 826)***
> *
>
> ** **
>
> Also I had to unprotect the sheet before I could even use Ctrl H
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
5a.

I like your addin

Posted by: "lfranzen_1999" lee@growthstock.com   lfranzen_1999

Sun Feb 5, 2012 2:48 pm (PST)



This addin has allowed me to create dashboards that I use to analyze stocks. Do you have a website with a "buy Randy a beer" button or something similar where I can leave a token of my appreciation?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5b.

Re: I like your addin

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Feb 5, 2012 3:00 pm (PST)



I ask that people "Pay it Forward" and give a donation to a worthy charity.
If you're making some extra money now, share the wealth! :)

On Sun, Feb 5, 2012 at 3:26 PM, lfranzen_1999 <lee@growthstock.com> wrote:

> This addin has allowed me to create dashboards that I use to analyze
> stocks. Do you have a website with a "buy Randy a beer" button or
> something similar where I can leave a token of my appreciation?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6a.

Change in Yahoo layout

Posted by: "cobran20" cobran20@yahoo.com.au   cobran20

Sun Feb 5, 2012 2:49 pm (PST)



Hello,

Yahoo have changed their layout such that I cannot get the close price for quotes. Using the Dow as an example at this link:

http://au.finance.yahoo.com/q?s=%5EDJI

the formula:

=RCHGetTableCell("http://au.finance.yahoo.com/q?s=^DJI",1,"Index Value:")

no longer works as the label'Index Value:' no longer appears.

Is there a solution?

Thanks in advance

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6b.

Re: Change in Yahoo layout

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Feb 5, 2012 3:03 pm (PST)



Try something like:

=0+smfGetTagContent("http://finance.yahoo.com/q?s=^DJI","span",0,"yfs_l10")

On Sun, Feb 5, 2012 at 3:14 PM, cobran20 <cobran20@yahoo.com.au> wrote:

>
> Yahoo have changed their layout such that I cannot get the close price for
> quotes. Using the Dow as an example at this link:
>
> http://au.finance.yahoo.com/q?s=%5EDJI
>
> the formula:
>
> =RCHGetTableCell("http://au.finance.yahoo.com/q?s=^DJI",1,"Index Value:")
>
> no longer works as the label'Index Value:' no longer appears.
>
> Is there a solution?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
7a.

Re: Values for RCHGetElementNumber elements Different from Yahoo Pag

Posted by: "Christopher" miller@sun-capital.net   jcredline

Sun Feb 5, 2012 2:49 pm (PST)



Thanks for the response I will check that.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I just tried the three element numbers and I'm getting the correct values
> -- $5.11, $5.43, and 3.1%.
>
> I suspect you have your Internet Options set up to cache web pages, so the
> add-in is picking the data up from an old copy of the web page. Verify that
> you are set up to always get a fresh copy of the web page.
>
> On Thu, Feb 2, 2012 at 7:06 PM, Christopher <miller@...> wrote:
>
> > I am using =RCHGetElementNumber for JNJ
> >
> > Returning Values for Element # 596(Avg Estimate FY1) & 596(Avg Estimate
> > FY2) of $4.76 and $5.22. The Yahoo Analyst Estimates page displays $5.11
> > and $5.43?
> >
> > Returning Value for Element # 4928 (5 Year Average Dividend Yield) of
> > 2.90%. The Yahoo Key Statistics page displays 3.10%?
> >
> > I have loaded the updated add_in for 2012.
> >
> > Any thoughts?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
8a.

Re: Is yahoo VOLUME split-adjusted?

Posted by: "pharnsbe" harnsberger@gmail.com   pharnsbe

Sun Feb 5, 2012 6:40 pm (PST)



Mike, great details. Thanks for adding.

FWIW...

I suppose if one really needed an EXACT measure of $volume (and couldn't afford to purchase a database), you could recall the past dividends(smfGetYahooHistory does this well using "v" for period), compute the adjustment factor per div date, apply adjustment factor to yahoo's adjusted close, then multiply by volume. You'd essentially be "backing out" the dividends, while leaving the split adjustments in.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
8b.

Re: Is yahoo VOLUME split-adjusted?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sun Feb 5, 2012 7:25 pm (PST)



You can get the splits from Yahoo's basic chart page. For example:

http://finance.yahoo.com/q/bc

See: http://finance.groups.yahoo.com/group/smf_addin/message/14400

On Sun, Feb 5, 2012 at 7:40 PM, pharnsbe <harnsberger@gmail.com> wrote:

>
> FWIW...
>
> I suppose if one really needed an EXACT measure of $volume (and couldn't
> afford to purchase a database), you could recall the past
> dividends(smfGetYahooHistory does this well using "v" for period), compute
> the adjustment factor per div date, apply adjustment factor to yahoo's
> adjusted close, then multiply by volume. You'd essentially be "backing out"
> the dividends, while leaving the split adjustments in.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
8c.

Re: Is yahoo VOLUME split-adjusted?

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Sun Feb 5, 2012 8:24 pm (PST)



Yes, you certainly could. Or, you could retrieve split info and manually
adjust Yahoo's historical "raw close". Earnings.com seems to have pretty
good split info. Example:

http://www.earnings.com/company.asp?client=cb
<http://www.earnings.com/company.asp?client=cb&ticker=tjx> &ticker=tjx

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of pharnsbe
Sent: Sunday, February 05, 2012 9:41 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Is yahoo VOLUME split-adjusted?

Mike, great details. Thanks for adding.

FWIW...

I suppose if one really needed an EXACT measure of $volume (and couldn't
afford to purchase a database), you could recall the past
dividends(smfGetYahooHistory does this well using "v" for period), compute
the adjustment factor per div date, apply adjustment factor to yahoo's
adjusted close, then multiply by volume. You'd essentially be "backing out"
the dividends, while leaving the split adjustments in.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
9.

RCHGetHTMLTable - big safe dividends

Posted by: "hashky" hashky@yahoo.com   hashky

Sun Feb 5, 2012 8:07 pm (PST)



Randy -

Once again I am baffled by this function.

I am trying to get this table.

http://www.bigsafedividends.com/quadchartie.aspx

I am logged in, which is free BTW.

I am using

=RCHGetHTMLTable("http://www.bigsafedividends.com/quadchartie.aspx","Big Safe Dividends",47,"",47,)

I got it. But the only way I know to do it is trial and error. Going one at a time took me a long time to get to 47. I found it first by using "Click" and 41 tries.

=RCHGetHTMLTable("http://www.bigsafedividends.com/quadchartie.aspx","Click",41,"",41,)

Is there some easy way to count <TABLE tags? My HTML is zippo.

Ron Spruell

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
Recent Activity
Visit Your Group
Yahoo! News

Fashion News

What's the word on

fashion and style?

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 20.24

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)