Messages In This Digest (9 Messages)
- 1a.
- Re: SMF Add-in Funktions don't run from USB From: stuermer001
- 2a.
- which function can i use to extract a picture From: spectratecharchitecture
- 2b.
- Re: which function can i use to extract a picture From: Randy Harmelink
- 3a.
- smfPricesBetween() appears to be subtracting dividends from Highs... From: eduba01
- 3b.
- Re: smfPricesBetween() appears to be subtracting dividends from High From: Randy Harmelink
- 3c.
- Re: smfPricesBetween() appears to be subtracting dividends from High From: eduba01
- 3d.
- Re: smfPricesBetween() appears to be subtracting dividends from High From: Randy Harmelink
- 4a.
- StockHouse data errors From: Bike bum
- 4b.
- Re: StockHouse data errors From: Randy Harmelink
Messages
- 1a.
-
Re: SMF Add-in Funktions don't run from USB
Posted by: "stuermer001" stuermer@bigmir.net stuermer001
Fri Oct 21, 2011 3:59 am (PDT)
Hallo,
yes, it was solved with edit/links, thanks!
--- In smf_addin@yahoogroups.com , "stuermer001" <stuermer@...> wrote:
>
> Hallo,
>
> I have an Excel file with AddIn fuctions in cells. If I open this file on drive C the function run, but if I copy the file to USB Flash-Drive and open it from there, they don't run. What could be the reason?
>
- 2a.
-
which function can i use to extract a picture
Posted by: "spectratecharchitecture" spectratecharchitecture@gmail.com spectratecharchitecture
Fri Oct 21, 2011 12:07 pm (PDT)
Hello,
I was wondering which function i could use to extract a chart in the form of a png. the webpage IS bookmarkable ( http://finance.yahoo.com/ )q/bc?s=IXN& t=2y&l=on& z=l&q=c&c=
and i can modify the parameters in the link to change the stock, time and time frame. Just wanted to know which function would be best to get that picture chart into excel.
Thank you very much for your time, again.
Miguel Angel Gonzalez
- 2b.
-
Re: which function can i use to extract a picture
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Oct 21, 2011 12:23 pm (PDT)
To extract the chart, you need the URL of the image. Check the documentation
for RCHCreateComment().
For example, in its simplest form for the chart on the web page you noted:
=RCHCreateComment("
http://chart.finance.yahoo. com/z?s=IXN& t=2y&q=c& l=on&z=l& p=m50,m200& a=v&lang= en-US®ion= US
",99)
On Fri, Oct 21, 2011 at 12:07 PM, spectratecharchitecture <
spectratecharchitecture@gmail. > wrote:com
>
> I was wondering which function i could use to extract a chart in the
> form of a png. the webpage IS bookmarkable (
> http://finance.yahoo.com/ )q/bc?s=IXN& t=2y&l=on& z=l&q=c&c=
> and i can modify the parameters in the link to change the stock, time and
> time frame. Just wanted to know which function would be best to get that
> picture chart into excel.
>
- 3a.
-
smfPricesBetween() appears to be subtracting dividends from Highs...
Posted by: "eduba01" Erich_Wiener@yahoo.com eduba01
Fri Oct 21, 2011 1:29 pm (PDT)
Any way to turn off that feature?
I am looking at the DIA in particular:
Using:
smfPricesBetween("DIA",DATE( 2011,8,10) ,DATE(2011, 10,20))," 0403")
I get a high of $116.82 on 9/01/11
While looking at the historical prices, the date is correct, but the high shown is $117.03.
http://finance.yahoo.com/ q/hp?s=DIA& a=07&b=10& c=2011&d= 09&e=21&f= 2011&g=d
I did confirm GetYahooHistory and an excel "MAX" returns $117.03.
Coincidentally, the delta ($0.21) between the two results is exactly the dividend paid out on 9/16.
Note that there is another dividend paid on 8/19. So while it occurred in the date range, it doesn't appear to be considered in what smfPricesBetween() returns as a high. So my idea as a work-around of simply adding the dividends back in between the dates wouldn't work.
Thanks in advance for any feedback you can offer.
- 3b.
-
Re: smfPricesBetween() appears to be subtracting dividends from High
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Oct 21, 2011 1:33 pm (PDT)
No. The difference is not coincidental -- smfPricesBetween() uses adjusted
prices (pro-rated, not subtracted). It never made sense to me to use
unadjusted prices.
On Fri, Oct 21, 2011 at 1:00 PM, eduba01 <Erich_Wiener@yahoo.com > wrote:
> Any way to turn off that feature?
>
> I am looking at the DIA in particular:
>
> Using:
> smfPricesBetween("DIA",DATE( 2011,8,10) ,DATE(2011, 10,20))," 0403")
>
> I get a high of $116.82 on 9/01/11
>
> While looking at the historical prices, the date is correct, but the high
> shown is $117.03.
> http://finance.yahoo.com/ q/hp?s=DIA& a=07&b=10& c=2011&d= 09&e=21&f= 2011&g=d
>
> I did confirm GetYahooHistory and an excel "MAX" returns $117.03.
>
> Coincidentally, the delta ($0.21) between the two results is exactly the
> dividend paid out on 9/16.
>
> Note that there is another dividend paid on 8/19. So while it occurred in
> the date range, it doesn't appear to be considered in what
> smfPricesBetween() returns as a high. So my idea as a work-around of simply
> adding the dividends back in between the dates wouldn't work.
>
- 3c.
-
Re: smfPricesBetween() appears to be subtracting dividends from High
Posted by: "eduba01" Erich_Wiener@yahoo.com eduba01
Sat Oct 22, 2011 12:01 am (PDT)
Thanks for the reply...I'm assuming that feature can't be disabled within smfPricesBetween() based on your response.
I'm working on Turtle Trader spreadsheet looking for 50 day breakouts, so my preference is to use non-adjusted histories since charts and daily prices are also listed in non-adjusted prices.
I'll use the GetYahooHistory with a Max/Min as a work around, or get the dividends and roll back the pro-rating with smfPricesBetween().
Thanks again for the time you've committed to the smf_addin and if you consider feature requests, I hope you'd consider adding a non-adjusted option for smfPricesBetween().
-Erich
(No response req'd)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> No. The difference is not coincidental -- smfPricesBetween() uses adjusted
> prices (pro-rated, not subtracted). It never made sense to me to use
> unadjusted prices.
>
> On Fri, Oct 21, 2011 at 1:00 PM, eduba01 <Erich_Wiener@...> wrote:
>
> > Any way to turn off that feature?
> >
> > I am looking at the DIA in particular:
> >
> > Using:
> > smfPricesBetween("DIA",DATE( 2011,8,10) ,DATE(2011, 10,20))," 0403")
> >
> > I get a high of $116.82 on 9/01/11
> >
> > While looking at the historical prices, the date is correct, but the high
> > shown is $117.03.
> > http://finance.yahoo.com/ q/hp?s=DIA& a=07&b=10& c=2011&d= 09&e=21&f= 2011&g=d
> >
> > I did confirm GetYahooHistory and an excel "MAX" returns $117.03.
> >
> > Coincidentally, the delta ($0.21) between the two results is exactly the
> > dividend paid out on 9/16.
> >
> > Note that there is another dividend paid on 8/19. So while it occurred in
> > the date range, it doesn't appear to be considered in what
> > smfPricesBetween() returns as a high. So my idea as a work-around of simply
> > adding the dividends back in between the dates wouldn't work.
> >
>
- 3d.
-
Re: smfPricesBetween() appears to be subtracting dividends from High
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Oct 22, 2011 12:53 am (PDT)
On Sat, Oct 22, 2011 at 12:01 AM, eduba01 <Erich_Wiener@yahoo.com > wrote:
>
> Thanks for the reply...I'm assuming that feature can't be disabled within
> smfPricesBetween() based on your response.
>
You could edit the code:
vHQ = RCHGetYahooHistory(pTicker, , , , , , , "d", "DOHLCV", 0, 1, 0,
Int(Now - pBegDate + 3), 6)
...just change that "1" parameter to a zero.
> I'm working on Turtle Trader spreadsheet looking for 50 day breakouts, so
> my preference is to use non-adjusted histories since charts and daily prices
> are also listed in non-adjusted prices.
>
So you're willing to allow a dividend (or stock split) event to prevent or
cause the identification of a breakout? OR -- a reverse split could trigger
a breakout signal.
The reason many charts have unadjusted prices is they are lazy. In general,
a dividend event is small enough that they don't consider it worth the
trouble. But many chart services had BIG issues several years ago when the
leveraged ETFs had huge distributions at year-end. And even a number of
mutual funds regularly have large distributions at year-end.
Thanks again for the time you've committed to the smf_addin and if you
> consider feature requests, I hope you'd consider adding a non-adjusted
> option for smfPricesBetween().
>
I've considered allowing a parameter to toggle it, but like I said -- I
can't think of a valid reason to use unadjusted prices. IMO, a dividend or
split event should NEVER affect the calculation of a technical indicator.
Even if one only wants the splits, most data services treat something like a
5% stock dividend as a 21-20 stock split.
- 4a.
-
StockHouse data errors
Posted by: "Bike bum" ttwilt@mchsi.com ttwilt
Fri Oct 21, 2011 8:15 pm (PDT)
Greetings, is any one besides myself unable to extract data from StockHouse? Specifically item numbers 802, 825,790 and 789. I have been using this data for quite a while but it has began returning error messages recently. Just wondering if it is on my end or if others are having the same problem.
- 4b.
-
Re: StockHouse data errors
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Oct 21, 2011 9:47 pm (PDT)
Looks like they dropped the data elements. What used to be a "technical
analysis page" is now an "analysts' page":
http://www.stockhouse.com/financial tools/sn_ technicalanalysi s.aspx?qm_ symbol=MMM
On Fri, Oct 21, 2011 at 8:15 PM, Bike bum <ttwilt@mchsi.com > wrote:
> Greetings, is any one besides myself unable to extract data from
> StockHouse? Specifically item numbers 802, 825,790 and 789. I have been
> using this data for quite a while but it has began returning error messages
> recently. Just wondering if it is on my end or if others are having the
> same problem.
>
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