10 messages in com.googlegroups.google-finance-apis[Google Finance APIs] Re: additional ...
FromSent OnAttachments
ChrisSep 30, 2008 11:14 am 
ChrisOct 3, 2008 2:21 pm 
DineshOct 3, 2008 8:46 pm 
Doug ChimentoOct 4, 2008 9:35 am 
DineshOct 4, 2008 9:34 pm 
Cham...@gmail.comOct 6, 2008 2:26 pm 
Dion Loy (Google)Oct 6, 2008 3:12 pm 
Cham...@gmail.comOct 7, 2008 8:17 am 
Dion Loy (Google)Oct 8, 2008 9:59 am 
Cham...@gmail.comOct 8, 2008 4:39 pm 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:[Google Finance APIs] Re: additional returns data not as describedActions...
From:Dion Loy (Google) (dloy@google.com)
Date:Oct 6, 2008 3:12:40 pm
List:com.googlegroups.google-finance-apis

You seem to be requesting the transactions feed instead of the positions feed. Have you tried:

http://finance.google.com/finance/feeds/exam...@gmail.com/portfolios/70/posi@

(without the /transactions at the end)

On Oct 6, 2:26 pm, "Cham@gmail.com" <Cham@gmail.com> wrote:

Hey Doug,

I tried your method, and got a modicum of success but only on pulling the portfolio statistics as a whole, not on a per position basis. I'm having the same issue that Dinesh in the are that none of the costBasis/daysGain/marketValue data is being returned. I've attempted adding data manually through the web interface with the necessary transaction data that you had mentioned, along with trying to insert using the following XML:

string xmlData = @"<?xml version=""1.0"" encoding=""utf-8""?>"                                                                 + @"<entry
xmlns=""http://www.w3.org/2005/Atom"" xmlns:gf=""http://schemas.google.com/finance/2007"" xmlns:gd=""http:// schemas.google.com/g/2005"">"                                                                 +
"<gf:transactionData date='" + DateTime.Now.ToString("yyyy- MM-dd") + "T00:00:00.000' shares='1.0' type='Buy'>"                                                                 +
"<gf:commission><gd:money amount='100.0' currencyCode='USD'/>"

                                                                +
"</gf:commission>"                                                                 + "<gf:price>"                                                                 + "<gd:money
amount='100.0' currencyCode='USD'/>"                                                                 +
"</gf:price></gf:transactionData></entry>";

and the following URI: "http://finance.google.com/finance/feeds/ exam@gmail.com/portfolios/70/positions?returns=true"

I have two transactions in my portfolio

Name            Symbol  Last price    Change                   Shares Cost basis      Mkt value       Gain    Gain %  Day's gain      Overall Return Google Inc.     GOOG    369.14       -17.77 (-4.59%)    1.00      123.00 369.14  246.14  200.11%         (17.77)         200.11% Apple Inc.      AAPL    98.14        +1.07 (1.10%)            1.00              
0.00                 98.14   98.14   0.00%   1.07

As you can tell all the data that I need is available within the web interface. However, the two entries that are returned are like this:

<?xml version="1.0" encoding="utf-8"?> <entry xmlns="http://www.w3.org/2005/Atom">   <gd:feedLink href="http://finance.google.com/finance/feeds/ exam@gmail.com/portfolios/70/positions/NASDAQ:GOOG/transactions" xmlns:gd="http://schemas.google.com/g/2005" />   <gf:positionData gainPercentage="0.0" return1w="0.0" return1y="0.0" return3m="0.0" return3y="0.0" return4w="0.0" return5y="0.0" returnOverall="0.0" returnYTD="0.0" shares="1.0" xmlns:gf="http:// schemas.google.com/finance/2007" />   <gf:symbol exchange="NASDAQ" fullName="Google Inc." symbol="GOOG" xmlns:gf="http://schemas.google.com/finance/2007" />   <title type="text">Google Inc.</title>   <id>http://finance.google.com/finance/feeds/Champ@gmail.com/ portfolios/70/positions/NASDAQ:GOOG</id>   <link href="http://finance.google.com/finance/feeds/champatcu %40gmail.com/portfolios/70/positions/NASDAQ%3AGOOG" rel="self" type="application/atom+xml" />   <category term="http://schemas.google.com/finance/2007#position" scheme="http://schemas.google.com/g/2005#kind" />   <content type="text" />   <updated>2008-10-06T15:11:49-06:00</updated> </entry>

and

<?xml version="1.0" encoding="utf-8"?> <entry xmlns="http://www.w3.org/2005/Atom">   <gd:feedLink href="http://finance.google.com/finance/feeds/ exam@gmail.com/portfolios/70/positions/NASDAQ:AAPL/transactions" xmlns:gd="http://schemas.google.com/g/2005" />   <gf:positionData gainPercentage="0.0" return1w="0.0" return1y="0.0" return3m="0.0" return3y="0.0" return4w="0.0" return5y="0.0" returnOverall="0.0" returnYTD="0.0" shares="1.0" xmlns:gf="http:// schemas.google.com/finance/2007" />   <gf:symbol exchange="NASDAQ" fullName="Apple Inc." symbol="AAPL" xmlns:gf="http://schemas.google.com/finance/2007" />   <title type="text">Apple Inc.</title>   <id>http://finance.google.com/finance/feeds/Champ@gmail.com/ portfolios/70/positions/NASDAQ:AAPL</id>   <link href="http://finance.google.com/finance/feeds/champatcu %40gmail.com/portfolios/70/positions/NASDAQ%3AAAPL" rel="self" type="application/atom+xml" />   <category term="http://schemas.google.com/finance/2007#position" scheme="http://schemas.google.com/g/2005#kind" />   <content type="text" />   <updated>2008-10-06T15:13:43-06:00</updated> </entry>

