#93

As far as I can tell youâll need a script with a âTime-drivenâ trigger to store the value every week to sheet, and then use those values to chart it.

#94

Hmm ok will have a gander

(Alex Sherwood) #95

Has anyone worked out the formula for retrieving market capâs from Google Finance?

`=googlefinance(symbol, "marketcap", date(2019, 1, 2))`

isnât working

(Simran Cashyap) #96

Without tinkering, not sure if historic market caps work. Try without the date?

(Alex Sherwood) #97

That worked, thanks!

#98

How do you display the current value column as US dollars instead of sterling

Iâve been using @simran 's template

Iâve tried simply changing GBP to USD but this has no effect

(Mike Smart) #99

I tweaked mine my just multiplying the dollar amount returned by the current exchange rate:

#100

Donât think I follow

Iâve tried adding âCURRENCY:USDGBPâ but no luck?

(Mike Smart) #101

Without fully seeing the formulas you are putting together itâll be hard to diagnose the problem. But Iâll assume you have returned a dollar value in cell A1, to convert that value to GBP use:

#102

Apolgies, that would help

So Iâve probably wrongly inserted the price paid price as they amount I paid in Freetrade, which is sterling?

Which formulas would you need to see?

The price paid is simply the value
Current value is the formula I posted above ^

(Mike Smart) #103

Does this help at all?

Above will give you the current price for Cisco in USD

Will give you the price in GBP pence

Will give you the price of a GBP share (as determined by column L) in pounds, else USD.

I think.

(Mike Smart) #104

In fact, I donât think you should be displaying the current price in either USD or GBP, choose a currency (most likely GBP) and display all in that.

Youâll find it difficult to display the correct symbol (i.e. \$ or ÂŁ) when using these formulas.

Also, you may want to sum all your current price values, and with difference currencies thatâll be interesting.

#105

I think I follow!

The current value is now displaying ÂŁ0.35 instead of ÂŁ35

Thanks for you help, much appreciated!

#106

Iâve cracked it! Thanks a lot!!

(Simran Cashyap) #107

As @mikesmart said, UK stock prices are returned in pence, not pounds, so the /100 was a hack to change the units. Not the cleanest solution, but as far as I know GBP was the only currency with the problem.

#108

Working a dream thanks

Morning all!

Iâm trying to set up Yahoo finance to track a portfolio but I canât seem to get it to work. Im sure its because Iâve entered a number incorrectly but for the life of me I cannot see where!

Iâve added some random sample data for the point of sharing, but as you can see my total shows ÂŁ7k+ which is defonatly not right.

Here is how I have set up my holding:

Why on earth is the total so high? How do I correct this as the total of the shares Iâve âpurchasedâ is no more than ÂŁ25 and I definatly havnt made ÂŁ7k on top of that in 2 days

(Simran Cashyap) #110

It looks like the ^FTSE is skewing it (as it is measured in pounds not pence and current price is ÂŁ7,160). Try removing that and see if the others falls in line.

In Yahoo Finance, symbols starting with ^ represent an index. I presume you have bought a fund (e.g. ISF) that is tracking the FTSE, so updating to the specific instrument you are holding (which will have a different price) should bring it in line.