Currency Conversion in Numbers

Add a column for CHF, and in the Header Paste the conversion figure. Let's say your Euros are in Column D; then your CHF calculation, assuming they will be in Column E, would be:

=E$1*D

or

=E$1/D

depending on which way you get the conversion from the website.

In a Footer row, write:

=SUM(D)

in Column D and Copy/Paste to the Footer cell of Column E.

Jerry

Here's a way to automate this a little (one click updates the rate):

The script below will place the Yahoo! Finance rate in the target cell here C1.

Copy into AppleScript Editor, click somewhere in table, click green triangle "Run" button.

SG

--click anywhere in table, run; places exchange rate in target cell

property targetCell : "C1"

property symbol : "eurchf=x" --> Swiss Francs per Euro

set sourceText to do shell script "curl -s http://finance.yahoo.com/q?s=" & symbol

set extractedText to extractBetween(sourceText, "yfs_a00_" & symbol & "\">", "</span>")

return placeValueInCell(extractedText, targetCell)

--handlers:

to placeValueInCell(theValue, targetCell)

try

tell application "Numbers" to tell front document to tell active sheet to tell ¬

(first table whose class of selection range is range) to set ¬

value of celltargetCell to theValue

on error

display dialog "Did you select a table?" buttons "Cancel" default button "Cancel"

end try

end placeValueInCell

to extractBetween(sourceText, startText, endText)

set {oTID, AppleScript'stext item delimiters} to {AppleScript'stext item delimiters, startText}

set endItems to text of text item -1 of sourceText-- everything after startText

set AppleScript'stext item delimiters to endText-- get ready to split endText

set textInBetween to text of text item 1 of endItems-- take everything before endText

set AppleScript'stext item delimiters to oTID-- restore original values

return textInBetween

end extractBetween

--end of script

Michael,

The conversion is easily done in Numbers, but the "Live" part would require some scripting; Automator and Applescript. I don't want to discourage you, but I'll just say that if it was me, I'd Copy and Paste from a Desktop Widget. If you have your heart set on this concept, there are examples in the history of these discussions and there are current helpers that will assist you with the scripting.

Jerry

Give us an example of the conversion you want to do and how you want it to appear in the document.

Jerry

Edit: While I am at it, I'll give you theKB instructions for creating a Web Clipping in Dashboard.

To make this work, Create the Web Clip Widget for the currency rate website you prefer. With your Numbers document open, switch to the Dashboard, Select and Copy the rate, switch back to Numbers and Paste the rate into your document.

J.

SGIII,

Thanks for workaround.

Still immensely disappointing that Apple haven't provided a Numbers Function since the code already exists in Calculator.

Really annoying, and, sadly, what we've come to expect from Apple these days.

Dear SGIII,

Thank you very much.
I tried it, but I got this message:

Found. Redirecting to http://finance.yahoo.com/quote/eurchf=x?ltr=1

Is there a way to get a number? 😊

And do you maybe have an idea to check usd vs euro?

Thanks a lot for helping out! 🙂

Kind regards,

Paul

Look at this 2016 post from SGIII, as it incorporates Yahoo URL changes that were not present in 2014.

Does this still work? I tried changing the yahoo url, but in vain.

Thanks

Sorry, found out the solution from another post of yours.. Thank you.. 🙂