Messages In This Digest (6 Messages)

3.: Getting different data using same spreadsheet on different computers From: kkkutty

Messages

1a.: dividends analysis

Posted by: "chocronalberto@ymail.com" chocronalberto@gmail.com chocronalberto@ymail.com

Mon Apr 9, 2012 7:44 am (PDT)

Hi all;

Is there already a Dividend analysis of portfolio ?
I'm looking for something that will help with qualified dividends as well as with non qualifies dividends, qualified dividend income (qdi), dividend received deduction (drd) and tax withholdings.

Thanks in advance.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.: Re: dividends analysis

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Mon Apr 9, 2012 10:07 am (PDT)

Sounds like bookkeeping instead of analysis. But, no, I'm not aware of
anything.

On Mon, Apr 9, 2012 at 7:44 AM, chocronalberto@ymail.com <
chocronalberto@gmail.com> wrote:

>
> Is there already a Dividend analysis of portfolio ?
> I'm looking for something that will help with qualified dividends as well
> as with non qualifies dividends, qualified dividend income (qdi), dividend
> received deduction (drd) and tax withholdings.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

2a.: Vix Term Structure Data

Posted by: "john.sitarz" john.sitarz@gmail.com john.sitarz

Mon Apr 9, 2012 10:25 am (PDT)

Randy,

Could you help on grabbing the vix term structure data from http://www.cboe.com/data/volatilityindexes/volatilityindexes.aspx

I tried to set up a rchgettablecell but am having trouble getting it to work. Any help would be appreciated.

Thanks,

John

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2b.: Re: Vix Term Structure Data

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Mon Apr 9, 2012 11:16 am (PDT)

Try:

=RCHGetTableCell("
http://www.cboe.com/data/volatilityindexes/volatilityindexes.aspx",column,">Expiration
Date",,,,row)

...varying "column" from 1 to 4 and "row" from 1 to 10.

On Mon, Apr 9, 2012 at 10:25 AM, john.sitarz <john.sitarz@gmail.com> wrote:

>
> Could you help on grabbing the vix term structure data from
> http://www.cboe.com/data/volatilityindexes/volatilityindexes.aspx
>
> I tried to set up a rchgettablecell but am having trouble getting it to
> work. Any help would be appreciated.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2c.: Re: Vix Term Structure Data

Posted by: "John Sitarz" john.sitarz@gmail.com john.sitarz

Mon Apr 9, 2012 12:02 pm (PDT)

Thanks Randy! That worked.

Sent from my iPhone

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

3.: Getting different data using same spreadsheet on different computers

Posted by: "kkkutty" kkkutty@yahoo.com kkkutty

Mon Apr 9, 2012 11:57 am (PDT)

Hi Randy,

I'm using a spreadsheet to track about 15 stocks which I copy to view on two different computers. I get the data from ADVFN and for 2 out of the 15 tickers when I try to retrieve, for example, element 8006 (Quarterly ending date), on one computer it shows up as 2011/12 (the correct date) and the other computer it shows up as 2008/06. In other words, for 2 out of the 15 stocks I'm tracking, I'm retrieving old data on one computer and the correctly updated data on a different computer even though it's from the same spreadsheet. Any ideas as to why this is happening and how I can fix it. When I go to the website, I don't have any problem viewing the correctly updated data. Do I need to reinstall the add-in for one computer? Thank you very much in advance.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)

Messages | Files | Photos | Polls