Messages In This Digest (8 Messages)
- 1a.
- quotes From: ghlentz2000
- 1b.
- Re: quotes From: Sudhir Agarwal
- 1c.
- Re: quotes From: Randy Harmelink
- 2a.
- Re: Using SMF Add-in over multiple worksheets From: codyklein
- 2b.
- Re: Using SMF Add-in over multiple worksheets From: MikeM
- 3a.
- hi From: Evan Barron
- 4a.
- Re: Use of SMF Formulas in Excel 2010 Tables From: Ron
- 5a.
- Re: Trouble with Windows 7 and the file path From: Ron
Messages
- 1a.
-
quotes
Posted by: "ghlentz2000" ghlentz2000@gmail.com ghlentz2000
Thu Apr 19, 2012 5:54 am (PDT)
Is there any way to get real time quotes and out-of-hour quotes?
I can get them on web pages at yahoo and OptionXpress but I would like automatically strip them off those pages.
Thanks
- 1b.
-
Re: quotes
Posted by: "Sudhir Agarwal" Agarwal.sudhir@gmail.com sudhir_agarwal1
Thu Apr 19, 2012 6:15 am (PDT)
[Attachment(s) from Sudhir Agarwal included below]
I hope this will help.
This will give you a near real time quote in Excel.
There is a limit to the number of Symbols you can add.
You can set the frequency of the updates also.
Sudhir
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of ghlentz2000
Sent: Thursday, April 19, 2012 8:54 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] quotes
Is there any way to get real time quotes and out-of-hour quotes?
I can get them on web pages at yahoo and OptionXpress but I would like
automatically strip them off those pages.
Thanks
Attachment(s) from Sudhir Agarwal
1 of 1 File(s)
- 1c.
-
Re: quotes
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Apr 19, 2012 8:03 am (PDT)
Check the message archives. It's been discussed before. And there is a
template in the files area. However, I don't use real-time quotes, so I
don't know if it's current -- the presentation of those items seems to
change a lot.
On Thu, Apr 19, 2012 at 5:53 AM, ghlentz2000 <ghlentz2000@gmail.com > wrote:
> Is there any way to get real time quotes and out-of-hour quotes?
>
> I can get them on web pages at yahoo and OptionXpress but I would like
> automatically strip them off those pages.
>
- 2a.
-
Re: Using SMF Add-in over multiple worksheets
Posted by: "codyklein" codyklein@alum.drexel.edu codyklein
Thu Apr 19, 2012 7:37 am (PDT)
I've been having the same problem. It started about a month ago +- and only effects yahoo (so far). It seems to be random and you must run the force recalc function until it all comes in. Sometimes its a yahoo problem but most of the time when I check the yahoo webpage all the data is there. It usually happens with yahoo's Income statement, balance sheet and cash flow statements when pulling in both yearly and quarterly data. I've noticed it doesn't happen as much if you go to the problem worksheet then force reclac although this could be wishful thinking on my part because it doesn't always work. It is strange but eventually it all come in.
Maybe it has something to do with the 1000 limit but I'm pretty sure I don't come close. I pull data for some 20-40 tickers from several sources but I don't know if there is a way to check the number of webpages it pulls from for the entire workbook.
So far its not a problem since I can get all the data with a few force reclacs.
--- In smf_addin@yahoogroups.com , "thomas91112" <thomas91112@...> wrote:
>
> I currently have multiple Excel workbooks (one workbook for each stock plus some analytics) using RCHGetYahooHistory and RCHGetYahooQuotes to retrieve High, Low and Close values. Would like to combine these numerous workbooks into a single workbook but with separate worksheets, one for each of the current workbooks - that way each worksheet will contain the price history and analytics for each stock.
>
> As individual workbooks the data updated just fine, but when I combined these workbooks as described above, have begun encountering problems with the data when updating. Sometimes data items would not fully update leaving off the last two months of data but it seemed random, you never know when a worksheet will update fully...have to keep hitting ForceReCalc until the full update occurs.
>
> Is there a problem using SMF throughout multiple worksheets?
>
> Thanks
> Mike
>
- 2b.
-
Re: Using SMF Add-in over multiple worksheets
Posted by: "MikeM" mikemcq802@yahoo.com mikemcq802
Thu Apr 19, 2012 11:18 am (PDT)
All of my spreadsheets have multiple worksheets (tabs) and I've never had any problems with SMF because of that issue. I even have workbooks with multiple worksheets with links to other workbooks - all with SMF formulas - and I've not had problems due to that.
Yahoo occasionally doesn't return data, other sites have changed their layouts requiring formula changes or SMF updates, and my internet connection has just been bad causing timeouts. These are all pretty common and routine types of issues - nothing to do with how many tabs you have or how many workbooks you have open.
--- In smf_addin@yahoogroups.com , "thomas91112" <thomas91112@...> wrote:
>
> I currently have multiple Excel workbooks (one workbook for each stock plus some analytics) using RCHGetYahooHistory and RCHGetYahooQuotes to retrieve High, Low and Close values. Would like to combine these numerous workbooks into a single workbook but with separate worksheets, one for each of the current workbooks - that way each worksheet will contain the price history and analytics for each stock.
>
> As individual workbooks the data updated just fine, but when I combined these workbooks as described above, have begun encountering problems with the data when updating. Sometimes data items would not fully update leaving off the last two months of data but it seemed random, you never know when a worksheet will update fully...have to keep hitting ForceReCalc until the full update occurs.
>
> Is there a problem using SMF throughout multiple worksheets?
>
> Thanks
> Mike
>
- 3a.
-
hi
Posted by: "Evan Barron" bouncing81mm@yahoo.com bouncing81mm
Thu Apr 19, 2012 10:26 am (PDT)
- 4a.
-
Re: Use of SMF Formulas in Excel 2010 Tables
Posted by: "Ron" rlcarr71@yahoo.com rlcarr71
Thu Apr 19, 2012 10:50 am (PDT)
When I created my table (excel called it Table1, rather than TICKER).
I'm assuming maybe before you where using the named range TICKER for the smfUpdateDownloadTable macro.
I also experienced the nice results where it automatically applies the formula down every row in the column.
However, mine was not lightning fast, possibly you had run some Gets earlier and those symbols where still in your cache.
Nice find.
Ron
- 5a.
-
Re: Trouble with Windows 7 and the file path
Posted by: "Ron" rlcarr71@yahoo.com rlcarr71
Thu Apr 19, 2012 11:00 am (PDT)
> computer > Local Disk (c:) > Program FIles > SMF Add-in.
Is just the logical view that you see on the address bar in Window Explorer
The relative path is still just
C:\Program Files\SMF Add-In
Ron
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
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