Please, don't downvote, instead, some feedback would be appreciated.
Before you continue: Will only work on Apple devices because of the API being used.
You can skip this, just some information: Originally, I found a good looking template that comes with Numbers (Apple) but it doesn't work as expected; Basically it will fail to calculate properly based on different currencies.
General idea was to have something quick, clean, setup-free and portable for Apple devices. Most of the spreadsheets out there are Google-tied. There are a lot of other spreadsheets around fully customizable for Android users.
The spreadsheet works! Per API design, information is updated with PREVIOUS market day closing values.
Check instructions in "Documentation" to override currency settings.
When rebalancing mutual funds, it will calculate how much $ (Cash) to invest, but when doing Stocks / ETFs will do the shares to add and cash too.
For Canadians: TD E-Series values are accurate but with an important delay because of the information not being properly updated by Yahoo.
v1.8a Modifications: - Fixed: Not every label showing in the "Portfolio". - Modified: Portfolio "% Gain" Graphic now showing values. - 52 W. Low / High Graphic in "Watchlist" replaced by Beta Graphic. - Minor tables corrections. v1.8 Modifications: - Reported: Major bug fixed when changing regional and currency settings. - Formula fixed when calculating dividends income. - Several elements locked to avoid dragging on mobile devices. - Watchlist "1y Target" columns modified to make sorting possible. - Watchlist % Growth negative values fixed. - Minor tables fix. v1.7b Modifications: - Fixed formula error in the Watchlist sheet. - Modified tables when scrolling for mobile devices / smaller screens. v1.7a Modifications: - Fixed cell error in the Dividend sheet. - Replaced Dividend's graphic by 2D Donut instead of 2D Bar. v1.7 Modifications: - Working as originally intended: * Just one file for any single country/currency. * Base file provided in Numbers never supported multicurrency independently of the formulas. * Will use as a base the ticker's original currency on which this one is traded. * Depending on the country you live in, the spreadsheet will calculate the proper "Cost Basis", "Market Value" and "Gain". * Support for all major countries and currencies. * The previous setting is based on the device's "Language & Region" configuration. Can be overridden, instructions in the "Documentation" sheet.
"Documentation" sheet modified. Added instructions for currency support and override settings.
"Live Forex Rates & Currencies" provided by Yahoo. Any given difference should be based on this and not on the formulas.
Table optimizations, bug fixes, error handling, removed several calculations.
v1.6 Modifications: - Added % Growth in the Portfolio sheet graphic. - Implemented Dividend income calculation per year in a new sheet. - Added some conditional colouring in the "Rebalance" sheet if "Desired %" is not 0% or 100%. - Some bugs fixes and table corrections. v1.5 Modifications: * Added Multicurrency support and fixed several bugs in the Portfolio page: - "Market Value" and "Cost Basis" per Ticker will be added as in the ticker currency (Do not add a currency format to the cells!) - Total "Market Value" and Total "Cost Basis" will be calculated in the currency you do transactions (Either U.S. or CAD) - Total ticker's gains and the "Gain" total will be displayed in the currency you do transactions (Either U.S. or CAD) If you find any error or problems and/or you need support for any other currency let me know.
So i made this cool script using selenium and python which can copy the live forex rate of usd - pkr and post to facebook by itself in real time you can alter the code youtself for any conversions needed or can just simply comment out the forex part and make an auto poster check this at https://github.com/freakH2O/FacebookAutoPost
The live rates on this page are updated every five seconds, but note that real-time rates used by currency traders are updated more frequently. OANDA is electronically connected to numerous global banks to access the best foreign exchange rates for its traders, and electronic algorithms on OANDA’s fxTrade servers update forex rates tick-by ... *Includes all valid trade and orders requests, excluding those entered on the MetaTrader platform. FOREX.com's execution statistics represent orders executed on FOREX.com's suite of trading platforms during market hours between April 30, 2020 5:00 pm ET and May 31, 2020 5:00 pm ET for FOREX.com's US entity only, excluding trades/orders entered on the MetaTrader platform. North American Edition. Dollar and yen firmness, and sterling underperformance has continued for a second day. The narrow trade-weighted USD index (DXY) lifted to a one-month peak at 93.64, extending the rebound from the 29-month low that was seen last week at 91.75. Forex reserves up by $3.378 bn to record $545.038 bn. Reuters 25 Sep 2020, 19:00. During the reporting week, the forex kitty rose mainly due to an increase in foreign currency assets (FCA), a major component of the overall reserves. eFast is the quickest way to get access to daily live forex quotes to help the investors and traders in the industry understand the ups and downs in the business market. WallSoft eFast services lead the market in providing our clients with round the clock updates on forex quotes, not just to their desktop but to their smart phones as well.
Outstanding! Exchange Rates Debut in Excel - 2274 - YouTube
Just four months ago, the views of my podcast asked if Microsoft could add exchange rates in addition to the stock data type. Breaking news: Excel will now p... 🤟 Discord 🤟: https://discord.gg/W9SkpvV Recommended Forex Broker ICMarkets: http://www.icmarkets.com/?camp=38580 myfxbook Live Results https://www.myfxbook.c... Forex Intraday Live Trade on the 5 Minute Chart In this tutorial I'll show you how to connect to a web-based table of data (in this case a live list of currency rates) and then use that live data to create... The simple video tutorial will show you how to import live currency data from the web into your excel spread sheet. I will also show you how to get this data...