11 New Messages
Digest #2540
Messages
Sun Mar 10, 2013 6:09 am (PDT) . Posted by:
"whitney" thelancour
I think I remember seeing in another inquiry that SMF Add in can only download a certain amount of pages at one time. I usually use the fill handle and drag say 2000 cells and let it download what it can, then Ill copy and paste those values, close sheet, then reopen and let it automatically download the remaining cells with smf functions. IS there a way to copy and paste the values and not have to restart the program to get the rest, some kind of memory or cache that can be cleared in excel?? It would definitely speed things up. Thanks!
Sun Mar 10, 2013 9:15 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The add-in is intended for ad hoc data retrieval, not for loading of
databases. It's an unfair burden to place on the free data sources, which
could easily write their web pages in a way that prevents something like
the add-in from being able to extract data. Why do you need to get data
from so many web pages?
In any case, read the write-up on the smfForceRecalculation macro for
details on the 1000-web page limit and how to purge the saved web pages.
On Sun, Mar 10, 2013 at 6:09 AM, whitney <thelancour@yahoo.com > wrote:
> I think I remember seeing in another inquiry that SMF Add in can only
> download a certain amount of pages at one time. I usually use the fill
> handle and drag say 2000 cells and let it download what it can, then Ill
> copy and paste those values, close sheet, then reopen and let it
> automatically download the remaining cells with smf functions. IS there a
> way to copy and paste the values and not have to restart the program to get
> the rest, some kind of memory or cache that can be cleared in excel?? It
> would definitely speed things up. Thanks!
>
databases. It's an unfair burden to place on the free data sources, which
could easily write their web pages in a way that prevents something like
the add-in from being able to extract data. Why do you need to get data
from so many web pages?
In any case, read the write-up on the smfForceRecalculati
details on the 1000-web page limit and how to purge the saved web pages.
On Sun, Mar 10, 2013 at 6:09 AM, whitney <thelancour@yahoo.
> I think I remember seeing in another inquiry that SMF Add in can only
> download a certain amount of pages at one time. I usually use the fill
> handle and drag say 2000 cells and let it download what it can, then Ill
> copy and paste those values, close sheet, then reopen and let it
> automatically download the remaining cells with smf functions. IS there a
> way to copy and paste the values and not have to restart the program to get
> the rest, some kind of memory or cache that can be cleared in excel?? It
> would definitely speed things up. Thanks!
>
Sun Mar 10, 2013 9:37 am (PDT) . Posted by:
"andyha8" andyha8
Wow, that's really different. For me it takes me to this page
http://finance.
The title of the page is "Quotes &Info"
I thought it might be my adblocker so I disabled it, same result
I thought it might be firefox so I changed default browser to IE, same result.
The only clue is when it first goes to the page I get the spinning flash icon for about 2 seconds and then nothing. My flash and java are both current....
--- In smf_addin@yahoogrou
>
> Hmmm. Works for me. It changes that other COO to MMM when it renders the
> page for me. This is where I end up when it follows the link:
>
> http://finance.
> ;
>
> On Sun, Mar 10, 2013 at 1:44 AM, andyha8 <andyha8@
>
> > Well that just gets me to here:
> > http://finance.
> > mmmm, I still see coo in that link...
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Try:
> > >
> > > =HYPERLINK("http://finance.
> > "&A5&
> > > Chart")
> >
>
Sun Mar 10, 2013 1:06 pm (PDT) . Posted by:
"andyha8" andyha8
It's working!!! Been messing around with this and I'm not sure what I did but it is now working beautifully. Many thanks again.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Hmmm. Works for me. It changes that other COO to MMM when it renders the
> page for me. This is where I end up when it follows the link:
>
> http://finance.yahoo.com/echarts?s=MMM+Interactive#symbol=mmm;range=6m;compare=;indicator=ema%2820,50%29+macd+stochasticslow+rsi;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=undefined
> ;
>
> On Sun, Mar 10, 2013 at 1:44 AM, andyha8 <andyha8@...> wrote:
>
> > Well that just gets me to here:
> > http://finance.yahoo.com/echarts?s=
> > mmmm, I still see coo in that link...
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > Try:
> > >
> > > =HYPERLINK("http://finance.yahoo.com/echarts?s=
> > "&A5&"+Interactive#symbol=coo;range=6m;compare=;indicator=ema%2820,50%29+macd+stochasticslow+rsi;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=undefined",A5&"
> > > Chart")
> >
>
--- In smf_addin@yahoogrou
>
> Hmmm. Works for me. It changes that other COO to MMM when it renders the
> page for me. This is where I end up when it follows the link:
>
> http://finance.
> ;
>
> On Sun, Mar 10, 2013 at 1:44 AM, andyha8 <andyha8@
>
> > Well that just gets me to here:
> > http://finance.
> > mmmm, I still see coo in that link...
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Try:
> > >
> > > =HYPERLINK("http://finance.
> > "&A5&
> > > Chart")
> >
>
Sun Mar 10, 2013 3:33 pm (PDT) . Posted by:
"Mark Clemmons" mark.clemmons@rocketmail.com
I am using one the templates to obtain historical closing stock prices from Yahoo as of a specific date. The template obtains the adjusted close price, but I would like to obtain the actual close price. I am a new user, so I may not explain things correctly, but the data element that provides the adjusted close is "08". Is there an element that will give me the actual historical closing price?
Regards,
Mark D. Clemmons
Regards,
Mark D. Clemmons
Sun Mar 10, 2013 3:38 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The only function that can get actual historical quotes is the
RCHGetYahooHistory() function. The function you're referring to with the
"08" parameter is the smfPricesBetween() function, where it wouldn't make
sense to get anything other than adjusted closing prices.
smfPricesByDates() also only gets adjusted closing prices, because it
wouldn't make sense to get actual closing prices for multiple dates, other
than a few very specific situations -- in which case the
RCHGetYahooHistory() function can gill the gap.
On Sun, Mar 10, 2013 at 2:58 PM, Mark Clemmons <mark.clemmons@mcmpllc.com >wrote:
>
> I am using one the templates to obtain historical closing stock prices
> from Yahoo as of a specific date. The template obtains the adjusted close
> price, but I would like to obtain the actual close price. I am a new user,
> so I may not explain things correctly, but the data element that provides
> the adjusted close is "08". Is there an element that will give me the
> actual historical closing price?****
>
>
>
RCHGetYahooHistory(
"08" parameter is the smfPricesBetween(
sense to get anything other than adjusted closing prices.
smfPricesByDates(
wouldn't make sense to get actual closing prices for multiple dates, other
than a few very specific situations -- in which case the
RCHGetYahooHistory(
On Sun, Mar 10, 2013 at 2:58 PM, Mark Clemmons <mark.clemmons@
>
> I am using one the templates to obtain historical closing stock prices
> from Yahoo as of a specific date. The template obtains the adjusted close
> price, but I would like to obtain the actual close price. I am a new user,
> so I may not explain things correctly, but the data element that provides
> the adjusted close is "08". Is there an element that will give me the
> actual historical closing price?****
>
>
>
Sun Mar 10, 2013 4:29 pm (PDT) . Posted by:
"Randy H" rharmelink
Just a heads-up on some sample VBA to post a chart into your workbook.
http://boards.fool.com/fwiw-my-dynamically-created-excel-charts-still-30583280.aspx
For example, I might have a subroutine to call that one:
Sub Test()
Call DisplayChartForTicker("MMM", 0, 0, 12, 350, 265)
Call DisplayChartForTicker("SPY", 266, 0, 12, 350, 265)
End Sub
http://boards.
For example, I might have a subroutine to call that one:
Sub Test()
Call DisplayChartForTick
Call DisplayChartForTick
End Sub
Sun Mar 10, 2013 5:54 pm (PDT) . Posted by:
"DonaldB" donald_brown_48367
Hi Randy
Finally got around to trying to make this work. This formula works fine to return the percentage:
=0+smfStrExtr(RCHGetElementNumber("YahooMS", 13822),"(",")")
but:
=0+smfStrExtr(RCHGetElementNumber("YahooMS", 13822),"~"," ")
gives a "$VALUE!" error.
Any ideas?
Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Actually, if you look at the values, the element numbers are returning
> both. Apparently, Yahoo has modified the web page, and added the percentage
> values in the same table cell as the number of shares, since I defined the
> elements for their Market Statistics web page.
>
> For example, when I look at the upper left-hand corner of the template,
> this formula:
>
> =RCHGetElementNumber("YahooMS", 13822)
>
> ...is actually returning:
>
> 996 (24%)
>
> The two values can easily be extracted:
>
> =0+smfStrExtr(RCHGetElementNumber("YahooMS", 13822),"~"," ")
> =0+smfStrExtr(RCHGetElementNumber("YahooMS", 13822),"(",")")
>
> HOWEVER -- take a look at the differences between these three web page:
>
> http://finance.yahoo.com/advances
> http://www.barchart.com/stocks/momentum.php
> http://online.wsj.com/mdc/public/page/2_3021-tradingdiary2.html
> http://unicorn.us.com/advdec/
>
> Quite a difference in values, huh? To me, the Yahoo numbers look very bad.
> First off, I suspect the other sources omit things like ETFs? It doesn't
> really help to count advancing/declining when you can have ETFs that are
> both long and short -- if one advances, the other should be declining.
>
> On Mon, Feb 25, 2013 at 5:18 PM, DonaldB <donald_brown_48367@...>wrote:
>
> >
> > Is there a way to get the actual number of advancing / declining stocks
> > off the yahoo market statistics page rather than the percentage in
> > brackets? (I can use the percentage and then calculate the number from the
> > total number of stocks but it is always a little off from the actual posted
> > number). Thanks for your help.
> >
>
Finally got around to trying to make this work. This formula works fine to return the percentage:
=0+smfStrExtr(
but:
=0+smfStrExtr(
gives a "$VALUE!
Any ideas?
Thanks.
--- In smf_addin@yahoogrou
>
> Actually, if you look at the values, the element numbers are returning
> both. Apparently, Yahoo has modified the web page, and added the percentage
> values in the same table cell as the number of shares, since I defined the
> elements for their Market Statistics web page.
>
> For example, when I look at the upper left-hand corner of the template,
> this formula:
>
> =RCHGetElementNumbe
>
> ...is actually returning:
>
> 996 (24%)
>
> The two values can easily be extracted:
>
> =0+smfStrExtr(
> =0+smfStrExtr(
>
> HOWEVER -- take a look at the differences between these three web page:
>
> http://finance.
> http://www.barchart
> http://online.
> http://unicorn.
>
> Quite a difference in values, huh? To me, the Yahoo numbers look very bad.
> First off, I suspect the other sources omit things like ETFs? It doesn't
> really help to count advancing/declining when you can have ETFs that are
> both long and short -- if one advances, the other should be declining.
>
> On Mon, Feb 25, 2013 at 5:18 PM, DonaldB <donald_brown_
>
> >
> > Is there a way to get the actual number of advancing / declining stocks
> > off the yahoo market statistics page rather than the percentage in
> > brackets? (I can use the percentage and then calculate the number from the
> > total number of stocks but it is always a little off from the actual posted
> > number). Thanks for your help.
> >
>
Sun Mar 10, 2013 6:09 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Probably you don't have a recent version of the add-in. The "~" character
was something I added to indicate "from the start of the string" (or "to
the end" if it's the second search string).
On Sun, Mar 10, 2013 at 5:54 PM, DonaldB <donald_brown_48367@yahoo.com >wrote:
>
> Finally got around to trying to make this work. This formula works fine
> to return the percentage:
> =0+smfStrExtr(RCHGetElementNumber("YahooMS", 13822),"(",")")
>
> but:
> =0+smfStrExtr(RCHGetElementNumber("YahooMS", 13822),"~"," ")
>
> gives a "$VALUE!" error.
>
> Any ideas?
>
was something I added to indicate "from the start of the string" (or "to
the end" if it's the second search string).
On Sun, Mar 10, 2013 at 5:54 PM, DonaldB <donald_brown_
>
> Finally got around to trying to make this work. This formula works fine
> to return the percentage:
> =0+smfStrExtr(
>
> but:
> =0+smfStrExtr(
>
> gives a "$VALUE!
>
> Any ideas?
>
Sun Mar 10, 2013 9:22 pm (PDT) . Posted by:
"aishu_1110" aishu_1110
Hi,
smfgettagcontent() function worked fine till 1080 rows. From 1081, the return is always error. Nothing changed (no formatting changes or anythin).
The function just stopped working
smfgettagcontent(
The function just stopped working
Sun Mar 10, 2013 9:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm surprised you got that many, unless some are from the same web page.
The add-in is limited to retrieving 1000 web pages per session. It's meant
for ad hoc data using, not bulk downloading. It's an unfair burden to place
on the free data sources.
What kind of data are you getting?
On Sun, Mar 10, 2013 at 8:53 PM, aishu_1110 <aishu_1110@yahoo.com > wrote:
>
> smfgettagcontent() function worked fine till 1080 rows. From 1081, the
> return is always error. Nothing changed (no formatting changes or anythin).
>
> The function just stopped working
>
The add-in is limited to retrieving 1000 web pages per session. It's meant
for ad hoc data using, not bulk downloading. It's an unfair burden to place
on the free data sources.
What kind of data are you getting?
On Sun, Mar 10, 2013 at 8:53 PM, aishu_1110 <aishu_1110@yahoo.
>
> smfgettagcontent(
> return is always error. Nothing changed (no formatting changes or anythin).
>
> The function just stopped working
>
Tidak ada komentar:
Posting Komentar