6 New Messages
Digest #2680
Messages
Wed Jul 3, 2013 5:28 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
RCHGetYahooQuotes() can retrieve price, EPS, and Yield for up to 200 stocks
per function invocation.
But I'm not sure that is the question you are asking?
You can set the function up for 200 stocks, even though you are only using
the first 40 slots. Just add more stocks as needed. You can sort the ticker
list, but not the array-entered formula area. But once you sort the ticker
list, the array-entered formula area will update with the new values for
the new sorted range.
On Sat, Jun 29, 2013 at 8:51 AM, graeb2 <ezguide@bardstowncable.net > wrote:
> I would like to automate the retrieval of Price, TTM Earnings, and
> Dividend into a spreadsheet that I manually update with Value Line data.
>
> I have downloaded and successfully tested the Add-Ins.
>
> Not being an expert on Excel, I can say that I use the Lists function.
> That seems to cause trouble with entering formulas.
>
> Also, the list is in excess of 200 securities and Yahoo rejected a request
> for 200 quotes.
>
> Any suggestions on how to go about this. By the way, I am very weak on
> using ranges. When I've tried, it seems impossible to modify a sheet
> further. I need to be able to add and remove securities.
>
per function invocation.
But I'm not sure that is the question you are asking?
You can set the function up for 200 stocks, even though you are only using
the first 40 slots. Just add more stocks as needed. You can sort the ticker
list, but not the array-entered formula area. But once you sort the ticker
list, the array-entered formula area will update with the new values for
the new sorted range.
On Sat, Jun 29, 2013 at 8:51 AM, graeb2 <ezguide@bardstownca
> I would like to automate the retrieval of Price, TTM Earnings, and
> Dividend into a spreadsheet that I manually update with Value Line data.
>
> I have downloaded and successfully tested the Add-Ins.
>
> Not being an expert on Excel, I can say that I use the Lists function.
> That seems to cause trouble with entering formulas.
>
> Also, the list is in excess of 200 securities and Yahoo rejected a request
> for 200 quotes.
>
> Any suggestions on how to go about this. By the way, I am very weak on
> using ranges. When I've tried, it seems impossible to modify a sheet
> further. I need to be able to add and remove securities.
>
Wed Jul 3, 2013 5:30 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not sure there is a good (free) alternative source to Yahoo, at least
of O/H/L/C/V data.
I don't really download data any more, preferring to let the online data
sources maintain the data.
On Tue, Jul 2, 2013 at 5:46 PM, terrio_r <terrio-r@charter.net > wrote:
> I would like to thank you for developing and enhancing a good alternative
> for entering stock data into Excel and sharing it. With MS totally screwing
> up getting stock quotes into Excel 2003 with MSN Stock Quotes Excel Add-in
> which I have been using for years but with decreasing reliability I decided
> to bite the bullet and try SMF. A little bit of growing pains, but got it
> up and running in a couple of days. Was very disappointed at first because
> it was so slow and recalculated every time I entered something in another
> cell. Finally figured out I needed to use the array input. What a
> difference. Lightning fast.
>
> I also investigated using GoogleFinance functions in Google sheets to have
> a backup when Yahoo was sick (like yesterday & earlier today). But didn't
> take long to figure out it could not come close to doing what I need.
> Documentation isn't very good either. Would like to know if you have a good
> alternate source to backup Yahoo data. I have a manual backup download of
> data from Yahoo that I developed for MSN Stock Quotes when it screwed up.
> But that doesn't do me any good now.
>
> Thanks again for all your work & sharing.
>
of O/H/L/C/V data.
I don't really download data any more, preferring to let the online data
sources maintain the data.
On Tue, Jul 2, 2013 at 5:46 PM, terrio_r <terrio-r@charter.
> I would like to thank you for developing and enhancing a good alternative
> for entering stock data into Excel and sharing it. With MS totally screwing
> up getting stock quotes into Excel 2003 with MSN Stock Quotes Excel Add-in
> which I have been using for years but with decreasing reliability I decided
> to bite the bullet and try SMF. A little bit of growing pains, but got it
> up and running in a couple of days. Was very disappointed at first because
> it was so slow and recalculated every time I entered something in another
> cell. Finally figured out I needed to use the array input. What a
> difference. Lightning fast.
>
> I also investigated using GoogleFinance functions in Google sheets to have
> a backup when Yahoo was sick (like yesterday & earlier today). But didn't
> take long to figure out it could not come close to doing what I need.
> Documentation isn't very good either. Would like to know if you have a good
> alternate source to backup Yahoo data. I have a manual backup download of
> data from Yahoo that I developed for MSN Stock Quotes when it screwed up.
> But that doesn't do me any good now.
>
> Thanks again for all your work & sharing.
>
Wed Jul 3, 2013 10:27 am (PDT) . Posted by:
"terrio_r" terrio_r
I only download data for my hold/sell decision spreadsheet which I need to refresh everyday with todays prices and then modify per my rules. Unfortunately number of stks/mutfds followed has increased as I continue to track positions I once owned or am interested in. So it makes life much easier if I can download the days data rather than entering everything in manually. So I need a reliable free source that downloads time & date of price downloaded for each which Yahoo does a great job doing.
Keep up the good work.
Bob
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I'm not sure there is a good (free) alternative source to Yahoo, at least
> of O/H/L/C/V data.
>
> I don't really download data any more, preferring to let the online data
> sources maintain the data.
>
> On Tue, Jul 2, 2013 at 5:46 PM, terrio_r <terrio-r@...> wrote:
>
> > I would like to thank you for developing and enhancing a good alternative
> > for entering stock data into Excel and sharing it. With MS totally screwing
> > up getting stock quotes into Excel 2003 with MSN Stock Quotes Excel Add-in
> > which I have been using for years but with decreasing reliability I decided
> > to bite the bullet and try SMF. A little bit of growing pains, but got it
> > up and running in a couple of days. Was very disappointed at first because
> > it was so slow and recalculated every time I entered something in another
> > cell. Finally figured out I needed to use the array input. What a
> > difference. Lightning fast.
> >
> > I also investigated using GoogleFinance functions in Google sheets to have
> > a backup when Yahoo was sick (like yesterday & earlier today). But didn't
> > take long to figure out it could not come close to doing what I need.
> > Documentation isn't very good either. Would like to know if you have a good
> > alternate source to backup Yahoo data. I have a manual backup download of
> > data from Yahoo that I developed for MSN Stock Quotes when it screwed up.
> > But that doesn't do me any good now.
> >
> > Thanks again for all your work & sharing.
> >
>
Keep up the good work.
Bob
--- In smf_addin@yahoogrou
>
> I'm not sure there is a good (free) alternative source to Yahoo, at least
> of O/H/L/C/V data.
>
> I don't really download data any more, preferring to let the online data
> sources maintain the data.
>
> On Tue, Jul 2, 2013 at 5:46 PM, terrio_r <terrio-r@
>
> > I would like to thank you for developing and enhancing a good alternative
> > for entering stock data into Excel and sharing it. With MS totally screwing
> > up getting stock quotes into Excel 2003 with MSN Stock Quotes Excel Add-in
> > which I have been using for years but with decreasing reliability I decided
> > to bite the bullet and try SMF. A little bit of growing pains, but got it
> > up and running in a couple of days. Was very disappointed at first because
> > it was so slow and recalculated every time I entered something in another
> > cell. Finally figured out I needed to use the array input. What a
> > difference. Lightning fast.
> >
> > I also investigated using GoogleFinance functions in Google sheets to have
> > a backup when Yahoo was sick (like yesterday & earlier today). But didn't
> > take long to figure out it could not come close to doing what I need.
> > Documentation isn't very good either. Would like to know if you have a good
> > alternate source to backup Yahoo data. I have a manual backup download of
> > data from Yahoo that I developed for MSN Stock Quotes when it screwed up.
> > But that doesn't do me any good now.
> >
> > Thanks again for all your work & sharing.
> >
>
Wed Jul 3, 2013 6:39 am (PDT) . Posted by:
"Brett" bpeven
I just uploaded a file called holdings lookup that I'm having several problems with:
1) I can't get anything beyond holding #11 even though each page shows 30 holdings.
2) I'm having problems making the spreadsheet dynamic with respect to dates of holding, i.e. see http://www.insidermonkey.com/hedge-fund/greenlight+capital/15/holdings/#/offset=0&ffp=2013-03-31&fot=7&fso=1 ...
and the drop down called Showing.
3) I'm having problems adding holdings from page 2 and on to the sheet.
4) There is a column entitled Activity that gives key information as a graphic on the page that doesn't show up on the spreadsheet. Is there a way to add this?
I appreciate any and all help.
BP
1) I can't get anything beyond holding #11 even though each page shows 30 holdings.
2) I'm having problems making the spreadsheet dynamic with respect to dates of holding, i.e. see http://www.insiderm
and the drop down called Showing.
3) I'm having problems adding holdings from page 2 and on to the sheet.
4) There is a column entitled Activity that gives key information as a graphic on the page that doesn't show up on the spreadsheet. Is there a way to add this?
I appreciate any and all help.
BP
Wed Jul 3, 2013 8:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
1. The page only shows 30 holdings if you're logged in. You would need
to have created an IE security cookie for the add-in to access login-only
data.
2. The initial response for such a request is a 404 -- web page not
found. So they must be generating the web page AFTER that, which the add-in
then has no access to.
3. I don't see such an option, but I'm not logged in. Likely cause is
that they are generated web pages as well. Anything generated on the fly
will not be available to the add-in, since it extracts data from the source
code of the web pages.
4. I don't see a good example of it in use, but it appears you may need
to use the smfGetTagContent() function to grab the HTML coding of the table
cell and then parse and interpret it, as needed.
On Wed, Jul 3, 2013 at 6:39 AM, Brett <bpeven@yahoo.com > wrote:
> I just uploaded a file called holdings lookup that I'm having several
> problems with:
>
> 1) I can't get anything beyond holding #11 even though each page shows 30
> holdings.
>
> 2) I'm having problems making the spreadsheet dynamic with respect to
> dates of holding, i.e. see
> http://www.insidermonkey.com/hedge-fund/greenlight+capital/15/holdings/#/offset=0&ffp=2013-03-31&fot=7&fso=1 ...
>
> and the drop down called Showing.
>
> 3) I'm having problems adding holdings from page 2 and on to the sheet.
>
> 4) There is a column entitled Activity that gives key information as a
> graphic on the page that doesn't show up on the spreadsheet. Is there a
> way to add this?
>
> I appreciate any and all help.
>
to have created an IE security cookie for the add-in to access login-only
data.
2. The initial response for such a request is a 404 -- web page not
found. So they must be generating the web page AFTER that, which the add-in
then has no access to.
3. I don't see such an option, but I'm not logged in. Likely cause is
that they are generated web pages as well. Anything generated on the fly
will not be available to the add-in, since it extracts data from the source
code of the web pages.
4. I don't see a good example of it in use, but it appears you may need
to use the smfGetTagContent(
cell and then parse and interpret it, as needed.
On Wed, Jul 3, 2013 at 6:39 AM, Brett <bpeven@yahoo.
> I just uploaded a file called holdings lookup that I'm having several
> problems with:
>
> 1) I can't get anything beyond holding #11 even though each page shows 30
> holdings.
>
> 2) I'm having problems making the spreadsheet dynamic with respect to
> dates of holding, i.e. see
> http://www.insiderm
>
> and the drop down called Showing.
>
> 3) I'm having problems adding holdings from page 2 and on to the sheet.
>
> 4) There is a column entitled Activity that gives key information as a
> graphic on the page that doesn't show up on the spreadsheet. Is there a
> way to add this?
>
> I appreciate any and all help.
>
Wed Jul 3, 2013 10:48 am (PDT) . Posted by:
"Mac" mac_rmm
I tried plugging in the fulldisclosure link into the GetElementNumber like you did but what was weird is that it only gave me info for a few of the number (basically 1286 through 1291). I get errors for everything else.
Did you have the same issue or are there any suggestions you have? Thanks.
--- In smf_addin@yahoogroups.com , "sjagers" <sjagers@...> wrote:
>
> Randy,
> Hooray.... it works!!!
> I replaced www.earnings.com with www.fulldisclosure.com and it extracts the same data as before.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > All the definitions are in smf-elements-8.txt. Looks like you could just do
> > a "find and replace all" on the domain.
> >
> > On Wed, Jun 26, 2013 at 7:07 PM, sjagers <sjagers@> wrote:
> >
> > > Randy.... Could this be the new URL for earnings.com data?
> > >
> > > http://www.fulldisclosure.com/company.asp?ticker=PAYX&coid=87087&client=cb
> > >
> > > The URL, abovve, is for Paychex earnings history.
> > >
> > > I just did an internet search and it popped up. Looks just like the
> > > previous website.
> > >
> > > Can I modify your GetElementNumber macro or text file to see if we can
> > > pull data from the website?
> > >
> > >
> >
>
Did you have the same issue or are there any suggestions you have? Thanks.
--- In smf_addin@yahoogrou
>
> Randy,
> Hooray.... it works!!!
> I replaced www.earnings.
>
> --- In smf_addin@yahoogrou
> >
> > All the definitions are in smf-elements-
> > a "find and replace all" on the domain.
> >
> > On Wed, Jun 26, 2013 at 7:07 PM, sjagers <sjagers@
> >
> > > Randy.... Could this be the new URL for earnings.com data?
> > >
> > > http://www.fulldisc
> > >
> > > The URL, abovve, is for Paychex earnings history.
> > >
> > > I just did an internet search and it popped up. Looks just like the
> > > previous website.
> > >
> > > Can I modify your GetElementNumber macro or text file to see if we can
> > > pull data from the website?
> > >
> > >
> >
>
Tidak ada komentar:
Posting Komentar