Rabu, 04 Juli 2012

[smf_addin] Digest Number 2265

14 New Messages
Digest #2265
2b
4a
SMFTech Function on a weekly basis by "vzeppos@yahoo.com" vzeppos
4b
Re: SMFTech Function on a weekly basis by "Randy Harmelink" rharmelink

Tue Jul 3, 2012 1:47 pm (PDT) . Posted by: "bob_cutillo" bob_cutillo
Thank you.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> OptionsXPress has historical option quotes for account holders. But
> automating retrieval of them is not a trivial task as it does require a
> manual step.
>
> On Tue, Jul 3, 2012 at 12:11 PM, bob_cutillo <jbkbob@...> wrote:
>
> > Thank you for the information. If I could, the primary question seems to
> > have been chopped off. I wanted to know if there was a way to get
> > historcal premiums on a particular option. For example Jan 2013 GOOG Call
> > 565.00. If I wanted to find out the closing premium as of last Friday or
> > last month... If you have an SMF function which I wouldn't be surprised to
> > see, I'd love to see an example. If there is a website that I shows it, I
> > think I could probably manage the code by myself.
> >
>

Tue Jul 3, 2012 4:44 pm (PDT) . Posted by: "b.kopacz" b.kopacz
Thanks Randy.

This one might be a bit more challenging.
The link would be..
http://www.j3sg.com/Reports/Stock-Insider/Generate-Institution-Portfolio.php?DV=yes&institutionid=11216
Unfortunately, you would not be able to access the link not being a member. You will notice the excel link on the top right.
I have added the html code referencing the excel link and icon.
I am pretty sure I am out of luck but would love to hear you say it. :-)

Otherwise, know any good sites that report manager holdings, open, new, closed positions, etc.

Thanks again,
BK

<tr>
<td width="24%" align="right">
<font size="2" face="Tahoma">
<span class="info" onmousedown="MM_showHideLayers('Layer10','','hide','Layer11','','hide','Layer12','','hide','summaryHelp','','hide','chartHelp','','hide','download','','show')">
<img src="../../images/download.jpg">
</span>
</font>
</td>
<td height="26" width="58%">
<font size="2" face="Tahoma"> </font>
<font size="2" face="Tahoma">
<b class="o2" onmousedown="MM_showHideLayers('download','','show')">&nbsp;Download</b>
</font>
</td>
<td width="18%">&nbsp;</td>
</tr>

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> If they have an EXCEL file available, you don't even need the add-in. See:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/18984
>
> On Tue, Jul 3, 2012 at 12:41 PM, b.kopacz <bkopacz@...> wrote:
>
> >
> > I was utilizing the GetHTMLTable function to pull in a table of holdings
> > by a manager. The challenge I face here is that on the website it will
> > only show in blocks of 100 per page. So, my GetHTMLTablw will only bring
> > in 1-100 of however many there are total.
> > Essentially, 2000 holding would = 20 pages.
> >
> > My question is can I use some SMF function to auto download the excel file
> > that is made available. They have a link that would allow to download all
> > 2000 on a single sheet. My plan B would be to just bring in the excel file
> > and open as a sheet.
> >
> > Is that possible? Is there a function that would look to download the
> > excel file.
> >
> > I equate this similarly to my Ameritrade account. I can go look at my
> > transaction history.. or I can download the excel output of it.
> >
>

Tue Jul 3, 2012 5:57 pm (PDT) . Posted by: "Randy Harmelink" rharmelink
I can't tell what the button is doing -- it could be creating the XLS file,
in which case it wouldn't be available.

If the entity has a Morningstar ticker symbol, you could get their CSV file:

http://portfolios.morningstar.com/fund/holdingsExport?t=VFINX&exportType=details

On Tue, Jul 3, 2012 at 4:44 PM, b.kopacz <bkopacz@gmail.com> wrote:

>
> This one might be a bit more challenging.
> The link would be..
>
> http://www.j3sg.com/Reports/Stock-Insider/Generate-Institution-Portfolio.php?DV=yes&institutionid=11216
> Unfortunately, you would not be able to access the link not being a
> member. You will notice the excel link on the top right.
> I have added the html code referencing the excel link and icon.
> I am pretty sure I am out of luck but would love to hear you say it. :-)
>
> Otherwise, know any good sites that report manager holdings, open, new,
> closed positions, etc.
>
Tue Jul 3, 2012 7:59 pm (PDT) . Posted by: "investor952" investor952
Randy, the =RCHGetYahooHistory("^DJI") function suddenly stopped working in one of my spreadsheets. I noticed this yesterday..but get the same results today...all blanks...it is entered as an array. My operating system is Windows 7, 64 bit but my excel version, i believe, is 32 bit. This spreadsheet has worked fine until recently and I made no changes. It just started returning blanks...any idea why?

Tue Jul 3, 2012 8:09 pm (PDT) . Posted by: "investor952" investor952
FYI..I just tried the spreadsheet version that is on my former older msn windows xp computer and got the same results...the function has stopped working for me on both computers...any advice? thx.

--- In smf_addin@yahoogroups.com, "investor952" <investor952@...> wrote:
>
> Randy, the =RCHGetYahooHistory("^DJI") function suddenly stopped working in one of my spreadsheets. I noticed this yesterday..but get the same results today...all blanks...it is entered as an array. My operating system is Windows 7, 64 bit but my excel version, i believe, is 32 bit. This spreadsheet has worked fine until recently and I made no changes. It just started returning blanks...any idea why?
>

Tue Jul 3, 2012 8:11 pm (PDT) . Posted by: "Randy Harmelink" rharmelink
Because Yahoo is no longer carrying historical quotes on Dow Jones
indexes...

On Tue, Jul 3, 2012 at 7:59 PM, investor952 <investor952@yahoo.com> wrote:

> Randy, the =RCHGetYahooHistory("^DJI") function suddenly stopped working
> in one of my spreadsheets. I noticed this yesterday..but get the same
> results today...all blanks...it is entered as an array. My operating system
> is Windows 7, 64 bit but my excel version, i believe, is 32 bit. This
> spreadsheet has worked fine until recently and I made no changes. It just
> started returning blanks...any idea why?
>
Tue Jul 3, 2012 8:14 pm (PDT) . Posted by: "investor952" investor952
WHAT!?!? This kills all the work i put into many of my spreadsheets!!! Do you know of an alternative for similar data? thx.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Because Yahoo is no longer carrying historical quotes on Dow Jones
> indexes...
>
> On Tue, Jul 3, 2012 at 7:59 PM, investor952 <investor952@...> wrote:
>
> > Randy, the =RCHGetYahooHistory("^DJI") function suddenly stopped working
> > in one of my spreadsheets. I noticed this yesterday..but get the same
> > results today...all blanks...it is entered as an array. My operating system
> > is Windows 7, 64 bit but my excel version, i believe, is 32 bit. This
> > spreadsheet has worked fine until recently and I made no changes. It just
> > started returning blanks...any idea why?
> >
>

Tue Jul 3, 2012 8:18 pm (PDT) . Posted by: "investor952" investor952
hmmm..maybe I can use DIA instead of ^DJI ... but wouldn't be as accurate...why did they do this?

--- In smf_addin@yahoogroups.com, "investor952" <investor952@...> wrote:
>
> WHAT!?!? This kills all the work i put into many of my spreadsheets!!! Do you know of an alternative for similar data? thx.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Because Yahoo is no longer carrying historical quotes on Dow Jones
> > indexes...
> >
> > On Tue, Jul 3, 2012 at 7:59 PM, investor952 <investor952@> wrote:
> >
> > > Randy, the =RCHGetYahooHistory("^DJI") function suddenly stopped working
> > > in one of my spreadsheets. I noticed this yesterday..but get the same
> > > results today...all blanks...it is entered as an array. My operating system
> > > is Windows 7, 64 bit but my excel version, i believe, is 32 bit. This
> > > spreadsheet has worked fine until recently and I made no changes. It just
> > > started returning blanks...any idea why?
> > >
> >
>

Tue Jul 3, 2012 8:46 pm (PDT) . Posted by: "Randy Harmelink" rharmelink
The writing's been on the wall, ever since Dow Jones started thinking their
data was proprietary. Current quotes haven't been available for quite some
time via the CSV interface.

I prefer DIA because it includes the effects of dividends, but it was nice
to have a longer timeframe available.

On Tue, Jul 3, 2012 at 8:18 PM, investor952 <investor952@yahoo.com> wrote:

> hmmm..maybe I can use DIA instead of ^DJI ... but wouldn't be as
> accurate...why did they do this?
>
Tue Jul 3, 2012 8:56 pm (PDT) . Posted by: "Peter Urbani" purbani1
So much for increasing transparency in markets. You can't get the market
cap weights of the S&P500 index or sector indices for free either anymore
unless you basically reconstruct the index.

On Wed, Jul 4, 2012 at 3:46 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> The writing's been on the wall, ever since Dow Jones started thinking
> their data was proprietary. Current quotes haven't been available for quite
> some time via the CSV interface.
>
> I prefer DIA because it includes the effects of dividends, but it was nice
> to have a longer timeframe available.
>
> On Tue, Jul 3, 2012 at 8:18 PM, investor952 <investor952@yahoo.com> wrote:
>
>> hmmm..maybe I can use DIA instead of ^DJI ... but wouldn't be as
>> accurate...why did they do this?
>>
>
>
>

--

*Peter Urbani*

+64 21 0255 2816

LinkedIn Profile <http://nz.linkedin.com/in/peterurbani>

Skype peterurbani
Tue Jul 3, 2012 8:09 pm (PDT) . Posted by: "vzeppos@yahoo.com" vzeppos
I have a spreadsheet using the RCHGetYahooHistory Function. I would like to configure this spreadsheet to compute based on weekly data, instead of obtaining daily data. Is there a way to configure the function to obtain the data once a week? My intent is fot the "Adj open" to reflect Monday morning's price, "Adj Close" to reflect Friday's closing price, and have the "Adj High" and "Adj Low" to reflect the max and min prive throughout the week. Volume is a sumation of the daily volumes through the week as well.

Tue Jul 3, 2012 8:12 pm (PDT) . Posted by: "Randy Harmelink" rharmelink
Just use the parameter on the RCHGetYahooHistory() function to tell it to
return weekly data. Yahoo provides data in daily, weekly, and monthly
timeframes.

On Tue, Jul 3, 2012 at 7:16 PM, <vzeppos@yahoo.com> wrote:

> I have a spreadsheet using the RCHGetYahooHistory Function. I would like
> to configure this spreadsheet to compute based on weekly data, instead of
> obtaining daily data. Is there a way to configure the function to obtain
> the data once a week? My intent is fot the "Adj open" to reflect Monday
> morning's price, "Adj Close" to reflect Friday's closing price, and have
> the "Adj High" and "Adj Low" to reflect the max and min prive throughout
> the week. Volume is a sumation of the daily volumes through the week as
> well.
>
Wed Jul 4, 2012 12:31 am (PDT) . Posted by: "Chirag Vyas" vyas.chirag
I need help to fetch market price of companies trading in exchanges outside US - Berlin Stock Exchange, Johannesburg Stock Exchange, etc. It is available in Reuters/Bloomberg. I am working on MSCI index so this will be helpful.

For eg:- BMWG.BE (Ticker symbol for BMW trading on Berlin Stock Exchange)

Market Price Available at:-
http://www.reuters.com/finance/stocks/overview?symbol=BMWG.BE

It will be helpful if I am able to fetch market prices for all my tickers. Thanks

Chirag Vyas.

Wed Jul 4, 2012 1:25 am (PDT) . Posted by: "Randy Harmelink" rharmelink
For that symbol, this appears to work:

=0+smfGetTagContent("
http://www.reuters.com/finance/stocks/overview?symbol=BMWG.BE
","span",2,"sectionQuoteDetail")

...but I don't know how consistent "sectionQuoteDetail" will work as a
search string. But I wouldn't suggest using it for a lot of tickers.

On Wed, Jul 4, 2012 at 12:31 AM, Chirag Vyas <vyas.chirag@yahoo.in> wrote:

> I need help to fetch market price of companies trading in exchanges
> outside US - Berlin Stock Exchange, Johannesburg Stock Exchange, etc. It is
> available in Reuters/Bloomberg. I am working on MSCI index so this will be
> helpful.
>
> For eg:- BMWG.BE (Ticker symbol for BMW trading on Berlin Stock Exchange)
>
> Market Price Available at:-
> http://www.reuters.com/finance/stocks/overview?symbol=BMWG.BE
>
>
> It will be helpful if I am able to fetch market prices for all my tickers.
> Thanks
>

Tidak ada komentar:

Posting Komentar