Excel Finance Trick #1: FV PV & Time Value Of Money

I have a CELL that is receiving updating numbers via RTD feed AUTOMATICALLY ie. CELL G1

My Excel 2010 Spreadsheet goes like this:
ie. total volume G1 = 1,333,783 was 1 sec ago
now. total volume G1 = 1,333,883 is right now. A trade on the RTD feed just added 100 stocks.

The real problem is:
I need to check G1 AUTOMATICALLY which is updating AUTOMATICALLY. To compare 'G1 Previous' to 'G1 at the moment' and have a VBA code see if it was added to. (The trick is that G1 has already changed upwards to 1,334,883 by now!

The easy part actually what I want to do is:
To make a single macro fire off just to insert G1 and the whole RANGE 'A1 to G1' to 'I1 to O1' and make the previous 'I1 to O1' to go down 1 row.

The real sticky part is that its RTD so via RTD ADD-IN so they don't like VBA Worksheet Functions: 'calculate' nor 'sheet change'
There is no DDE Windows application running, RTD uses the Excel Add-In infrastructure.

well i dont know weather this is possible or not with Excel 2007, I did this with Google Docs Spreadsheet long before and it was wonderfull.

So hereby I call all genius here to tell me if this is possible.

As the Title says, i want real time stock price in my Excel 2007 from Google finance.
This is easily possible if i have my portfolio ready & i dont add new stocks daily in my portfolio, I simply go to Data > From Web and then somehow i import the Stock Price with Yellow or Green arrow in my excel file.

But my query is little bit different.

For example, Say if

A1 has a value MSFT

then B1 should be http://www.google.com/finance?q=msft
(I used formula =HYPERLINK("http://www.google.com/finance?q="&A1&"")

So now i have a hyper link or URL of Google finance page from which i need to import data.

Now my question is, Is there any possibility that excel opens that links as soon as I enter a new value like GOOG in A1 and import the Stock price automatically in cell C1.

As i have lots of stocks, i dont want to import data manually everytime i add a new stock in my portfolio. I need a formula by which i get the latest stock price as soon as i write a Stock Name in cell A1.

Example

A1 = MSFT
B1 = http://www.google.com/finance?q=msft
C1 = 29.60

A2 = GOOGLE
B2 = http://www.google.com/finance?q=GOOGLE
C2 = 570

It doesnt matters if B1 uses some different formula then Hyperlink, as i am concerned about values in A & C only.

So if i shorten my query in a single sentence, then i would say.

If i write some stock name in A1, then C1 must show its current market price.

I would like to do this with Google Finance only as nothing is as fast as google finance.

I hope this is possible.

Waiting for your replies.
Regards

How do do this Formula in Excel?

http://www.frickcpa.com/tvom/TVOM_Answer.asp?qno=37

how do I do this Formula in Excel?


http://www.frickcpa.com/tvom/TVOM_Answer.asp?qno=37

Hi there,

I need to convert time to money 1 second = 1 cent e.g. 13 seconds = 13 cents or 1 minute 29 seconds = 89 cents

However this is only up to the time of 3 minutes 50 seconds, after that it is 3 minutes 50 seconds to 5 minutes = $2

Can anyone help please?

Thank you Bel

I'm trying to calculate a wage based on minutes.

I have a sheet with a column of time, Column C, which is formatted as h:mm:ss. Most of the entries are minutes and seconds (0:04:13, etc.)

If the rate of pay is 80 cents per minute, how do I sum the minutes and seconds and multiply it times 80 cents per minute (or .013 cents per second)?

Right now I have this formula =SUM(C2:C200) in the F2 cell, formatted as [mm]:ss. The sum is 78 minutes and 13 seconds.

Then in G2 I have this forumla =F2*0.8 and that gives me an incorrect total of $0.04.

Hi, I am looking for help on a formula that will calculate the following.

The basic goal is to be able to input a number that has grown over time at an irregular daily rate and find the original value.

For example: If the value today (1/13/2009) were 1000 and over time it grew at the following rate.

1/10/2009 5%
1/11/2009 -2%
1/12/2009 3%

What would be the best way to calculate the value on 1/10/2009, but relatively easy enough to update daily?

Thanks for your help!

Hi there,

I need to convert time to money 1 second = 1 cent e.g. 13 seconds = 13 cents or 1 minute 29 seconds = 89 cents

However this is only up to the time of 3 minutes 50 seconds, after that it is 3 minutes 50 seconds to 5 minutes = $2

I had the formula =IF(A1>"0:03:50"+0,2,A1*864) but when I applied the time column was not formatted correctly.

That formula worked really well I had tested it as well to make sure it would work- but when I went to use the formula in this months spreadsheet I noticed that the format of the cell is set to general so the numbers look like this 00:00:20.

When I applied the formula I was getting $2 for every answer.

So what do I need to do to fix this - should I format my time column? I tried this but it didn't really change anything. Do I need to add another entry into the formula?

Can someone please help me?
Quesa

Cell b2 is subtracting from b1 to give me a calculation on the amount of time
for that day in b3. But when I try to get cell b4 (which is a dollar
amount) to multiply by b3 (time amount) the answer is wrong. Example, 1:00
(hour) * $10.00. Exel keeps telling me the answer is $0.42, insted of
$10.00. Help!

Hi there,

I need to convert time to money 1 second = 1 cent e.g. 13 seconds = 13 cents or 1 minute 29 seconds = 89 cents

However this is only up to the time of 3 minutes 50 seconds, after that it is 3 minutes 50 seconds to 5 minutes = $2

Can anyone help please?

Thank you Bel