9 New Messages
Digest #2825
Messages
Wed Oct 23, 2013 1:35 am (PDT) . Posted by:
"Kai Friedrichs" kai_friedrichs
Thanks a lot for the information Randy! Could you please tell me, how the the add-in from the "Works in Progress" folder, which allows a download of the AdvFN-data is called? I tried several files from this folder, but was not successful.
Thanks again!
Kai
Randy Harmelink <rharmelink@gmail.com> schrieb am 21:21 Dienstag, 22.Oktober 2013:
Not with RCHGetYahooHistory(). That isn't something Yahoo provides.
The best source is AdvFN. However, they've recently been updating their website, so you'll need the beta version of the add-in from the "Works in Progress" folder to access the elements defined for their site.
Or you could access them directly:
http://www.advfn.com/exchanges/NYSE/MMM/financials?btn=quarterly_reports&mode=company_data
Someone recently noted that Zacks has a page on earnings as well:
http://www.zacks.com/stock/research/IBM/earnings-announcements
On Tue, Oct 22, 2013 at 11:31 AM, Kai Friedrichs <kai_friedrichs@yahoo.de> wrote:
>
>is there a possibility to get not only the price history but also the history of Earnings or Price/Earnings-Ratios with the help of RCHGetYahooHistory() ?
>If not, is there any other possibility to get the history of these numbers beside the history of stock prices in an Excel-Sheet?
>Would be great to get some information on these question!
>
>
Thanks again!
Kai
Randy Harmelink <rharmelink@gmail.
Not with RCHGetYahooHistory(
The best source is AdvFN. However, they've recently been updating their website, so you'll need the beta version of the add-in from the "Works in Progress" folder to access the elements defined for their site.
Or you could access them directly:
http://www.advfn.
Someone recently noted that Zacks has a page on earnings as well:
http://www.zacks.
On Tue, Oct 22, 2013 at 11:31 AM, Kai Friedrichs <kai_friedrichs@
>
>is there a possibility to get not only the price history but also the history of Earnings or Price/Earnings-
>If not, is there any other possibility to get the history of these numbers beside the history of stock prices in an Excel-Sheet?
>Would be great to get some information on these question!
>
>
Wed Oct 23, 2013 2:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just follow the installation directions (from the "Documentation" folder of
the FILES area of the group), using the ZIP file from the "Works in
Progress" folder.
The XLS file in the ZIP file lists all the elements available. For example,
to get the closing P/E ratio for the most current fiscal year of ticker
"MMM":
=RCHGetElementNumber("MMM";,7256)
On Wed, Oct 23, 2013 at 1:34 AM, Kai Friedrichs <kai_friedrichs@yahoo.de>wrote:
>
> Thanks a lot for the information Randy! Could you please tell me, how the the
> add-in from the "Works in Progress" folder, which allows a download of the
> AdvFN-data is called? I tried several files from this folder, but was not
> successful.
>
>
the FILES area of the group), using the ZIP file from the "Works in
Progress" folder.
The XLS file in the ZIP file lists all the elements available. For example,
to get the closing P/E ratio for the most current fiscal year of ticker
"MMM"
=RCHGetElementNumbe
On Wed, Oct 23, 2013 at 1:34 AM, Kai Friedrichs <kai_friedrichs@
>
> Thanks a lot for the information Randy! Could you please tell me, how the the
> add-in from the "Works in Progress" folder, which allows a download of the
> AdvFN-data is called? I tried several files from this folder, but was not
> successful.
>
>
Wed Oct 23, 2013 5:48 am (PDT) . Posted by:
stumpy_chris
Yes - got this working thanks a lot. All I need is the end of day pricing.
Wondering of there was anyway to pull Mutual Fund Day end quotes from Globe Investor.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
That's the value Yahoo is providing on their CSV file feed (which is what RCHGetYahooQuotes() uses).
However, since they do carry historical quotes, you could get the most recent closing price with:
=RCHGetYahooHistory("F0CAN071IY.TO http://F0CAN071IY.TO",,,,,,,,"a",0)
...but the current day's quote probably won't be available until about 6 pm EST.
On Mon, Oct 21, 2013 at 5:47 PM, <cschwartz@... mailto:cschwartz@...> wrote:
Thanks... Worked for your example, but I am trying it for Russell Lifepoints Balanced Sr B - here is the symbol from Yahoo Finance (F0CAN071IY.TO http://F0CAN071IY.TO) and I get 0 value.
Wondering of there was anyway to pull Mutual Fund Day end quotes from Globe Investor.
---In smf_addin@yahoogrou
That's the value Yahoo is providing on their CSV file feed (which is what RCHGetYahooQuotes(
However, since they do carry historical quotes, you could get the most recent closing price with:
=RCHGetYahooHistory
...but the current day's quote probably won't be available until about 6 pm EST.
On Mon, Oct 21, 2013 at 5:47 PM, <cschwartz@
Thanks... Worked for your example, but I am trying it for Russell Lifepoints Balanced Sr B - here is the symbol from Yahoo Finance (F0CAN071IY.
Wed Oct 23, 2013 5:57 am (PDT) . Posted by:
stumpy_chris
Sorry and better yet - can you pull fund prices from Morningstar.
---In smf_addin@yahoogroups.com, <cschwartz@...> wrote:
Yes - got this working thanks a lot. All I need is the end of day pricing.
Wondering of there was anyway to pull Mutual Fund Day end quotes from Globe Investor.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
That's the value Yahoo is providing on their CSV file feed (which is what RCHGetYahooQuotes() uses).
However, since they do carry historical quotes, you could get the most recent closing price with:
=RCHGetYahooHistory("F0CAN071IY.TO http://F0CAN071IY.TO",,,,,,,,"a",0)
...but the current day's quote probably won't be available until about 6 pm EST.
On Mon, Oct 21, 2013 at 5:47 PM, <cschwartz@... mailto:cschwartz@...> wrote:
Thanks... Worked for your example, but I am trying it for Russell Lifepoints Balanced Sr B - here is the symbol from Yahoo Finance (F0CAN071IY.TO http://F0CAN071IY.TO) and I get 0 value.
---In smf_addin@yahoogrou
Yes - got this working thanks a lot. All I need is the end of day pricing.
Wondering of there was anyway to pull Mutual Fund Day end quotes from Globe Investor.
---In smf_addin@yahoogrou
That's the value Yahoo is providing on their CSV file feed (which is what RCHGetYahooQuotes(
However, since they do carry historical quotes, you could get the most recent closing price with:
=RCHGetYahooHistory
...but the current day's quote probably won't be available until about 6 pm EST.
On Mon, Oct 21, 2013 at 5:47 PM, <cschwartz@
Thanks... Worked for your example, but I am trying it for Russell Lifepoints Balanced Sr B - here is the symbol from Yahoo Finance (F0CAN071IY.
Wed Oct 23, 2013 8:17 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sample URLs please.
On Wed, Oct 23, 2013 at 5:48 AM, <cschwartz@nf.sympatico.ca> wrote:
>
> Wondering of there was anyway to pull Mutual Fund Day end quotes from
> Globe Investor.
>
>
On Wed, Oct 23, 2013 at 5:57 AM, <cschwartz@nf.sympatico.ca> wrote:
> Sorry and better yet - can you pull fund prices from Morningstar.
>
On Wed, Oct 23, 2013 at 5:48 AM, <cschwartz@nf.
>
> Wondering of there was anyway to pull Mutual Fund Day end quotes from
> Globe Investor.
>
>
On Wed, Oct 23, 2013 at 5:57 AM, <cschwartz@nf.
> Sorry and better yet - can you pull fund prices from Morningstar.
>
Wed Oct 23, 2013 6:41 am (PDT) . Posted by:
alexcomp1
I have been doing some of my own spreadsheet creation in order to analyze various options positions that I own or contemplate owning.
I have done a couple of searches within this group and haven't come up with anything to indicate that there are spreadsheets already done, but if there are I would rather not have to continually reinvent the wheel.
As an example, I own an Apple butterfly dated November 16 ( 3/6/3 470/520/570 ).
I manually created a spreadsheet that takes my initial investment and runs it against a matrix of prices showing breakeven point and profit or loss . I have seen graphics on " options action" that graphically display "hockey stick " charts . it seems that it would also be possible to to manipulate the "fly" as it marches toward expiration by manipulating components and illustrating how that would affect profitability. ( buy to close the middle leg greatly increasing upside potential)
are there templates for this kind of spreadsheet or is it possible that I am misunderstanding the nature of this group ? perhaps all that is being done here are functions and there are no predefined , target oriented spreadsheets.
I have done a couple of searches within this group and haven't come up with anything to indicate that there are spreadsheets already done, but if there are I would rather not have to continually reinvent the wheel.
As an example, I own an Apple butterfly dated November 16 ( 3/6/3 470/520/570 ).
I manually created a spreadsheet that takes my initial investment and runs it against a matrix of prices showing breakeven point and profit or loss . I have seen graphics on " options action" that graphically display "hockey stick " charts . it seems that it would also be possible to to manipulate the "fly" as it marches toward expiration by manipulating components and illustrating how that would affect profitability. ( buy to close the middle leg greatly increasing upside potential)
are there templates for this kind of spreadsheet or is it possible that I am misunderstanding the nature of this group ? perhaps all that is being done here are functions and there are no predefined , target oriented spreadsheets.
Wed Oct 23, 2013 8:16 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Most of the templates here are more "building block" types of things
instead of finished products. Because there are just so many ways to
present and manipulate the data.
I do have a couple of covered call type workbooks over in the
JustCoveredCalls Yahoo group, but the only ones here are examples of the
functions themselves.
On Wed, Oct 23, 2013 at 6:41 AM, <sgg@alexcomp.com> wrote:
> I have been doing some of my own spreadsheet creation in order to
> analyze various options positions that I own or contemplate owning.
>
> I have done a couple of searches within this group and haven't come up
> with anything to indicate that there are spreadsheets already done, but if
> there are I would rather not have to continually reinvent the wheel.
>
> As an example, I own an Apple butterfly dated November 16 ( 3/6/3
> 470/520/570 ).
>
> I manually created a spreadsheet that takes my initial investment and
> runs it against a matrix of prices showing breakeven point and profit or
> loss . I have seen graphics on " options action" that graphically display
> "hockey stick " charts . it seems that it would also be possible to to
> manipulate the "fly" as it marches toward expiration by manipulating
> components and illustrating how that would affect profitability. ( buy to
> close the middle leg greatly increasing upside potential)
>
> are there templates for this kind of spreadsheet or is it possible that I
> am misunderstanding the nature of this group ? perhaps all that is being
> done here are functions and there are no predefined , target oriented
> spreadsheets.
>
instead of finished products. Because there are just so many ways to
present and manipulate the data.
I do have a couple of covered call type workbooks over in the
JustCoveredCalls Yahoo group, but the only ones here are examples of the
functions themselves.
On Wed, Oct 23, 2013 at 6:41 AM, <sgg@alexcomp.
> I have been doing some of my own spreadsheet creation in order to
> analyze various options positions that I own or contemplate owning.
>
> I have done a couple of searches within this group and haven't come up
> with anything to indicate that there are spreadsheets already done, but if
> there are I would rather not have to continually reinvent the wheel.
>
> As an example, I own an Apple butterfly dated November 16 ( 3/6/3
> 470/520/570 ).
>
> I manually created a spreadsheet that takes my initial investment and
> runs it against a matrix of prices showing breakeven point and profit or
> loss . I have seen graphics on " options action" that graphically display
> "hockey stick " charts . it seems that it would also be possible to to
> manipulate the "fly" as it marches toward expiration by manipulating
> components and illustrating how that would affect profitability. ( buy to
> close the middle leg greatly increasing upside potential)
>
> are there templates for this kind of spreadsheet or is it possible that I
> am misunderstanding the nature of this group ? perhaps all that is being
> done here are functions and there are no predefined , target oriented
> spreadsheets.
>
Wed Oct 23, 2013 9:36 pm (PDT) . Posted by:
ronnyrode21
I was wondering if someone would know why I am getting errors with the following commands. I tried researching and cannot figure it out. I just get the word "error". Any help would be great as this has stumped me over the last week. Thank you!
=RCHGetElementNumber(Ticker,15002)
=RCHGetElementNumber(Ticker,15004)
=RCHGetElementNumber(Ticker,15005)
=RCHGetElementNumber(Ticker,15006)
=RCHGetElementNumber(Ticker,15008)
=RCHGetElementNumber(Ticker,15009)
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetElementNumbe
Wed Oct 23, 2013 9:42 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
They all use AdvFN data items for their calculation. You need to be using
the beta version of the add-in from the "Works in Progress" folder for them
to work right now. That's because AdvFN has been messing around with their
web pages the last few months. I just updated the add-in a week ago,
because it looked like they finally got their web pages working again.
If you are using the beta version of the add-in, are you in a non-USA
region? That may be another issue.
On Wed, Oct 23, 2013 at 9:23 PM, <ronnyrode21@yahoo.com> wrote:
>
> I was wondering if someone would know why I am getting errors with the
> following commands. I tried researching and cannot figure it out. I just
> get the word "error". Any help would be great as this has stumped me over
> the last week. Thank you!
>
> =RCHGetElementNumber(Ticker,15002)
> =RCHGetElementNumber(Ticker,15004)
> =RCHGetElementNumber(Ticker,15005)
> =RCHGetElementNumber(Ticker,15006)
> =RCHGetElementNumber(Ticker,15008)
> =RCHGetElementNumber(Ticker,15009)
>
the beta version of the add-in from the "Works in Progress" folder for them
to work right now. That's because AdvFN has been messing around with their
web pages the last few months. I just updated the add-in a week ago,
because it looked like they finally got their web pages working again.
If you are using the beta version of the add-in, are you in a non-USA
region? That may be another issue.
On Wed, Oct 23, 2013 at 9:23 PM, <ronnyrode21@
>
> I was wondering if someone would know why I am getting errors with the
> following commands. I tried researching and cannot figure it out. I just
> get the word "error"
> the last week. Thank you!
>
> =RCHGetElementNumbe
> =RCHGetElementNumbe
> =RCHGetElementNumbe
> =RCHGetElementNumbe
> =RCHGetElementNumbe
> =RCHGetElementNumbe
>
Tidak ada komentar:
Posting Komentar