Both of which are still as described before regardless of the additional transaction data.

The only way I can get anything close to what you have show is changing the URI to this: query.Uri = new Uri("http://finance.google.com/finance/feeds/ exam@gmail.com/portfolios/70?returns=true");

which returns the portfolio data as a single entry as follows

<?xml version="1.0" encoding="utf-8"?> <entry xmlns="http://www.w3.org/2005/Atom" xmlns:gf="http:// schemas.google.com/finance/2007" xmlns:gd="http://schemas.google.com/g/ 2005">   <gd:feedLink href="http://finance.google.com/finance/feeds/ exam@gmail.com/portfolios/70/positions" />   <gf:portfolioData currencyCode="USD" gainPercentage="2.799024504" return1w="2.799024504" return1y="2.799024504" return3m="2.799024504" return3y="2.799024504" return4w="2.799024504" return5y="2.799024504" returnOverall="2.799024504" returnYTD="2.799024504">     <gf:costBasis>       <gd:money amount="123.0" currencyCode="USD" />     </gf:costBasis>     <gf:daysGain>       <gd:money amount="-16.699989" currencyCode="USD" />     </gf:daysGain>     <gf:gain>       <gd:money amount="344.280014" currencyCode="USD" />     </gf:gain>     <gf:marketValue>       <gd:money amount="467.280014" currencyCode="USD" />     </gf:marketValue>   </gf:portfolioData>   <title type="text">NinjaTrader_0</title>   <id>http://finance.google.com/finance/feeds/Champ@gmail.com/ portfolios/70</id>   <link href="http://finance.google.com/finance/feeds/champatcu %40gmail.com/portfolios/70" rel="self" type="application/atom+xml" />   <link href="http://finance.google.com/finance/feeds/champatcu %40gmail.com/portfolios/70" rel="edit" type="application/atom+xml" />   <category term="http://schemas.google.com/finance/2007#portfolio" scheme="http://schemas.google.com/g/2005#kind" />   <content type="text" />   <updated>2008-10-06T15:23:21-06:00</updated> </entry>

close but no cigar. Any other thoughts? Dinesh, are you still running into the same issue?

On Oct 4, 10:35 am, "Doug Chimento" <dchi@gmail.com> wrote:

Chris,  I think the confusion maybe that your portfolio does not have any transactions. By transaction I mean you have entered a date,amount, and number of shares for a stock. Without those three pieces of info, google can't calculate market value. Google allows you to enter a "basic" transaction,  which means ONLY  a stock symbol. As an example, below is a query/result from my portfolio.  The 1st symbol has a date,amount and number of shares and so google can calculate market value. The 2nd entry is only a "basic" transaction, and so Google can't calc market value. I hope this helps.

GET /finance/feeds/dchi@gmail.com/portfolios/1/positions?returns=true HTTP/1.1

<entry><id>http://finance.google.com/finance/feeds/dchime...@gmail.com/portfolios/1@</id>                 <updated>2008-10-04T16:22:49.000Z</updated>                 <category scheme='http://schemas.google.com/g/2005#kind' term='http://schemas.google.com/finance/2007#position'/>                 <title type='text'>UltraShort Russell2000 ProShares</title>                 <link rel='self' type='application/atom+xml' href='http://finance.google.com/finance/feeds/dchimento%40gmail.com/portfol...>                 <gd:feedLink
href='http://finance.google.com/finance/feeds/dchime...@gmail.com/portfolios/1/positions/AM@'/>                 <gf:positionData gainPercentage='-0.1127551327' return1w='0.2734328793' return1y='-0.1127551327' return3m='-0.1127551327' return3y='-0.1127551327' return4w='-0.1127551327' return5y='-0.1127551327' returnOverall='-0.1127551327' returnYTD='-0.1127551327' shares='100.0'>                         <gf:costBasis><gd:money amount='9800.0'
currencyCode='USD'/></gf:costBasis>                         <gf:daysGain><gd:money amount='657.0'
currencyCode='USD'/></gf:daysGain>                         <gf:gain><gd:money amount='-1105.0003'
currencyCode='USD'/></gf:gain>                         <gf:marketValue><gd:money amount='8694.9997' currencyCode='USD'/></gf:marketValue>                 </gf:positionData>                 <gf:symbol exchange='AMEX' fullName='UltraShort Russell2000 ProShares' symbol='TWM'/></entry>

#################################################################################################### <entry><id>http://finance.google.com/finance/feeds/dchime...@gmail.com/portfolios/1/po@</id>         <updated>2008-10-04T16:22:49.000Z</updated>         <category scheme='http://schemas.google.com/g/2005#kind' term='http://schemas.google.com/finance/2007#position'/>         <title type='text'>Oracle Corporation</title><link rel='self' type='application/atom+xml' href='http://finance.google.com/finance/feeds/dchimento%40gmail.com/portfol...>         <gd:feedLink
href='http://finance.google.com/finance/feeds/dchime...@gmail.com/portfolios/1/positions/NASDA@'/>         <gf:positionData gainPercentage='0.0' return1w='0.0' return1y='0.0' return3m='0.0' return3y='0.0' return4w='0.0' return5y='0.0' returnOverall='0.0' returnYTD='0.0' shares='0.0'/>         <gf:symbol exchange='NASDAQ' fullName='Oracle Corporation' symbol='ORCL'/></entry

On Fri, Oct 3, 2008 at 5:22 PM, Chris <chri@gmail.com> wrote:

On Oct 3, 11:21 am, Doug <dchi@gmail.com> wrote:

Chris, Could you clarify what you mean by market value performance?

Thanks,

What I mean is the the actual MarketValue for the position. For example, here is the feed that is being returned by this URI:

read more »