Senin, 10 Maret 2014

[smf_addin] Digest Number 3000

15 Messages

Digest #3000
1a
Re: Hey by "vijay gangrade" vijay_gangrade
4a
5b
Re: Bulk Download of Ex-Dividend Dates by "Randy Harmelink" rharmelink

Messages

Mon Mar 10, 2014 12:41 am (PDT) . Posted by:

"vijay gangrade" vijay_gangrade

Dear Sir, Thank you so much for the explanation and solution for running it conditionally. For me, even MSFT, FB etc are also occasionally giving errors along with the tickers with genuine errors. This is why I was wondering if it is happening because of time-outs and if I can do something to increase the timeout

I will go through the links which you have suggested.

Thanks & Regards,
Vijay Gangrade

On Monday, March 10, 2014 12:47 PM, Randy Harmelink <rharmelink@gmail.com> wrote:

 
I get errors on ABEV, ACG, ACP. Totally correct, since AdvFN has no annual financial statements for them.

I also got an error on ACRE. That's because it only has one year of history. The "# of periods" is derived from the drop-down box that lists available periods. When only one year is available, that drop-down box doesn't appear. Not gonna worry about it, since it's such a rare situation.

The other four -- MSFT, FB, MEG, MEI -- worked fine here.

To prevent execution, you can change all the formulas to be conditional. For example:

=IF($F$1<>"Y","--",smfGetAdvFNElement(A2,B2,999))

Then, the SMF formula will only calculate if cell F1 has a "Y" in it. But you'll need to make sure to set it to "N" whenever you save the file. :)

You can also take a look at the smfUpdateDownloadTable process. It *is* a macro, and saves values into cells instead of recalculating formulas. It only updates the values when you run the macro:

Link 2.1a - Using the smfUpdateDownloadTable macro
Link 2.1b - Using the smfUpdateDownloadTable macro
Link 2.1c - A blog entry on using the smfUpdateDownloadTable macro
I find it easiest to just start with the sample workbook, so that all the basic cell names and structure is already in place.

On Sun, Mar 9, 2014 at 11:43 PM, vijay gangrade <vijay_gangrade@yahoo.com> wrote:

>
>Thank you so much for your help. It started working but it seems it is not giving results for all companies within NYSE. I made a test xls and tried to find only the available periods for some companies. But it works for some and gives "Error" for the rest. Also I noticed that it is not consistent despite of deleting history and cookies from Internet explorer. So for a company, it gives error on some occasions and correct results on other. Attached is the example xls I am using.
>
>I was wondering if it is because of time-outs. I wouldn't be surprised if that is the case since my internet speed is a lot lesser than usual. Is there any way to override it.
>
>I also wanted to ask if there is any way to stop the add-in from running as soon as the xls is opened. That way I can first prepare the xls completely and then run it like a macro.
>
>Thank you once again. This has made my life a lot easier.
>

Mon Mar 10, 2014 2:47 am (PDT) . Posted by:

jpaucamp1

Hi

I hope someone can assist me! I have two computers and both run excel 2010. On the one that runs Vista my Google Finance data shows up just fine but on the Windows 7 one they show up as errors. I've compared security and trusted locations and they seem fine but can't get it to work.


Any ideas?


Thanks
JP

Mon Mar 10, 2014 3:15 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try viewing one of the Google web pages using the EXCEL Web Query dialog
(alt+d+d+w) and see if the web page comes up OK. For example:

On Mon, Mar 10, 2014 at 2:47 AM, <oaucamp@googlemail.com> wrote:

>
>
> Hi
>
> I hope someone can assist me! I have two computers and both run excel
> 2010. On the one that runs Vista my Google Finance data shows up just fine
> but on the Windows 7 one they show up as errors. I've compared security and
> trusted locations and they seem fine but can't get it to work.
>
> Any ideas?
>
> Thanks
> JP
>
>
>
>

Mon Mar 10, 2014 4:05 am (PDT) . Posted by:

jpaucamp1

Hi Randy

Your message stops after "For example" but I guess you meant I should see if one of the google finance pages that hold the data that I want to extract shows up correctly and it does. I tried the Qtrly results for JPM and it shows up fine when viewing it as you suggested but still showing as error on the excel sheet.


On my other machine running Vista it shows the values. I have copied the working sheet to the other computer as well and everything else works fine except the Google Finance data.

Mon Mar 10, 2014 4:28 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

What do you get for these?

=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM", 3302)
=RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=MMM",1,"INCANNUALDIV","(except
for per share items)")
=smfGetTagContent("http://www.google.com/finance?fstype=ii&q=MMM","title")
=RCHGetWebData("http://www.google.com/finance?fstype=ii&q=MMM",1,50)

If I recall correctly, someone else had trouble with the Google pages. We
never did find out what the problem was. I'm assuming other things work
fine on the Windows 7 machine? For example:

=RCHGetElementNumber("MMM", 941)

On Mon, Mar 10, 2014 at 4:05 AM, <oaucamp@googlemail.com> wrote:

>
> Your message stops after "For example" but I guess you meant I should see
> if one of the google finance pages that hold the data that I want to
> extract shows up correctly and it does. I tried the Qtrly results for JPM
> and it shows up fine when viewing it as you suggested but still showing as
> error on the excel sheet.
>
> On my other machine running Vista it shows the values. I have copied the
> working sheet to the other computer as well and everything else works fine
> except the Google Finance data.
>

Mon Mar 10, 2014 4:50 am (PDT) . Posted by:

