Messages In This Digest (25 Messages)
- 1a.
- Re: Reuters data using RCHGetElementNumber From: Randy Harmelink
- 1b.
- Re: Reuters data using RCHGetElementNumber From: jrgeico
- 1c.
- Re: Reuters data using RCHGetElementNumber From: Randy Harmelink
- 1d.
- Re: Reuters data using RCHGetElementNumber From: jrgeico
- 1e.
- Re: Reuters data using RCHGetElementNumber From: Randy Harmelink
- 2a.
- Re: 600 stock data (quarterly earnings and dates) from Zacks Media s From: V. Shankar
- 2b.
- Re: 600 stock data (quarterly earnings and dates) from Zacks Media s From: Randy Harmelink
- 2c.
- Re: 600 stock data (quarterly earnings and dates) from Zacks Media s From: V. Shankar
- 3.1.
- New file uploaded to smf_addin From: smf_addin@yahoogroups.com
- 4a.
- Guru Focus Question From: Brett
- 4b.
- Re: Guru Focus Question From: Randy Harmelink
- 5a.
- Tickers for stocks listed in european markets? From: nikos chryssochoidis
- 5b.
- Re: Tickers for stocks listed in european markets? From: kostas
- 5c.
- Re: Tickers for stocks listed in european markets? From: nikos chryssochoidis
- 5d.
- Re: Tickers for stocks listed in european markets? From: paul messerschmidt
- 5e.
- Re: Tickers for stocks listed in european markets? From: nikos chryssochoidis
- 5f.
- Re: Tickers for stocks listed in european markets? From: kostas
- 5g.
- Re: Tickers for stocks listed in european markets? From: nikos chryssochoidis
- 6a.
- forced recalculation From: ghlentz2000
- 6b.
- Re: forced recalculation From: Mike McQuaid
- 6c.
- Re: forced recalculation From: Randy Harmelink
- 7a.
- Maxing Out on Data Downloads using SMF Add-in... Any solutions aroun From: ro.valen
- 7b.
- Re: Maxing Out on Data Downloads using SMF Add-in... Any solutions a From: Martin Topper
- 7c.
- Re: Maxing Out on Data Downloads using SMF Add-in... Any solutions a From: Randy Harmelink
- 7d.
- Re: Maxing Out on Data Downloads using SMF Add-in... Any solutions a From: ro.valen
Messages
- 1a.
-
Re: Reuters data using RCHGetElementNumber
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Dec 6, 2011 2:48 am (PST)
For the AdvFN problem, check the AdvFN item in the "Links" area of the
group...
I'm not aware of any Valueline elements?
On Tue, Dec 6, 2011 at 2:48 AM, jrgeico <rerren.jeroen@gmail.com > wrote:
> So still not quite there yet. I am experiencing the same problems with
> Valueline and advfn.
>
> I created an account and logged into advfn using the web query. I also
> managed to download data into my sheet (and saved the query like the
> tutorial on that one website) but the advfin links unfortunately do not
> update.
>
> I also restarted excel but to no avail..
>
> I am using formulas such as:
>
> =RCHGetElementNumber(Ticker, 5451)
>
> Yahoo, MSN, Google, Reuters links do work..
>
> Any ideas?
>
> Thanks!
>
- 1b.
-
Re: Reuters data using RCHGetElementNumber
Posted by: "jrgeico" rerren.jeroen@gmail.com jrgeico
Tue Dec 6, 2011 5:35 am (PST)
So yeah I feel pretty stupid, from now on I will thorougly check all that is available in the group folders.
I can confirm the solution of changing IE security settings.. Thanks man!
Concerning the valueline, I found this line in the Cashflow17S sheet
Using:
=RCHGetTablecell(AL17,4,"Beta: ")
with AL17 being:
="http://www3.valueline. "&Tickercom/vlquotes/ quote.aspx? symbol=
I wanted to check for the beta (for completeness) but it does not yet retrieve this data. I am at work now so I will be checking this when I get home (it's nothing urgent).
Thanks for the help, if I get rich using this addin I will surely donate :)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> For the AdvFN problem, check the AdvFN item in the "Links" area of the
> group...
>
> I'm not aware of any Valueline elements?
>
> On Tue, Dec 6, 2011 at 2:48 AM, jrgeico <rerren.jeroen@...> wrote:
>
> > So still not quite there yet. I am experiencing the same problems with
> > Valueline and advfn.
> >
> > I created an account and logged into advfn using the web query. I also
> > managed to download data into my sheet (and saved the query like the
> > tutorial on that one website) but the advfin links unfortunately do not
> > update.
> >
> > I also restarted excel but to no avail..
> >
> > I am using formulas such as:
> >
> > =RCHGetElementNumber(Ticker, 5451)
> >
> > Yahoo, MSN, Google, Reuters links do work..
> >
> > Any ideas?
> >
> > Thanks!
> >
>
- 1c.
-
Re: Reuters data using RCHGetElementNumber
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Dec 6, 2011 6:44 am (PST)
Ah. Not an element, though. That's a different add-in function. But
Valueline doesn't have that data in a table. Try this formula:
=0+smfStrExtr("|"&smfGetTagCon tent("
http://www3.valueline. ","div",1,"Beta:com/vlquotes/ quote.aspx? symbol=MMM "),"|","
")
On Tue, Dec 6, 2011 at 6:35 AM, jrgeico <rerren.jeroen@gmail.com > wrote:
>
> Concerning the valueline, I found this line in the Cashflow17S sheet
>
> Using:
>
> =RCHGetTablecell(AL17,4,"Beta: ")
>
> with AL17 being:
>
> ="http://www3.valueline. "&Tickercom/vlquotes/ quote.aspx? symbol=
>
> I wanted to check for the beta (for completeness) but it does not yet
> retrieve this data. I am at work now so I will be checking this when I get
> home (it's nothing urgent).
>
> Thanks for the help, if I get rich using this addin I will surely donate :)
>
- 1d.
-
Re: Reuters data using RCHGetElementNumber
Posted by: "jrgeico" rerren.jeroen@gmail.com jrgeico
Tue Dec 6, 2011 7:42 am (PST)
Like usual it works :)
It seems that the beta is not often available so I changed it into:
=IFERROR(0+smfStrExtr("|"&smfGetTag Content("http://www3. valueline. "&Ticker,"div"com/vlquotes/ quote.aspx? symbol= ,1,"Beta: "),"|"," "),"")
which automates this process when changing the ticker symbol.
That is (unfortunately :D) my little value added of the day..
Thanks Randy!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Ah. Not an element, though. That's a different add-in function. But
> Valueline doesn't have that data in a table. Try this formula:
>
> =0+smfStrExtr("|"&smfGetTagCon tent("
> http://www3.valueline. ","div",1,"Beta:com/vlquotes/ quote.aspx? symbol=MMM "),"|","
> ")
>
> On Tue, Dec 6, 2011 at 6:35 AM, jrgeico <rerren.jeroen@...> wrote:
>
> >
> > Concerning the valueline, I found this line in the Cashflow17S sheet
> >
> > Using:
> >
> > =RCHGetTablecell(AL17,4,"Beta: ")
> >
> > with AL17 being:
> >
> > ="http://www3.valueline. "&Tickercom/vlquotes/ quote.aspx? symbol=
> >
> > I wanted to check for the beta (for completeness) but it does not yet
> > retrieve this data. I am at work now so I will be checking this when I get
> > home (it's nothing urgent).
> >
> > Thanks for the help, if I get rich using this addin I will surely donate :)
> >
>
- 1e.
-
Re: Reuters data using RCHGetElementNumber
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Dec 6, 2011 7:51 am (PST)
Just a quick note -- there is no universal definition of beta. When I've
been asked in the past why beta values differ from the various data
providers, it's because the different values were based on a 1-year,
3-year, or 5-year calculation. So if you do use beta, make sure you're
getting the type you want...
On Tue, Dec 6, 2011 at 8:41 AM, jrgeico <rerren.jeroen@gmail.com > wrote:
> Like usual it works :)
>
> It seems that the beta is not often available so I changed it into:
>
> =IFERROR(0+smfStrExtr("|"&smfGetTag Content("
> http://www3.valueline. "&Ticker,"div"com/vlquotes/ quote.aspx? symbol= ,1,"Beta: "),"|","
> "),"")
>
> which automates this process when changing the ticker symbol.
>
> That is (unfortunately :D) my little value added of the day..
>
> Thanks Randy!
>
- 2a.
-
Re: 600 stock data (quarterly earnings and dates) from Zacks Media s
Posted by: "V. Shankar" tarakayan@yahoo.com tarakayan
Tue Dec 6, 2011 4:54 am (PST)
Hi Randy,
I was going thru the files and link area for add-ins. Are there versions available for excel 2007/XP professional?
tnanks,
Shankar
>____________________ _________ ___
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Sunday, December 4, 2011 10:26 PM
>Subject: Re: [smf_addin] 600 stock data (quarterly earnings and dates) from Zacks Media site
>
>
>
>Are you saying that they are updating that XLS file every 10 minutes, but not the data pages on their web site?
>
>I ask, because the add-in could easily retrieve all of the data items on your "analysis" sheet from this web page:
>
>http://www.zacks.com/research/ report.php? type=estimates& t=AEGN
>
>And, BTW, your "analysis" sheet is wrong -- it shows $0.44 for Mar-11 and $0.08 for Dec-10. However, the web page above shows them reversed, as $0.08 for Mar-11 and $0.44 for Dec-10.
>
>I wrote the add-in functions because of frustrations I had with web queries, and I wanted a more exact way to extract data. However, I don't see a way for the add-in functions to access the XLS file -- which is why I'm asking if the web page above wouldn't substitute. It seems a shame to download such a large file when you are just extracting data from it one ticker at a time.
>
>In any case, if you want the file downloaded and formatted regularly, why not just write some VBA to do it and automate the process?
>
>
>On Sun, Dec 4, 2011 at 9:02 AM, V. Shankar <tarakayan@yahoo.com > wrote:
>
>
>>
>>Thanks Randy for your message. I thought I reply with an example so that my question is clear now.
>>
>>
>>1. I download an excel file from Zack from the site http://www.zacks.com/mediaroom/ estimates/ estimates_ reports.php? valtype=SP500
>>
>>
>>2. I have attached the zack excel file along with my analysis tab to pull out information in the format I want viz.:
>>
>>
>>--quarter ending dates for consecutive years, eps, next report date....etc for 3 years.
>>
>>
>>--when you type a ticker symbol in "A11", you will see eps reports in a format that is easier to read
>>
>>
>>Zack's excel file has 5598 line items. Just to reduce the size of the file (for this attachment), I am showing only around 100 ticker symbols.
>>
>>
>>The issue here is: I need to import/download Zack's file often so that the info is up to date (Zack's file in their website updates every 10 minutes)
>>
>>
>>My question is: I would like the first tab "zack" to update automatically without the need to download and overwrite my old file manually. Every time I download, I need to maintain the format, naming the range etc.
>>
>>
>>thanks,
>>Shankar
>>
>>
>>PS: I use excel web query for downloading stock info that gives daily price movements, volume, 52w h&l, pe, shares outstanding etc. I tried the same for Zack, but not able to download the data...
>>
>
>
>
> - 2b.
-
Re: 600 stock data (quarterly earnings and dates) from Zacks Media s
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Dec 6, 2011 6:38 am (PST)
I'm not sure I understand the question. I originally wrote the add-in when
I had EXCEL 2002/XP and now I have EXCEL 2007/Vista. But the add-in isn't
target for a specific version of EXCEL under a Windows platform.
On Tue, Dec 6, 2011 at 5:54 AM, V. Shankar <tarakayan@yahoo.com > wrote:
>
> I was going thru the files and link area for add-ins. Are there versions
> available for excel 2007/XP professional?
>
>
- 2c.
-
Re: 600 stock data (quarterly earnings and dates) from Zacks Media s
Posted by: "V. Shankar" tarakayan@yahoo.com tarakayan
Tue Dec 6, 2011 10:21 am (PST)
Oh ok. I was wondering if Vista is needed. Will try it out.
thanks.
>____________________ _________ ___
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Tuesday, December 6, 2011 8:08 PM
>Subject: Re: [smf_addin] 600 stock data (quarterly earnings and dates) from Zacks Media site
>
>
>
>I'm not sure I understand the question. I originally wrote the add-in when I had EXCEL 2002/XP and now I have EXCEL 2007/Vista. But the add-in isn't target for a specific version of EXCEL under a Windows platform.
>
>
>On Tue, Dec 6, 2011 at 5:54 AM, V. Shankar <tarakayan@yahoo.com > wrote:
>
>
>>
>>I was going thru the files and link area for add-ins. Are there versions available for excel 2007/XP professional?
>>
>
>
>
>
- 3.1.
-
New file uploaded to smf_addin
Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com
Tue Dec 6, 2011 6:09 am (PST)
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Uploads by forum members/Guru Industry Report.xls
Uploaded by : bpeven <bpeven@yahoo.com >
Description : Guru Focus Industry Report
You can access this file at the URL:
http://groups.yahoo.com/ group/smf_ addin/files/ Uploads%20by% 20forum%20member s/Guru%20Industr y%20Report. xls
To learn more about file sharing for your group, please visit:
http://help.yahoo.com/ l/us/yahoo/ groups/original/ members/web/ index.html
Regards,
bpeven <bpeven@yahoo.com >
- 4a.
-
Guru Focus Question
Posted by: "Brett" bpeven@yahoo.com bpeven
Tue Dec 6, 2011 6:12 am (PST)
Can anybody help me figure out what's going on in a file that I just uploaded to Uploads by forum members called, Guru Industry Report.
I can't figure out why it's working for some, but not others (for example Chris Davis and David Dreman for Financials).
Thanks
- 4b.
-
Re: Guru Focus Question
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Dec 6, 2011 7:47 am (PST)
Because you're trying to extract data from pages that don't have any data:
http://www.gurufocus.com/holdings. php?GuruName= Chris%20Davis& sort=position& p=4&ind=120
http://www.gurufocus.com/holdings. php?GuruName= David%20Dreman& sort=position& p=4&ind=120
Why are you always asking for the fifth page (i.e. "&p=4") of the holdings
list? Don't you care about the previous four pages? What if there are more
than five pages?
I would assume the values in columns A and B are meant to iterate over the
various pages, but you have them all set to specific values instead of
incrementing page by page. Did you copy them from another workbook that
iterated them, but copy them as values?
On Tue, Dec 6, 2011 at 7:12 AM, Brett <bpeven@yahoo.com > wrote:
> Can anybody help me figure out what's going on in a file that I just
> uploaded to Uploads by forum members called, Guru Industry Report.
>
> I can't figure out why it's working for some, but not others (for example
> Chris Davis and David Dreman for Financials).
>
- 5a.
-
Tickers for stocks listed in european markets?
Posted by: "nikos chryssochoidis" nikoschryssochoidis@yahoo.gr nikoschryssochoidis
Tue Dec 6, 2011 7:42 am (PST)
hi,
does anyone knows where i can find tickets , which can run the add in applications in excel , for european stocks listed in european markets?
thank you !
- 5b.
-
Re: Tickers for stocks listed in european markets?
Posted by: "kostas" nasta256@yahoo.gr nasta256
Tue Dec 6, 2011 7:59 am (PST)
--- In smf_addin@yahoogroups.com , "nikos chryssochoidis" <nikoschryssochoidis@...> wrote:
>
> hi,
>
> does anyone knows where i can find tickets , which can run the add in applications in excel , for european stocks listed in european markets?
>
> thank you !
>
u could use the stock market sites of each country or even yahoo. But could u be more specific? u want 15-min delayed quotes or EOD? From which countries?
regards,
kostas
- 5c.
-
Re: Tickers for stocks listed in european markets?
Posted by: "nikos chryssochoidis" nikoschryssochoidis@yahoo.gr nikoschryssochoidis
Tue Dec 6, 2011 8:20 am (PST)
am trying to find stocks with delay , for european markets generally , and specificaly lets say for the athens stock exchange
--- In smf_addin@yahoogroups.com , "kostas" <nasta256@...> wrote:
>
>
>
>
>
>
> --- In smf_addin@yahoogroups.com , "nikos chryssochoidis" <nikoschryssochoidis@> wrote:
> >
> > hi,
> >
> > does anyone knows where i can find tickets , which can run the add in applications in excel , for european stocks listed in european markets?
> >
> > thank you !
> >
>
> u could use the stock market sites of each country or even yahoo. But could u be more specific? u want 15-min delayed quotes or EOD? From which countries?
> regards,
> kostas
>
- 5d.
-
Re: Tickers for stocks listed in european markets?
Posted by: "paul messerschmidt" financepaul@gmail.com fuelspotpaul
Tue Dec 6, 2011 8:45 am (PST)
you can find foreign tickers using the quote search tools of these sites
(using danish wind manufacturer vestas as an example) just type 'vestas'
or your comany in the quote search box
http://www.google.com/finance? q=FRA%3AVWS
<http://www.google.com/finance? >q=FRA%3AVWS
http://markets.ft.com/research/ Markets/Tearshee ts/Summary? s=VWS:CPH
On Tue, Dec 6, 2011 at 11:20 AM, nikos chryssochoidis <
nikoschryssochoidis@yahoo.gr > wrote:
> **
>
>
> am trying to find stocks with delay , for european markets generally , and
> specificaly lets say for the athens stock exchange
>
> --- In smf_addin@yahoogroups.com , "kostas" <nasta256@...> wrote:
>
> >
> >
> >
> >
> >
> >
> > --- In smf_addin@yahoogroups.com , "nikos chryssochoidis"
> <nikoschryssochoidis@> wrote:
> > >
> > > hi,
> > >
> > > does anyone knows where i can find tickets , which can run the add in
> applications in excel , for european stocks listed in european markets?
> > >
> > > thank you !
> > >
> >
> > u could use the stock market sites of each country or even yahoo. But
> could u be more specific? u want 15-min delayed quotes or EOD? From which
> countries?
> > regards,
> > kostas
> >
>
>
>
--
--------------------- --------- --------- --
Paul Messerschmidt
paul.messerschmidt (skype)
+1-813-334-8682 (mobile)
- 5e.
-
Re: Tickers for stocks listed in european markets?
Posted by: "nikos chryssochoidis" nikoschryssochoidis@yahoo.gr nikoschryssochoidis
Tue Dec 6, 2011 9:13 am (PST)
thank you ! maybe am not so specific ! am trying to find the symbols (delayed) of european stock , targeting at the athens stock exchange in order to run the rchgetyahooquotes for them , maybe i should run another code ?
--- In smf_addin@yahoogroups.com , paul messerschmidt <financepaul@...> wrote:
>
> you can find foreign tickers using the quote search tools of these sites
> (using danish wind manufacturer vestas as an example) just type 'vestas'
> or your comany in the quote search box
>
> http://www.google.com/finance? q=FRA%3AVWS
>
> <http://www.google.com/finance? >q=FRA%3AVWS
> http://markets.ft.com/research/ Markets/Tearshee ts/Summary? s=VWS:CPH
>
> On Tue, Dec 6, 2011 at 11:20 AM, nikos chryssochoidis <
> nikoschryssochoidis@...> wrote:
>
> > **
> >
> >
> > am trying to find stocks with delay , for european markets generally , and
> > specificaly lets say for the athens stock exchange
> >
> > --- In smf_addin@yahoogroups.com , "kostas" <nasta256@> wrote:
> >
> > >
> > >
> > >
> > >
> > >
> > >
> > > --- In smf_addin@yahoogroups.com , "nikos chryssochoidis"
> > <nikoschryssochoidis@> wrote:
> > > >
> > > > hi,
> > > >
> > > > does anyone knows where i can find tickets , which can run the add in
> > applications in excel , for european stocks listed in european markets?
> > > >
> > > > thank you !
> > > >
> > >
> > > u could use the stock market sites of each country or even yahoo. But
> > could u be more specific? u want 15-min delayed quotes or EOD? From which
> > countries?
> > > regards,
> > > kostas
> > >
> >
> >
> >
>
>
>
> --
> --------------------- --------- --------- --
> Paul Messerschmidt
> paul.messerschmidt (skype)
> +1-813-334-8682 (mobile)
>
- 5f.
-
Re: Tickers for stocks listed in european markets?
Posted by: "kostas" nasta256@yahoo.gr nasta256
Tue Dec 6, 2011 9:21 am (PST)
http://www.euro2day.gr/IndicesDetai l.aspx?i= 2
http://www.euroland.com/
should you need any help feel free to contact me.
xronia polla gia ti giorti sou
regards,
kostas
--- In smf_addin@yahoogroups.com , "nikos chryssochoidis" <nikoschryssochoidis@...> wrote:
>
> am trying to find stocks with delay , for european markets generally , and specificaly lets say for the athens stock exchange
>
> --- In smf_addin@yahoogroups.com , "kostas" <nasta256@> wrote:
> >
> >
> >
> >
> >
> >
> > --- In smf_addin@yahoogroups.com , "nikos chryssochoidis" <nikoschryssochoidis@> wrote:
> > >
> > > hi,
> > >
> > > does anyone knows where i can find tickets , which can run the add in applications in excel , for european stocks listed in european markets?
> > >
> > > thank you !
> > >
> >
> > u could use the stock market sites of each country or even yahoo. But could u be more specific? u want 15-min delayed quotes or EOD? From which countries?
> > regards,
> > kostas
> >
>
- 5g.
-
Re: Tickers for stocks listed in european markets?
Posted by: "nikos chryssochoidis" nikoschryssochoidis@yahoo.gr nikoschryssochoidis
Tue Dec 6, 2011 9:48 am (PST)
se euxaristw polu kwsta ! , an katalaves psaxnw ta sumvola apo ellhnikes k oxi mono metoxes gia na mou trexoun se excel fila me vasiko ergaleio to rchgetyahooquotes i opoio allo typo einai ikanos na dwsei paromoia apotelesmata
--- In smf_addin@yahoogroups.com , "kostas" <nasta256@...> wrote:
>
>
> http://www.euro2day.gr/IndicesDetai l.aspx?i= 2
> http://www.euroland.com/
>
> should you need any help feel free to contact me.
> xronia polla gia ti giorti sou
> regards,
> kostas
>
>
> --- In smf_addin@yahoogroups.com , "nikos chryssochoidis" <nikoschryssochoidis@> wrote:
> >
> > am trying to find stocks with delay , for european markets generally , and specificaly lets say for the athens stock exchange
> >
> > --- In smf_addin@yahoogroups.com , "kostas" <nasta256@> wrote:
> > >
> > >
> > >
> > >
> > >
> > >
> > > --- In smf_addin@yahoogroups.com , "nikos chryssochoidis" <nikoschryssochoidis@> wrote:
> > > >
> > > > hi,
> > > >
> > > > does anyone knows where i can find tickets , which can run the add in applications in excel , for european stocks listed in european markets?
> > > >
> > > > thank you !
> > > >
> > >
> > > u could use the stock market sites of each country or even yahoo. But could u be more specific? u want 15-min delayed quotes or EOD? From which countries?
> > > regards,
> > > kostas
> > >
> >
>
- 6a.
-
forced recalculation
Posted by: "ghlentz2000" ghlentz2000@gmail.com ghlentz2000
Tue Dec 6, 2011 9:42 am (PST)
I have a spread sheet that uses =smfGetOptionQuotes(C7,"b",5, "OX") to obtain a number of option quotes.
Everything works find but the only way I can update is by exiting and restarting excel.
I tried smfForceRecalculation without success. The macro runs but the quotes are not updated.
Thanks
- 6b.
-
Re: forced recalculation
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Tue Dec 6, 2011 10:58 am (PST)
smfForceRecalculation updates the option quotes I get from the
smfGetOptionQuotes function (I use Google source but shouldn't matter).
Mind you, the ones I track don't update often, the bid prices can stay the
same for a long time, but they do occasionally change.
The ForceRecalc discards all downloaded web data and refreshes it - forcing
updates to all functions reliant on them. If so, it would have to update
your options as well.
http://finance.groups.yahoo. com/group/ smf_addin/ message/7625
To ensure ForceRecalc is working, try putting a GetYahooQuotes function on
that worksheet for an equity price that changes frequently. If that equity
price is updating but not your options, that's probably something for Randy
if it doesn't match the OX page - or to take up with the OX people if their
site isn't changing.
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of ghlentz2000
Sent: Tuesday, December 06, 2011 12:43 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] forced recalculation
I have a spread sheet that uses =smfGetOptionQuotes(C7,"b",5, "OX") to obtain
a number of option quotes.
Everything works find but the only way I can update is by exiting and
restarting excel.
I tried smfForceRecalculation without success. The macro runs but the quotes
are not updated.
Thanks
- 6c.
-
Re: forced recalculation
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Dec 6, 2011 11:52 am (PST)
Those are the only two ways I know of to force the update --
smfForceRecalculation or exiting/restarting EXCEL. The first empties the
saved web pages array directly, the second does it indirectly be resetting
the entire VBA project.
It might be that you have your Internet Options set to cache web pages. You
should have it set up so that new content is retrieved every time a web
page is visited. However, if you were caching web pages, I wouldn't think
exiting/restarting EXCEL would cause an update of the quotes.
But, frankly, other than page caching, I can't imagine
smfForceRecalculation running and NOT purging all the saved web pages,
forcing retrieval of new ones. You could try the Ctrl+Alt+F9 keyboard
shortcut after running the macro?
Along the lines Mike suggested, an easy way to test if
smfForceRecalculation is doing what it should do is to use something like:
=RCHGetYahooQuotes("SPY","t1" )
...which gets the last traded time of SPY. That should change at least once
per minute when the market is open. So if you wait a minute and then run
smfForceRecalculation, that returned time should change.
On Tue, Dec 6, 2011 at 10:42 AM, ghlentz2000 <ghlentz2000@gmail.com > wrote:
> I have a spread sheet that uses =smfGetOptionQuotes(C7,"b",5, "OX") to
> obtain a number of option quotes.
>
> Everything works find but the only way I can update is by exiting and
> restarting excel.
>
> I tried smfForceRecalculation without success. The macro runs but the
> quotes are not updated.
>
- 7a.
-
Maxing Out on Data Downloads using SMF Add-in... Any solutions aroun
Posted by: "ro.valen" ro.valen@yahoo.com ro.valen
Tue Dec 6, 2011 10:05 am (PST)
Hello All,
I have built a spreadsheet using Mr. Harmelink's fantastic SMF Add-in that analyzes fundamental data on a couple hundred ticker symbols. However, after data has been retrieved on the first hundred or so, I get an error message telling me I have pretty much reached the maximum allowable download for the session and I am subsequently prevented from downloading further data until I do a full system restart and begin anew.
Does anyone know how to get around this data limitation without having to restart my computer?
Thanks in advance for your suggestions.
Sincerely,
rovalen
- 7b.
-
Re: Maxing Out on Data Downloads using SMF Add-in... Any solutions a
Posted by: "Martin Topper" mtopper@yahoo.com mtopper
Tue Dec 6, 2011 10:38 am (PST)
Randy has set a limit of 1,000 web pages stored by the addin in excel. This is to allow for data extractions but not abuse the free providers.
Yahoo also has a limit of 200 symbols that can be retrieved at once (through the CSV retrieve which Randy uses for the Yahoo Quotes function)
I assume you are running into one of these issues.
best
marty
_____________________ _________ __
From: ro.valen <ro.valen@yahoo.com >
To: smf_addin@yahoogroups.com
Sent: Tuesday, December 6, 2011 1:05 PM
Subject: [smf_addin] Maxing Out on Data Downloads using SMF Add-in... Any solutions around this?
Hello All,
I have built a spreadsheet using Mr. Harmelink's fantastic SMF Add-in that analyzes fundamental data on a couple hundred ticker symbols. However, after data has been retrieved on the first hundred or so, I get an error message telling me I have pretty much reached the maximum allowable download for the session and I am subsequently prevented from downloading further data until I do a full system restart and begin anew.
Does anyone know how to get around this data limitation without having to restart my computer?
Thanks in advance for your suggestions.
Sincerely,
rovalen
- 7c.
-
Re: Maxing Out on Data Downloads using SMF Add-in... Any solutions a
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Dec 6, 2011 11:39 am (PST)
You don't need to do a full system restart. If you run the
smfForceRecalculation macro (see "Links" area of the group for more info),
it will "reset" everything. However, it won't allow you to get around
retrieving over 1000 web pages at the same time, amongst all open
workbooks. IMO, that limit should be plenty.
For as many stocks as you're doing, I usually go to the
smfUpdateDownloadTable process (again, see "Links" area). This would allow
you to load VALUES into the workbooks instead of using formulas, so you'd
have better control over the 1000 web page limit. For example, you don't
really need to get financial statements data every time you open the
workbook. If you can just update it once a week, once a month, or piecemeal
as needed, it does a better job of limiting how much you utilize the free
data providers. I really don't want them overloaded with people creating
"databases" by grabbing as much free data as they want. It would be easy
enough for them to make the data inaccessible to the add-in -- as we've
seen by recent MorningStar changes.
On Tue, Dec 6, 2011 at 11:05 AM, ro.valen <ro.valen@yahoo.com > wrote:
>
> I have built a spreadsheet using Mr. Harmelink's fantastic SMF Add-in that
> analyzes fundamental data on a couple hundred ticker symbols. However,
> after data has been retrieved on the first hundred or so, I get an error
> message telling me I have pretty much reached the maximum allowable
> download for the session and I am subsequently prevented from downloading
> further data until I do a full system restart and begin anew.
>
> Does anyone know how to get around this data limitation without having to
> restart my computer?
>
- 7d.
-
Re: Maxing Out on Data Downloads using SMF Add-in... Any solutions a
Posted by: "ro.valen" ro.valen@yahoo.com ro.valen
Tue Dec 6, 2011 3:58 pm (PST)
Thank you kindly for taking the time to provide an explanation, Marty. Happy New Year to you.
Sincerely,
rovalen
--- In smf_addin@yahoogroups.com , Martin Topper <mtopper@...> wrote:
>
> Randy has set a limit of 1,000 web pages stored by the addin in excel. This is to allow for data extractions but not abuse the free providers.
>
> Yahoo also has a limit of 200 symbols that can be retrieved at once (through the CSV retrieve which Randy uses for the Yahoo Quotes function)
>
>
>
> I assume you are running into one of these issues.
>
> best
>
>
> marty
>
>
>
> _____________________ _________ __
> From: ro.valen <ro.valen@...>
> To: smf_addin@yahoogroups.com
> Sent: Tuesday, December 6, 2011 1:05 PM
> Subject: [smf_addin] Maxing Out on Data Downloads using SMF Add-in... Any solutions around this?
>
>
> Â
> Hello All,
>
> I have built a spreadsheet using Mr. Harmelink's fantastic SMF Add-in that analyzes fundamental data on a couple hundred ticker symbols. However, after data has been retrieved on the first hundred or so, I get an error message telling me I have pretty much reached the maximum allowable download for the session and I am subsequently prevented from downloading further data until I do a full system restart and begin anew.
>
> Does anyone know how to get around this data limitation without having to restart my computer?
>
> Thanks in advance for your suggestions.
>
> Sincerely,
>
> rovalen
>
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