1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?> 2*b1cdbd2cSJim Jagielski<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd"> 3*b1cdbd2cSJim Jagielski<!--*********************************************************** 4*b1cdbd2cSJim Jagielski * 5*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 6*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 7*b1cdbd2cSJim Jagielski * distributed with this work for additional information 8*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 9*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 10*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 11*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 14*b1cdbd2cSJim Jagielski * 15*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 16*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 17*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 18*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 19*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 20*b1cdbd2cSJim Jagielski * under the License. 21*b1cdbd2cSJim Jagielski * 22*b1cdbd2cSJim Jagielski ***********************************************************--> 23*b1cdbd2cSJim Jagielski<script:module xmlns:script="http://openoffice.org/2000/script" script:name="Lang_en" script:language="StarBasic">Option Explicit 24*b1cdbd2cSJim Jagielski 25*b1cdbd2cSJim JagielskiSub LoadEnglishLanguage() 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski sProductname = GetProductname 28*b1cdbd2cSJim Jagielski sOK = "~OK" 29*b1cdbd2cSJim Jagielski sCancel = "Cancel" 30*b1cdbd2cSJim Jagielski sColumnHeader = "Column Header" 31*b1cdbd2cSJim Jagielski sInsertStockName = "Please enter shares in your portfolio." 32*b1cdbd2cSJim Jagielski sTitle = "<PRODUCTNAME>: Stocks Manager" 33*b1cdbd2cSJim Jagielski sTitle = ReplaceString(sTitle, sProductName, "<PRODUCTNAME>") 34*b1cdbd2cSJim Jagielski sMsgError = "Input Error" 35*b1cdbd2cSJim Jagielski sMsgNoName = sInsertStockname 36*b1cdbd2cSJim Jagielski sMsgNoQuantity = "Please enter a quantity larger than 0" 37*b1cdbd2cSJim Jagielski sMsgNoDividend = "Please enter the dividend per share or the total dividend" 38*b1cdbd2cSJim Jagielski sMsgNoExchangeRate = "Please enter the correct exchange rate (old shares -> new shares)" 39*b1cdbd2cSJim Jagielski sMsgNoValidExchangeDate = "Please enter a valid date for the split." 40*b1cdbd2cSJim Jagielski sMsgWrongExchangeDate = "Splitting not possible, as transactions already exist after the split date." 41*b1cdbd2cSJim Jagielski sMsgSellTooMuch = "You cannot sell that many shares. Maximum: " 42*b1cdbd2cSJim Jagielski sMsgConfirm = "Confirmation Required" 43*b1cdbd2cSJim Jagielski sMsgFreeStock = "Do you intend to enter free shares?" 44*b1cdbd2cSJim Jagielski sMsgTotalLoss = "Do you intend to enter a total loss?" 45*b1cdbd2cSJim Jagielski sMsgAuthorization = "Security Query" 46*b1cdbd2cSJim Jagielski sMsgDeleteAll = "Do you want to delete all movements and reset the portfolio overview?" 47*b1cdbd2cSJim Jagielski cSplit = "Stock split on " 48*b1cdbd2cSJim Jagielski sHistory = "History" 49*b1cdbd2cSJim Jagielski TransactTitle(1) = "StarOffice Stocks Manager: Selling Shares" 50*b1cdbd2cSJim Jagielski TransactTitle(2) = "StarOffice Stocks Manager: Buying Shares" 51*b1cdbd2cSJim Jagielski StockRatesTitle(1) = "StarOffice Stocks Manager: Dividend Payment" 52*b1cdbd2cSJim Jagielski StockRatesTitle(2) = "Stock Split" 53*b1cdbd2cSJim Jagielski StockRatesTitle(3) = sHistory 54*b1cdbd2cSJim Jagielski sDepotCurrency = "Portfolio Currency" 55*b1cdbd2cSJim Jagielski sStockName = "Name of Stock" 56*b1cdbd2cSJim Jagielski TransactMode = LIFO ' Possible values: "FIFO" and "LIFO" 57*b1cdbd2cSJim Jagielski DateCellStyle = "Result Date" 58*b1cdbd2cSJim Jagielski CurrCellStyle = "1" 59*b1cdbd2cSJim Jagielski sStartDate = "Start date:" 60*b1cdbd2cSJim Jagielski sEndDate = "End date:" 61*b1cdbd2cSJim Jagielski sStartUpWelcome = "This template enables you to manage your stock portfolio efficiently." 62*b1cdbd2cSJim Jagielski sStartUpChooseMarket = "First, select your reference currency and thus the stock exchange for the Internet update." 63*b1cdbd2cSJim Jagielski sStartUpHint = "Unfortunately, the only <History> function available to you is that for the American market." 64*b1cdbd2cSJim Jagielski sStartupHint = ReplaceString(sStartUpHint, sHistory, "<History>") 65*b1cdbd2cSJim Jagielski sNoInternetUpdate = "without Internet update" 66*b1cdbd2cSJim Jagielski sMarketPlace = "Stock exchange:" 67*b1cdbd2cSJim Jagielski sNoInternetDataAvailable = "No prices could be received from the Internet!" 68*b1cdbd2cSJim Jagielski sCheckInternetSettings = "Possible causes could be: <BR>Your Internet settings have to be modified. <BR>The Symbol (e.g. Code, Ticker Symbol) entered for the stock was incorrect." 69*b1cdbd2cSJim Jagielski sCheckInternetSettings = ReplaceString(sCheckInternetSettings, chr(13), "<BR>") 70*b1cdbd2cSJim Jagielski 71*b1cdbd2cSJim Jagielski sMsgEndDatebeforeNow = "The end date has to be before today's date." 72*b1cdbd2cSJim Jagielski sMsgStartDatebeforeEndDate = "The start date has to be before the end date." 73*b1cdbd2cSJim Jagielski 74*b1cdbd2cSJim Jagielski sMarket(0,0) = "American Dollar" 75*b1cdbd2cSJim Jagielski sMarket(0,1) = "$" 76*b1cdbd2cSJim Jagielski sMarket(0,2) = "New York" 77*b1cdbd2cSJim Jagielski sMarket(0,3) = "http://finance.yahoo.com/d/quotes.csv?s=<StockID>&f=sl1d1t1c1ohgv&e=.csv" 78*b1cdbd2cSJim Jagielski sMarket(0,4) = "http://ichart.finance.yahoo.com/table.csv?" &_ 79*b1cdbd2cSJim Jagielski "s=<StockID>&d=<EndMonth>&e=<EndDay>&f=<Endyear>&g=d&" &_ 80*b1cdbd2cSJim Jagielski "a=<StartMonth>&b=<StartDay>&c=<Startyear>&ignore=.csv" 81*b1cdbd2cSJim Jagielski sMarket(0,5) = "Symbol" 82*b1cdbd2cSJim Jagielski sMarket(0,6) = "en" 83*b1cdbd2cSJim Jagielski sMarket(0,7) = "US" 84*b1cdbd2cSJim Jagielski sMarket(0,8) = "409" 85*b1cdbd2cSJim Jagielski sMarket(0,9) = "44" 86*b1cdbd2cSJim Jagielski sMarket(0,10) = "1" 87*b1cdbd2cSJim Jagielski 88*b1cdbd2cSJim Jagielski sMarket(1,0) = "Euro" 89*b1cdbd2cSJim Jagielski sMarket(1,1) = chr(8364) 90*b1cdbd2cSJim Jagielski sMarket(1,2) = "Frankfurt" 91*b1cdbd2cSJim Jagielski sMarket(1,3) = "http://de.finance.yahoo.com/d/quotes.csv?s=<StockID>.F&f=sl1t1c1ghpv&e=.csv" 92*b1cdbd2cSJim Jagielski sMarket(1,5) = "Ticker Symbol" 93*b1cdbd2cSJim Jagielski sMarket(1,6) = "de;nl;pt;el" 94*b1cdbd2cSJim Jagielski sMarket(1,7) = "DE;NL;PT;GR" 95*b1cdbd2cSJim Jagielski sMarket(1,8) = "407;413;816;408" 96*b1cdbd2cSJim Jagielski sMarket(1,9) = "59/9" 97*b1cdbd2cSJim Jagielski sMarket(1,10) = "1" 98*b1cdbd2cSJim Jagielski 99*b1cdbd2cSJim Jagielski sMarket(2,0) = "British Pound" 100*b1cdbd2cSJim Jagielski sMarket(2,1) = "£" 101*b1cdbd2cSJim Jagielski sMarket(2,2) = "London" 102*b1cdbd2cSJim Jagielski sMarket(2,3) = "http://uk.finance.yahoo.com/d/quotes.csv?s=<StockID>.L&m=*&f=sl1t1c1ghov&e=.csv" 103*b1cdbd2cSJim Jagielski sMarket(2,5) = "Symbol" 104*b1cdbd2cSJim Jagielski sMarket(2,6) = "en" 105*b1cdbd2cSJim Jagielski sMarket(2,7) = "GB" 106*b1cdbd2cSJim Jagielski sMarket(2,8) = "809" 107*b1cdbd2cSJim Jagielski sMarket(2,9) = "44" 108*b1cdbd2cSJim Jagielski sMarket(2,10) = "1" 109*b1cdbd2cSJim Jagielski 110*b1cdbd2cSJim Jagielski sMarket(3,0) = "Japanese Yen" 111*b1cdbd2cSJim Jagielski sMarket(3,1) = "¥" 112*b1cdbd2cSJim Jagielski sMarket(3,2) = "Tokyo" 113*b1cdbd2cSJim Jagielski sMarket(3,3) = "" 114*b1cdbd2cSJim Jagielski sMarket(3,5) = "Code" 115*b1cdbd2cSJim Jagielski sMarket(3,6) = "ja" 116*b1cdbd2cSJim Jagielski sMarket(3,7) = "JP" 117*b1cdbd2cSJim Jagielski sMarket(3,8) = "411" 118*b1cdbd2cSJim Jagielski sMarket(3,9) = "" 119*b1cdbd2cSJim Jagielski sMarket(3,10) = "" 120*b1cdbd2cSJim Jagielski 121*b1cdbd2cSJim Jagielski sMarket(4,0) = "Hong Kong Dollar" 122*b1cdbd2cSJim Jagielski sMarket(4,1) = "HK$" 123*b1cdbd2cSJim Jagielski sMarket(4,2) = "Hong Kong" 124*b1cdbd2cSJim Jagielski sMarket(4,3) = "http://hk.finance.yahoo.com/d/quotes.csv?s=<StockID>&f=sl1d1t1c1ohgv&e=.csv" 125*b1cdbd2cSJim Jagielski sMarket(4,5) = "Number" 126*b1cdbd2cSJim Jagielski sMarket(4,6) = "zh" 127*b1cdbd2cSJim Jagielski sMarket(4,7) = "HK" 128*b1cdbd2cSJim Jagielski sMarket(4,8) = "C04" 129*b1cdbd2cSJim Jagielski sMarket(4,9) = "44" 130*b1cdbd2cSJim Jagielski sMarket(4,10) = "1" 131*b1cdbd2cSJim Jagielski 132*b1cdbd2cSJim Jagielski sMarket(5,0) = "Australian Dollar" 133*b1cdbd2cSJim Jagielski sMarket(5,1) = "$" 134*b1cdbd2cSJim Jagielski sMarket(5,2) = "Sydney" 135*b1cdbd2cSJim Jagielski sMarket(5,3) = "http://au.finance.yahoo.com/d/quotes.csv?s=<StockID>&f=sl1d1t1c1ohgv&e=.csv" 136*b1cdbd2cSJim Jagielski sMarket(5,5) = "Symbol" 137*b1cdbd2cSJim Jagielski sMarket(5,6) = "en" 138*b1cdbd2cSJim Jagielski sMarket(5,7) = "AU" 139*b1cdbd2cSJim Jagielski sMarket(5,8) = "C09" 140*b1cdbd2cSJim Jagielski sMarket(5,9) = "44" 141*b1cdbd2cSJim Jagielski sMarket(5,10) = "1" 142*b1cdbd2cSJim Jagielski 143*b1cdbd2cSJim Jagielski' ****************************End of the default subset********************************* 144*b1cdbd2cSJim Jagielski CompleteMarketList() 145*b1cdbd2cSJim Jagielski 146*b1cdbd2cSJim Jagielski LocalizedCurrencies() 147*b1cdbd2cSJim Jagielski 148*b1cdbd2cSJim Jagielski With TransactModel 149*b1cdbd2cSJim Jagielski .lblStockNames.Label = sStockname 150*b1cdbd2cSJim Jagielski .lblQuantity.Label = "Quantity" 151*b1cdbd2cSJim Jagielski .lblRate.Label = "Price" 152*b1cdbd2cSJim Jagielski .lblDate.Label = "Transaction Date" 153*b1cdbd2cSJim Jagielski .hlnCommission.Label = "Other expenditures" 154*b1cdbd2cSJim Jagielski .lblCommission.Label = "Commission" 155*b1cdbd2cSJim Jagielski .lblMinimum.Label = "Min. Commission" 156*b1cdbd2cSJim Jagielski .lblFix.Label = "Fixed Costs/Charges" 157*b1cdbd2cSJim Jagielski .cmdGoOn.Label = sOK 158*b1cdbd2cSJim Jagielski .cmdCancel.Label = sCancel 159*b1cdbd2cSJim Jagielski End With 160*b1cdbd2cSJim Jagielski 161*b1cdbd2cSJim Jagielski With StockRatesModel 162*b1cdbd2cSJim Jagielski .optPerShare.Label = "Dividends/Stocks" 163*b1cdbd2cSJim Jagielski .optTotal.Label = "Total Dividends" 164*b1cdbd2cSJim Jagielski .lblDividend.Label = "Amount" 165*b1cdbd2cSJim Jagielski .lblExchangeRate.Label = "Exchange Rate (old->new)" 166*b1cdbd2cSJim Jagielski .lblColon.Label = ":" 167*b1cdbd2cSJim Jagielski .lblDate.Label = "Exchange Date:" 168*b1cdbd2cSJim Jagielski .lblStockNames.Label = sStockname 169*b1cdbd2cSJim Jagielski .lblStartDate.Label = sStartDate 170*b1cdbd2cSJim Jagielski .lblEndDate.Label = sEndDate 171*b1cdbd2cSJim Jagielski .optDaily.Label = "~Daily" 172*b1cdbd2cSJim Jagielski .optWeekly.Label = "~Weekly" 173*b1cdbd2cSJim Jagielski .hlnInterval.Label = "Time period" 174*b1cdbd2cSJim Jagielski .cmdGoOn.Label = sOk 175*b1cdbd2cSJim Jagielski .cmdCancel.Label = sCancel 176*b1cdbd2cSJim Jagielski End With 177*b1cdbd2cSJim JagielskiEnd Sub 178*b1cdbd2cSJim Jagielski</script:module> 179