jpaucamp1

Results below All other items work fine. To really confuse things I've just checked on my wife's machine also running Windows 7 but Excel 2007 it works fine.................??

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :

What do you get for these?

=RCHGetElementNumber("Version") Stock Market Functions add-in, Version 2.1.2014.01.30 (C:\Program Files\SMF Add-in; ; 1)=RCHGetElementNumber("MMM", 3302) Error
=RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=MMM http://www.google.com/finance?fstype=ii&q=MMM",1,"INCANNUALDIV","(except for per share items)") Error
=smfGetTagContent("http://www.google.com/finance?fstype=ii&q=MMM http://www.google.com/finance?fstype=ii&q=MMM","title") Error
=RCHGetWebData("http://www.google.com/finance?fstype=ii&q=MMM http://www.google.com/finance?fstype=ii&q=MMM",1,50) Error


If I recall correctly, someone else had trouble with the Google pages. We never did find out what the problem was. I'm assuming other things work fine on the Windows 7 machine? For example:


=RCHGetElementNumber("MMM";, 941) 88870000
On Mon, Mar 10, 2014 at 4:05 AM, <oaucamp@... mailto:oaucamp@...> wrote:

Your message stops after "For example" but I guess you meant I should see if one of the google finance pages that hold the data that I want to extract shows up correctly and it does. I tried the Qtrly results for JPM and it shows up fine when viewing it as you suggested but still showing as error on the excel sheet.


On my other machine running Vista it shows the values. I have copied the working sheet to the other computer as well and everything else works fine except the Google Finance data.








Mon Mar 10, 2014 5:43 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

This error means it can't even retrieve the web page.

Just grasping for straws, but have you change the Internet settings for
AdvFN access?

https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/10464

I doubt it's related, but...not sure what else to suggest.

On Mon, Mar 10, 2014 at 4:50 AM, <oaucamp@googlemail.com> wrote:

>
> =RCHGetWebData("http://www.google.com/finance?fstype=ii&q=MMM",1,50) Error
>

Mon Mar 10, 2014 8:23 am (PDT) . Posted by:

jpaucamp1

Thanks Randy. I tried that and it seems to have fixed the issue. Unfortunately I rolled back IE to version 10 for a different reason so not sure if it was that or the 'Access Data Sources Across Domains' change that fixed it. But i'm happy either way!!

Mon Mar 10, 2014 10:44 am (PDT) . Posted by:

almondtree

I bought SpinRite it bombed couldn't get it do anything going do 30 day return, I bought a 1tb Western Dig.Now backup didn't load some the disk. Troubles, so many troubles.

Mon Mar 10, 2014 3:10 pm (PDT) . Posted by:

Frahman02

I'm monitoring a series of stocks using a smfgetcsvfile function that downloads almost everything I need with a single hit off of FinViz. Unfortunately, FinViz doesn't seem to provide ex-dividend dates. The only method I've found to download ex-dividend dates is to use RCHGetElementNumber 992, but that is a very slow process as it downloads each item individually. Is there a better solution that I'm missing?



Thanks for your help,


Eric

Mon Mar 10, 2014 5:40 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm not aware of a site that allows grabbing ex-dividend dates in bulk, for
a list of ticker symbols.

However, depending on what you're doing with the dates, you could go to a
site that lists upcoming dividend dates and try extracting what you need
from there.

On Mon, Mar 10, 2014 at 3:08 PM, <eric.frahm2@gmail.com> wrote:

>
> I'm monitoring a series of stocks using a smfgetcsvfile function that
> downloads almost everything I need with a single hit off of FinViz.
> Unfortunately, FinViz doesn't seem to provide ex-dividend dates. The only
> method I've found to download ex-dividend dates is to use
> RCHGetElementNumber 992, but that is a very slow process as it downloads
> each item individually. Is there a better solution that I'm missing?
>
>

Mon Mar 10, 2014 4:56 pm (PDT) . Posted by:

zefiro401k

HI,
This is awesome. Thanks for sharing this information. Could you tell me how this VBA code works? Thank you very much!




---In smf_addin@yahoogroups.com, <ttizzle2@...> wrote :

That's *miles* simpler than what I was thinking! Had to put the Sheets and Windows within a Workbooks With block and it works great!

I see a lot of recoding in my future...


Thanks a ton.


a.



Mon Mar 10, 2014 5:43 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

My code? Very simple -- opens workbook from the website, renames and then
copies a specific sheet to the active workbook, then closes the workbook
opened from the website.

On Mon, Mar 10, 2014 at 4:56 PM, <zefiro401k@yahoo.com> wrote:

>
> This is awesome. Thanks for sharing this information. Could you tell me
> how this VBA code works? Thank you very much!
>

Mon Mar 10, 2014 6:44 pm (PDT) . Posted by:

zefiro401k

Thanks Randy but I should have been more specific. Is there a way to make the Ticker on the URL change by linking it to a cell in the worksheet?

Example: If Cell A1 is GOOG, then the symbol in the URL automatically changes to what ever is in cell A1.

Thank you!

Mon Mar 10, 2014 6:13 pm (PDT) . Posted by:

nmalhotr

I need to pull this into excel http://finance.yahoo.com/q?s=CIBCINDASIEP.TO&ql=1 http://finance.yahoo.com/q?s=CIBCINDASIEP.TO&ql=1 Specifically I am looking to get the closing price.


The "download data" file is empty.


What would be the best way to accomplish this?
Diposting oleh EXCEL FEED LEARNING di 18.44

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)