...access). 1.1. Using data from existing DB table tickers_history, calculate 8EMA, 13EMA & 21EMA values as per EMA-examplw.xlsx. See also EMA [kirjaudu nähdäksesi URL:n] for calculation formula description. Note: data table contains records for every two minutes but required calculation 1.2. Store calculation results in different existing DB table ‘emas’ (see em...
1. Help find 60 mom&baby, shopping, or baby product related to Facebook or Instagram accounts 2. Reach out to the accounts and ask them to help post product related posts 3. Increase the brand exposure and awareness over FB/IG
Hi Jay, I am Chet...cryptocurrency, I wish to get this quotes in excel and update it realtime. It should be super easy as in if I add a product then price in the fields should pop up by calling some simple excel formula. Can you please tell me if you would be interested in the project? If yes, how much time you reckon it would take. Thanks, Chetan
I have a row of cells. each cell has an index match formula. I need a formula that will return the first value in the cell that is not "" Attached is the sheet. I want cell F11 to display the result from range G11:Z11
1. Formula for Markup 2. Formula for Volume Pricing A. I have 3 files, same format on each file. Each file has Inventory Sheet & Markup sheet. I (amatear) have used (If) formula, I know you can do better. B. I have try to have volume discount formula and failed. I use hidden columns. I use Teamviewer.
...don't bid without looking at attached worksheet. If you do, I won't even consider your offer. I have written a complicated pricing program in Excel and need assistance finishing it. For this moment you are bidding on debugging the macro "Building 1" Located on the "Quote" Worksheet. The winning person will: *Have advanced knowledge of Excel. *Be able
Hi, I want an FX Trading Indicator developed, it is very simple, I just want it to be shown as a window at the bottom of the chart, like a stochastic, and I want that it uses the following formula: Formula= (X-Average)/STDev where X= Current Price Average = Average of Close Price of number of Periods STDev = Standard Deviation of Close Price of number
...file to change prices from cost price to retail. We imported around 2000 products and used the wrong column so all our retail prices are actually our cost prices. I could do it myself but we need to hire a person as our outside freelancer for all things shopify. So this is a nice test job. If you are also wiz at theme updates that is important since
...Linux server for a very simple program. What it does is this: 1. Gets price of product from an API every "S" seconds. Every "S" seconds there is price-get. 2. Every price-get, the program checks the current price-get against the previous X price-get to see if it exceeds "A" percentage in absolute terms. If it exceeds, the program shall send ...
...[kirjaudu nähdäksesi URL:n] i want a design that contains this message : "30 years Teacher , Whole life Father" and the words "Teacher , Father" are written in periodic elements formula such as the designs i provided link for ------------------------------------------- -------------------------------...
Need formula to calculate day and time for my excel sheet
I need someone to design a template so that I can input the info and it automatically calculates the number of days, based on input. For example, if I input a certain number, a formula in the background will need to calculate the number of days automatically displayed in a weekly calendar form for 2019. For instance, I work in an operations environment
...that page I have a Google Sheet embedded there that allows the user to input data into specific cells (A2, A5, A8) to figure their % of macro's. From Desktop, it works fine but from mobile it does not (Google Sheets doesn't allow edits from mobile I assume). I had originally just sent the Google Sheet to customer but that requires them to use a
...calculations and output these to the console (I will do this, but need you to show me where in the code to do it) (5) Check my current position on a specific equity (eg long 300, short 500, etc), compare this value to the desired value (my formula will calculate that) and trade live when required. If you have the knowledge, skills and professionalism to
...now the definition of the mapping function is made within the main program using the (x+1i*y)-formulation like fxiy = (1/2./(6.*(((x+1i*y).^3))+1)). It would be more convenient to define such a formula in the parameter section in a z-formulation given as a string like fz_string = '(1/2./(6.*z.^3+1))'. This requires a string replacement and applying
Hi, We're going to run a lead magnet that is a software that runs self checks and based on that, it will go through a simple sum formula that will give the final score. Along with the score, it's going to show simple recommendations. That's going to send a call-back with json to our server, like the result of the report. All the checks are the following:
...square meter (m2) price. I need a formula for pricing. Example: A sign is A:190mm x 190mm for $30 (works out to $831/m2). A sign B:290mm x 290mm sells for $58 (works out to $689/m2). If I only work on the Square meter price of Sign A, Sign B would be $69.88 and would be too expensive. So I am looking for a formula that should a sign increase in size
I need a formula or macro to extract URL’s and text between <a href> and </a> tags. There could be up to 20 occurrences per cell. All links merged into one column, and all the text between the anchor text in 1 column. I do have a formula in sheet 1, cell D, but its not correct. I need it to be extended to cater for 20 occurrences per cell, as well
...mathematically, and possibly write an algorithm to go with it. % PREPOSITIONS % COMMON NOUNS % PLURAL NOUNS % BASE VERBS % DETERMINERS % ADVERBS % PRONOUNS % ADJECTIVES The % is defined, but not in above example, since this post is public to freelancer.com. What I Need is mathematical formula or algorithm that states, Based on the % that totals 100%
...beacon UUID, Mac Address, RSSI, distance based on the formula ( Distance = 10 ^ ((TXPower – RSSI)/(10 * N))), time of Mobile phone, GPS location of phone in a file 3- If device is connected to internet, send each data separately by get or post to a webserver 4-if not connected to internet do it Automatically whenever is possible ( each data line to
...up & still succeed ) STORIES Positioning as an expert/authority/leader Launch turns your marketing into a VISIBLE EVENT Connection, Authenticity, Connection + Offer MAKE IT A “CRUSHING” OFFER Not a meek one! Be brave, be bold This is.... Created by Connection & Conversation Sell them what they WANT (their dreams) - but sneak in what they NEED
Need someone who can help with matching two different sheets in excel i.e. GDP growth rates for specific countries in specific years (in one sheet) and matching this with a new column ''GDP Growth'' in a sheet with premiums for M&A-transactions.
I'm trying to make a formula, which will return 'Moving' or 'Not moving' dependent on another value. So, if item has 'NO' demand, and it's activity is below the six month period based on a specific date (01.04.2018) it will be called a 'Not moving' item. If item has no demand, but was transacted in the 6 month period it ...
...difference is in how we price the products. We can calculate an accurate price for the “by dimensions” covers because the user enters the actual dimensions and we use the pricing formula to calculate the price. With the “by model #” covers, the user doesn’t always know the dimensions, so we use a flat price based only on the type of fabric they select. The
...Builderall marketing platform. I would imagine you've already heard about it but if you're not familiar, you can check it out at: [kirjaudu nähdäksesi URL:n] Anyway, I've got a very rough draft of about 3 quarters of the script written out but I'm really having some trouble getting it over the finish line. Ideally, the video presentation woul...
...modeled in excel and also the formal notation as would be written on paper [Example graphs attached]; 1] a formula based on the decreasing rate of increase in price/value of an asset on an exponential/logarithmic scale as a function of time. 2] a formula based on the decreasing of rate of the increase in price/value of an asset on an exponential/logarithmic
...macro: [kirjaudu nähdäksesi URL:n] I need a formula that calculates the similarity of words in the different languages. Attached is a screencast so that you can see it clearly. You have the rest of the information on this link: [kirjaudu nähdäksesi URL:n]
...logarithmic functions modeled in excel and also the formal notation as would be written on paper; 1] a formula based on the decreasing rate of increase in price/value of an asset on an exponential/logarithmic scale as a function of time. 2] a formula based on the decreasing of rate of the increase in price/value of an asset on an exponential/logarithmic
Need a google sheets array that identifies running 7 days Example of my weekly formula that returns if its in a week or not. now i really want running 7 days =ARRAYFORMULA(if(weeknum(today())=weeknum (A2:A19526),"Week",""))
If [kirjaudu nähdäksesi URL:n] = ...Value = Format(Now, "HH:mm:ss") End If End If End If i found this code on internet, but it does not work on excel table.. i want to update timestamp on a particular cell (cell A) based on changes that happens on (Cell B) which is based on formula which is on (Cell C) i want to link entire table cell with static time st...
I need someone to design cars chassis,body panels,upright and hub,intake,and fuel tank. knowledge of vehicle dynamics and suspension working is required .
...the three sides. If the triangle is a right triangle, the base and height are simply the two shorter lengths of the sides. If the triangle is not a right triangle, Heron’s formula can be used for the calculation of the area, A, based on s, the semi- perimeter. The semi-perimeter is just half of the actual perimeter and a, b, and c are the lengths of
...and fitness formula in my website www.mawkish.in. required things are 1. login page with patient biodata including BMR, TDEE, TEE (AUTO CALCULATION) 2. options for making a diet chart 3. option for menu addition 4. option for ingredient addition 5. print out option (maybe some more thing which can be understood on call) I am Delhi Based so it is better
HI! I need help with t...value based on set rules. I need to create a formula that calculates a checksum value based on for example counting every SECOND digit in a number. Please do not answer if you do not have great knowledge in working in Airtable. If you reply also with an example of an airtable database you have built it would be helpful.
Can someone make a excel formula for me on probability of upper case and lower case letters? For example the word "DOCUMENT" . From that single word I wanna make a list of different probabilities of mix upper and lower case. I just want to type in the word on excel and it all the probabilities will appear. Kinda like this. DOCUMENt DOCUMEnT DOCUMeNT
...We are unhappy about the home page sliders. Size changes in different platforms such as iphone or PC make the image text unable to see. I want to change the front page so that it looks more stylish. Sliders are not necessary, we can have a different style for the front page. - There are some pages where text is so small to see and they are in the client's
Hello. I have an issue with open office, please see the attached spreadsheet. As you can see, the boxes that are highlighted I would like those 2 numbers separated and put into the next cell over. Example, Under the FG tab in K10 there are 2 numbers which appear as 29-70. I would like the 29 to stay in K10 and the 70 to move to L10. For all of the highlighted boxes to move over into the next cell ...
I am a retail trader having 2-year exp in trading. I want an AFL on conditions. BUY SIGNAL = I heikanshi candle turns green and closed, I want system to fire buy order to my broker terminal. SELL SIGNAL = If heikanshi candle turns red and closed in red, I want system to fire sell order to my broker terminal. I will be using (1 & 5 ) min candle chart for trading.
...data. If you think you can see a formula, and want to build an Excel file that calculates the prices on their own, that should be fine. If you want to take what I have and manually in between the prices for the dimensions that I do not have filled in, that is fine too. I'm sure it's easier to figure out a formula. Please convince me in your proposal
We would like someone to design a new label for this product. You can see our old design as an attachment, in a white bottle. We want to move away from that and make it a little more stylistic. Please keep in mind that our audience is middle aged. We are changing the white plastic bottle color to amber. Not a lot of limitations here. Please come up
I am looking for a python programmer to develop the code to scrap a website, store it in the pandas’ DataFrame and follow 7 formula to clean up the result. I will give you the 7 rules. I already know the data cleaning issues. You don’t need to spend time to find them all by yourself. I just need their implementation in python. The website includes
On the link below you will find a Google Sheet: [kirjaudu nähdäksesi URL:n] A need a formula on columns F2, F3, F4, F5 that shows the word coincidence between the columns on the left. For example, the sentences "Hello, this is an example." and "Hello, this is an example." have
Excel quick task, just need to find duplicate records and display data based upon that and filters for based upon dates etc.